Before you troubleshoot
Most CSV issues are easier to fix by starting from CoinTracker's template and formatting guide:
- Download CoinTracker's CSV template and copy your transaction data into it.
- See our CSV formatting guide for detailed instructions on each column.
If you see an error message during import
Missing or incorrect headers
Error: File is missing the following headers
Your CSV's header row must match CoinTracker's template exactly — same columns, same names, same order.
The header row should read exactly:
| Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H |
|---|---|---|---|---|---|---|---|
| Date | Received Quantity | Received Currency | Sent Quantity | Sent Currency | Fee Amount | Fee Currency | Tag |
Rename any headers that don't match, remove extra columns, and reorder so the sequence matches the template.
Invalid date format
Error: Invalid date format in [row]
Missing quantity or currency data
Errors: Missing received quantity, received currency, sent quantity, and sent currency and at least one of them is required in [row] · Currency should not be empty in [row]
Every row needs one of these combinations:
- Sent Currency and Sent Quantity — for outgoing transactions
- Received Currency and Received Quantity — for incoming transactions
- All four — for trades within the same wallet
Open the row flagged in the error and fill in the missing data, then retry the import.
Quantity can't be parsed
Error: Could not parse [quantity type] quantity in [row]
The quantity columns must contain numbers only. Remove text, currency symbols, spaces, and thousand-separator commas from the value.
Unsupported tag
Error: Unsupported tag in row
The Tag column only accepts specific values recognized by CoinTracker. Match the exact text — including capitalization and underscores — or leave the column empty if the row doesn't need a tag or if there isn't a tag available for the transaction activity.
Ignored transactions after import
Error: Ignored [#x] crypto transaction(s) because they are missing data or are not supported
CoinTracker imports the file but skips specific rows. Two common causes:
- Unsupported cryptocurrency. Create a custom currency for the asset, update the symbol in your CSV to match, and re-import.
- Missing data in required columns. Each row needs a Sent Currency and Sent Quantity, a Received Currency and Received Quantity, or all four for trades. Review the ignored rows and fill in any missing data.
After fixing the rows, re-import the file to add the skipped transactions.
If the import looks wrong but showed no error message
Trading pairs show as a single entry
Many exchanges export trades as a single pair like AREA_USDT. CoinTracker needs each side of the trade split into the Sent and Received columns.
- Buys: base currency (left side) → Received Currency. Quote currency (right side) → Sent Currency.
- Sells: base currency (left side) → Sent Currency. Quote currency (right side) → Received Currency.
For example, a sell of AREA_USDT means AREA goes in Sent Currency and USDT goes in Received Currency.
The file is too large to import
CSV files over 40,000 rows can't import as a single file. Split the file into smaller chunks and add them to the same wallet:
- Import the first chunk. CoinTracker creates a new wallet from that file.
- Open the wallet, then select Import transactions to add the remaining chunks.
All chunks land in the same wallet as long as you use Import transactions for each one after the first.
Dates or times aren't recognized
Excel sometimes rewrites CSV date and time formatting when you open or save the file. Google Sheets handles CSV date formatting more consistently. If dates keep getting reformatted, open and save the CSV in Google Sheets before importing to CoinTracker.
If you run into any trouble, please don't hesitate to reach out to our support team via Chatoshi for help.