Understanding the Spreadsheet Architecture
The JoyaGoo spreadsheet is not a simple list. It is a multi-tab research engine that connects buyers to hundreds of sellers across eleven major categories. In 2026, the master spreadsheet contains over forty individual tabs, each serving a different purpose. There are category browsing tabs, a changelog tab, a seller blacklist tab, a shipping cost reference tab, and several community-contributed specialty lists. Understanding which tab does what will save you hours of confusion and prevent you from missing better options hidden two tabs to the right.
Each category tab—Shoes, Hoodies, T-Shirts, Jackets, and so on—follows a standardized column layout. From left to right you will typically see: Item Name, Seller/Source Link, Price Range, Size Availability, QC Photo Link, Seller Rating, Community Notes, and Last Updated timestamp. Some tabs also include a Fabric/Material column and a Weight column, which matters enormously for shipping cost calculations.
The Notes column is the most underutilized resource on the entire spreadsheet. Experienced contributors leave detailed fit reports, material quality observations, known flaws, and even wash-test results. A blank Notes column does not necessarily mean an item is bad—it may simply mean nobody has purchased and reported back yet. Conversely, a Notes column full of detailed observations usually signals an active, well-scrutinized listing.
Your First Hour with the Spreadsheet
Bookmark the Latest Version
The spreadsheet updates weekly. Save the current master link in your browser and check the changelog tab for the last update date. If the version is more than 14 days old, ask in the community Discord for the current link.
Make Your Personal Copy
Click File > Make a Copy in Google Sheets. This preserves your custom filters, wishlist highlights, and personal notes without affecting the public master. You can return to the master anytime to refresh data.
Apply Filters Immediately
Use Data > Filter Views to set your default view. Filter by your size, your budget ceiling, and a minimum seller rating of 4.0. This eliminates 70% of noise instantly.
Read Changelog Before Browsing
The changelog tab lists every recent addition, price change, and seller rotation. Spending five minutes here prevents you from falling in love with an item that was delisted yesterday.
Set Up a Wishlist Tab
Create a new tab in your copy. Paste item names, seller links, and your personal priority ranking. This prevents impulse purchases and helps you bundle orders intelligently.
Hidden Tabs Most Beginners Miss
Seller Blacklist
A community-maintained list of sellers with repeated QC failures, non-delivery reports, or communication breakdowns. Check this before every new purchase.
Shipping Calculator
An embedded formula that estimates total landed cost based on item weight, destination country, and carrier line. Essential for budget planning.
Size Conversion Index
A cross-reference table mapping common Asian sizing notation to US, UK, and EU standards with body measurement ranges.
Restock Alert Log
Community members note when out-of-stock items return. Check before assuming your size is permanently gone.
Advanced Filtering Strategies
Once you understand the basic structure, the real power of the spreadsheet comes from advanced filtering. In 2026, the most successful buyers do not scroll—they query. Google Sheets filter views allow you to stack multiple conditions simultaneously. For example, you can filter the Shoes tab to show only items where the price is between $40 and $80, the seller rating is above 4.2, the Notes column contains the word "comfortable," and the size column includes your exact measurement.
Another underused feature is conditional formatting. Apply color scales to the Price column so budget-friendly items turn green and premium items turn red. Apply a second conditional format to the Last Updated column so listings older than 90 days fade to gray. This gives you an immediate visual priority map without reading every row.
Finally, learn to use the search box within the tab itself rather than your browser's find function. The tab search filters rows in real time, which is far faster than scrolling through hundreds of entries. Combine the search box with column filters for surgical precision. Looking for a specific sneaker silhouette? Search the Item Name column while filtering by price and rating. The combination typically narrows 400 entries down to 3-5 viable options in under a minute.
Weekly Spreadsheet Maintenance Routine
Power User Secret
The Notes column often contains hidden gems written in shorthand. A note that says "tts, heavy, slight chemical smell -> wash once" tells you the item is true-to-size, premium weight, and the smell issue is resolved with one laundry cycle. Learn to read these micro-reviews.
