HomeGuides › How to Use Rep Spreadsheets

How to Use Rep Spreadsheets

Reviewed by SpreadsheetReps Research Team · April 2026

This step-by-step guide covers the complete process of using a rep spreadsheet — from finding the current link to receiving your order. Each step is explained with the practical details experienced buyers use but beginners rarely discover until their first ordering mistake.

Step 1 — Get the Current Link

Never use a bookmarked spreadsheet link without verifying it is still active. Check r/FashionReps wiki or the agent's Discord for the current URL. Paste the link into your browser and confirm the spreadsheet opens. A 404 or redirect means the link has expired — find the current one before proceeding.

Step 2 — Navigate to Your Category

Spreadsheets are organised by tab. Click the tab at the bottom of the Google Sheets interface corresponding to your product category. If you are looking for hoodies, click the Hoodies or Clothing tab. If the category tab layout is unclear, look for a "Navigation" or "Index" tab that lists all categories with tab names.

Step 3 — Search for Your Item

Use Ctrl+F (Cmd+F on Mac) to open the Google Sheets search bar. Type the brand name, item name, or model number. Google Sheets searches only the current tab — for cross-category search, use Find & Replace (Ctrl+H) with "All sheets" selected. Scan through results for entries that have a notes column populated — these represent community-verified finds.

Step 4 — Read the Entry Carefully

Before copying the link, read the notes column. Key information to look for: batch specification (LJR/PK/OG for shoes), sizing notes (TTS = true to size, size up half), seller trust rating, price verification date (compare to CNY price shown on the platform). If any of these fields are blank or seem outdated, treat the entry as requiring additional verification.

Step 5 — Verify the Link is Active

Click the product link before ordering. Confirm the item and variant you want are available at the linked listing. Check that the price matches the spreadsheet reference within a reasonable margin (±20% is normal for older entries). If the link shows a different item or is dead, search the product name directly on Taobao/Weidian for a current listing.

Step 6 — Order Through Your Agent

Copy the product URL. Go to your agent's platform (ACBuy, CNFans, etc.). Paste the URL into the order submission form. Add size and quantity. Review the order confirmation, which typically shows a thumbnail of the item — verify it matches what you selected. Submit the order.

Step 7 — QC Photo Review

When the item arrives at your agent's warehouse (typically 3–7 days for domestic China), you receive QC photos. Compare against community reference posts on r/FashionReps (search the item name + QC). Check your category-specific quality indicators — for shoes, heel tab angle and toe box profile; for clothing, logo placement and stitching. Green Light (GL) to approve or Red Light (RL) to reject and re-source.

FAQ

How do I search a rep spreadsheet?+
Use Ctrl+F within a category tab. For cross-category search, use Find & Replace (Ctrl+H) with All sheets selected. Search brand name, item name, or model number.
What does TTS mean in a rep spreadsheet?+
TTS = True to Size — the community-verified sizing recommendation for that specific item from that specific seller. A note of TTS means buyers who ordered this item found it matched standard sizing.
What is GL and RL in rep buying?+
GL = Green Light (approve and ship), RL = Red Light (reject and re-source). You make this decision after reviewing QC photos from the agent before your item ships from China.

Advanced Techniques

Experienced spreadsheet users apply filters to large category tabs to narrow results efficiently. Google Sheets' filter function (Data → Create a filter) lets you restrict visible rows by column values — for example, showing only items under ¥500, or only items with "LJR" in the batch column. This transforms browsing from scrolling through hundreds of rows to reviewing a curated shortlist.

The community-maintained r/fashionreps subreddit wiki links to current spreadsheets for all major agents. Checking the wiki before each haul (rather than relying on a saved bookmark) takes 30 seconds and ensures you always have the current URL. The wiki is maintained by moderators and typically updated within hours of any link rotation. Building this habit from your first haul eliminates the most common new-buyer frustration.

Common Mistakes to Avoid

The five most common rep spreadsheet mistakes: (1) Using a bookmarked link without verifying it is current — links rotate, bookmarks go stale silently. (2) Reading only the product link and ignoring the notes column — the notes contain critical quality and sizing information. (3) Not cross-referencing with Reddit QC posts before ordering — the spreadsheet tells you where, the community tells you whether. (4) Ordering from a tab that was last updated months ago without verifying prices — CNY prices fluctuate and old entries may be significantly off. (5) Confusing a seller's shop page link with a specific product link — submitting a shop URL to an agent produces an order error, not a product purchase.

All five mistakes are recoverable, but they cost time and occasionally money (if an agent processes an ambiguous order before you can cancel it). Building the verification habits described in this guide from your first order prevents all five.

Data in This Guide

All agent data cited (fees, storage, scores) is verified April 2026. Spreadsheet-specific information (number of items, tab structure) is based on community reports and periodic direct audits of active spreadsheets. Individual spreadsheets vary in structure by platform and by the preferences of their primary maintainers — the general patterns described here apply broadly but specific spreadsheets may organise tabs or columns differently.

Browse verified rep listings

Via chinarepsbuy.com · April 2026
View Rep Finds ↗
Browse All Rep Spreadsheet Guides