The best tools are the ones you actually use. In this guide, we walk you through every click, setting, and customization needed to get your free cnshopper spreadsheet running in under 10 minutes. No signups, no paywalls, no complexity. Just copy, customize, and start tracking.
Download Free ToolsStep 1: Choose Your Template
Start by reviewing the free template comparison to find the one that matches your business model. Beginners should start with the Starter Reseller template. Bulk buyers should grab the Inventory Master version.
Step 2: Make Your Own Copy
Never edit the original template directly. In Google Sheets, go to File > Make a copy. In Excel Online, click Download a copy. This ensures your data stays private and the original stays intact for future reference.
Step 3: Rename and Organize
- Rename the file to include your business name and year (e.g., "CNShopper_Tracking_2026").
- Move it to a dedicated folder in Google Drive or OneDrive.
- Bookmark the direct link for quick daily access.
Step 4: Customize Columns
| Column | What to Change | Why |
|---|---|---|
| Currency | Set to your local currency | Accurate profit display |
| Tax Rate | Update percentage in formula | Correct net calculations |
| Platform Fees | Enter your marketplace rates | True profit visibility |
| Shipping Estimates | Adjust per your carrier | Accurate landed costs |
Step 5: Delete Sample Data
Templates include sample rows to show you how the sheet works. Delete these rows before entering real data, but do not delete the header row or formula cells. If you accidentally delete a formula, restore it from the original template copy you made in Step 2.
Step 6: Enter Your First Real Data
Start small. Log one product and one order. Verify that the profit formula calculates correctly. Check that dropdown menus appear in status fields. Confirm that conditional formatting highlights the row in the right color. Once one row works perfectly, paste in the rest.
Step 7: Share or Keep Private
If you work alone, keep the sheet private. If you have a team member or virtual assistant, click Share and assign editor or viewer permissions. Never set it to "Anyone with the link" if it contains customer data. See our safety guide for details.
Visit Our Main WebsiteFAQ
Do I need a Google account?
For Google Sheets templates, yes. It is free to create. Excel templates work with any Microsoft account.
Can I use these templates offline?
Google Sheets has an offline mode. Enable it in Settings before you need it. Excel works offline natively.
What if I break the formulas?
Keep your original template copy untouched as a backup. Also, Google Sheets version history can restore any past state.
Are there video tutorials?
Our step-by-step guide covers every action in detail with screenshots.