Create Your Own CNShopper Spreadsheet Easily

Sometimes a template is close but not quite right. Maybe you need extra columns for customs declarations. Maybe you want a different currency format. Maybe you just prefer building things yourself. This guide teaches you how to create a cnshopper spreadsheet from a completely blank Google Sheet in under thirty minutes.

No spreadsheet experience is required. We explain every click, every formula, and every design choice so you end up with a sheet that feels like it was built specifically for you — because it was.

Phase 1: Set Up the Structure (5 Minutes)

Open a new Google Sheet. Name it. Then add your header row. Here is the minimal viable header set that works for 90% of buyers:

Phase 2: Add Formulas (10 Minutes)

Formulas are what separate a spreadsheet from a notebook. Start with these three:

Phase 3: Design and Color (10 Minutes)

Good design is not vanity — it is readability. Freeze the header row (View → Freeze → 1 row). Bold the headers. Set alternating row colors (Format → Alternating colors). Add conditional formatting to the Status column. These small touches make your sheet professional and fast to scan.

Phase 4: Test and Lock (5 Minutes)

Before you trust this sheet with real money, test it. Enter five fake orders. Change statuses. Sort columns. Check that formulas update correctly. Then protect your formula columns so you do not accidentally overwrite them during a late-night update session.