Skip to main content
CSV import is the fastest way to get a year of spreadsheet history into Churning Tracker. Map your columns once, save the mapping, and reuse it for every future import. Learn how Churning Tracker compares to manual spreadsheet tracking on the product site.
CSV import upload screen

​
The 4-step workflow

Go to Orders → Import to start.
1

Upload

Drag in your CSV file. Churning Tracker auto-detects the header row and previews the first few rows.
2

Map columns

Match each column in your CSV to a Churning Tracker field. The system suggests mappings based on column names.Save the mapping with a name (e.g., “My old spreadsheet”) to reuse on future imports.
3

Validate

Every row is checked for required fields, valid dates, and known retailers. Errors show inline so you can fix them in the CSV and re-upload.
4

Import

Confirm the row count and run the import. Orders and line items are created in batch.

​
Field mappings

Below is the full list of fields you can map. Required fields must be present for the import to run.

​
Order fields

​
Line item fields

Repeat one row per line item, or use a single row per order with comma-separated lists.

​
Order total fields

​
Shipping & tracking

​
Saved mappings

Once a mapping is saved, the next import picks it automatically when the column headers match. You can also pick a saved mapping manually from the dropdown.
CSV column mapping screen with saved mappings dropdown

​
Validation errors

Common issues you’ll see in the validation step:
  • Unknown retailer — fix the spelling or add the retailer first
  • Invalid date format — reformat in your CSV
  • Missing required field — fill in or map a different column
  • Duplicate order number — Churning Tracker won’t import an order with the same number twice for the same retailer
Fix errors in your source CSV, not in the UI. That way you can re-import the corrected file cleanly if anything else needs to change.

​
After import

  • Orders appear in the Orders list immediately
  • Shipment tracking starts on any tracking numbers included
  • Payouts are not imported — see CSV imports for payouts below or log them manually

​
Other imports

Beyond orders, you can also import:
  • Credit cards — from the Credit cards page
  • Point balances — from Points → Balances
  • Account owners — from the Account owners page
Each follows the same 4-step workflow with its own field set.