Mastering the USFans Spreadsheet
The USFans spreadsheet is a powerful tool, but only if you know how to navigate it efficiently. In 2026, the spreadsheet has grown to thousands of rows across multiple categories, making manual scrolling impractical. Learning a few navigation tricks will cut your browsing time by more than half and help you find items that match your exact preferences for batch, size, and price range.
Basic Search and Filter
Most spreadsheet platforms — whether Google Sheets or Excel Online — support Ctrl+F for text search and filter dropdowns on column headers. Start by filtering to your target category, then use the price column to narrow by budget. The batch code column lets you filter for specific tiers. Combining multiple filters is the fastest way to find viable options without scrolling through hundreds of irrelevant rows.
Fast Navigation Workflow
Open Filters
Click the filter icon on the header row. Enable filters for Category, Batch, and Price columns.
Filter Category First
Narrow to Shoes, Hoodies, or whatever you need. This eliminates 80% of unrelated rows instantly.
Set Price Range
Use the price filter to set a minimum and maximum. This prevents budget shock and hides items outside your range.
Batch Code Filter
If you know you want mid-tier or better, filter out budget batches. If you are experimenting, do the opposite.
Sort by Date Added
The newest items are often at the top or bottom. Sort by date to see recent additions first.
Column Meanings
Image Column
Usually a thumbnail or link. Click to see the supplier's product photo before copying the link.
Batch / Code
The factory or production run identifier. Search this on Reddit for real buyer photos and reviews.
Price
Typically in Chinese Yuan. Convert mentally at roughly 7.2 CNY to 1 USD, or use a column conversion.
Product Link
The supplier URL. Copy this and paste into your agent's 'order by link' field.
Keyboard Shortcuts
| Shortcut | Action |
|---|---|
| Ctrl + F | Find text in the sheet |
| Ctrl + Shift + L | Toggle filters on/off |
| Ctrl + Home | Jump to top-left cell |
| Ctrl + End | Jump to last used cell |
| Ctrl + Space | Select entire column |
| Shift + Space | Select entire row |
Advanced Tips
Bookmark the spreadsheet URL with your preferred filters already applied — some platforms preserve filter state in the URL. Use browser tabs to compare multiple items side by side. If the spreadsheet is slow to load, consider downloading a local copy for offline browsing, but remember that prices and stock change daily. For mobile browsing, landscape mode makes the spreadsheet much more usable than portrait orientation. Create a personal notes document where you paste links, batch codes, and your own observations so you do not lose track of interesting items across sessions. Many experienced buyers maintain a private wishlist document with columns for item name, batch, price, and notes on Reddit feedback they found.
Version Control and Backup Copies
The USFans spreadsheet changes frequently. Items are added, removed, or repriced daily. If you find an item you are interested in but are not ready to buy, save a screenshot or copy the row data into a personal document. Do not rely on bookmarking the spreadsheet cell — the row may shift or disappear. Some buyers create a backup copy of the spreadsheet every few days so they can track price trends and spot when a previously out-of-stock item returns. This level of organization pays off when you are comparing multiple batches or waiting for a specific item to restock.
