Learning how to use a cnshopper spreadsheet step-by-step is the fastest way to transform your cross-border shopping experience from chaotic to organized. This guide walks you through every phase from initial setup to daily usage, with screenshots, formulas, and real examples you can copy directly into your own sheet.
Step 1: Choose Your Platform
The first decision is where to build your cnshopper spreadsheet. We recommend Google Sheets for most users because it is free, cloud-synced, shareable, and accessible from any device. Excel works well if you prefer offline storage or need advanced macro capabilities.
Step 2: Set Up Your Columns
Create these 12 columns in row 1 of your cnshopper spreadsheet. Each column serves a specific purpose in your tracking workflow:
| Column | What to Enter | Example |
|---|---|---|
| A: Order Date | Date you placed the order | 2026-05-20 |
| B: Order ID | Platform order number | TB987654321 |
| C: Item Name | Product description | Yeezy Slide Onyx |
| D: Seller | Store name on platform | KicksWorld2024 |
| E: Price CNY | Item price in yuan | 450 |
| F: Price USD | Auto-converted via formula | =E2*GOOGLEFINANCE(...) |
| G: Shipping | Shipping cost to your address | 55 |
| H: Total | Sum of USD + Shipping | =F2+G2 |
| I: Tracking | Carrier tracking number | LP987654321CN |
| J: Status | Current state (dropdown) | In Transit |
| K: Quality | Your 1-10 rating post-delivery | 9 |
| L: Notes | Any extra details | Fast shipping, true to size |
Step 3: Add the Currency Conversion Formula
In cell F2 (your first Price USD cell), enter this formula:
=E2*GOOGLEFINANCE(CURRENCY:CNYUSD)This pulls the live CNY-to-USD exchange rate automatically. Your cnshopper spreadsheet will always show accurate pricing without manual updates.
Step 4: Create Status Dropdowns
Select the Status column (column J), then go to Data → Data Validation. Choose "List of items" and enter: Ordered, Paid, Shipped, In Transit, Delivered, Issue, Cancelled. This ensures consistent entries and enables filtering.
Step 5: Apply Conditional Formatting
Go to Format → Conditional Formatting and create these rules for your Status column:
- Text is Delivered → Green background (#E3E9DC)
- Text is In Transit → Yellow background (#F5F1E8)
- Text is Issue → Light red background (#FDF0ED)
- Text is Shipped → Light sage background (#E3E9DC)
Step 6: Enter Your First Order
Copy information directly from your purchase confirmation page into the cnshopper spreadsheet. Start with the order date, ID, item name, seller, and price. The formulas will handle the rest.
Step 7: Update Daily
Spend 5 minutes each morning updating statuses and checking tracking numbers. This small habit prevents orders from falling through the cracks and keeps your cnshopper spreadsheet accurate.
FAQ
Q: How often should I update my spreadsheet?
Daily is ideal. At minimum, update twice per week to keep statuses current.
Q: Can I track multiple platforms in one sheet?
Yes. Add a Platform column (Taobao, Weidian, etc.) to differentiate orders.
Q: What if a formula breaks?
Formulas rarely break in Google Sheets. If one does, copy the formula from a working cell above it.
Q: Should I share my spreadsheet with others?
Only if you trust them. Use view-only links for sharing templates, never your live data.
Conclusion
Now that you know how to use a cnshopper spreadsheet step-by-step, the only thing left is to start. Download a free template, set up your columns in the next 10 minutes, and add your first order. Within one week, you will wonder how you ever shopped without it.
Start Shopping Now