Encountering issues when uploading a CSV file using the CoinTracker CSV format? You're in the right place! This guide will walk you through solving common errors users often face during the CSV import process.
Please make sure you have reviewed our CSV formatting guide for in-depth instructions for converting CSVs to the CoinTracker format before troubleshooting.
Error Messages When Importing CoinTracker CSV Format
Here are common error messages you may encounter when attempting to import the CoinTracker-compatible CSV format to CoinTracker:
"File is missing the following headers:"
Problem: Your CSV file must have the correct header row to be accepted.
Solution: Add in the missing headers.
- The error message will say which column headers are missing. Or, compare the header row of your CSV with the template provided by our website.
- Make sure each column is present and correctly named.
- Rename any headers that don't match exactly with the template, and ensure there are no additional, missing, or misspelled headers.
- The header on your CSV should be exactly the same as this:
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
"Invalid date format in row"
Problem: The date is formatted incorrectly.
Solution: Change date format to MM/DD/YYYY HH:MM:SS. Note: time is optional, but date is required.
"Missing Received Quantity, Received Currency, Sent Quantity and Sent Currency. At least one of them is required in row:"
Problem: In any row, there must data in:
- "Sent Currency" and "Sent Quantity", if sending assets out of the wallet
OR - "Received Currency" and "Received Quantity", if receiving assets into the wallet
OR - "Sent Currency", "Sent Quantity", "Received Currency" and "Received Quantity", if a trade within the wallet
Solution: Review the row indicated for missing missing data in one of these columns: Sent Currency", "Sent Quantity", "Received Currency", "Received Quantity"
"Currency should not be empty in row:"
Problem: Currency is missing for the specified row
Solution: Review row for missing data in "Sent Currency" or "Received Currency"
"Ignored [#x] crypto transaction(s) because they are missing data or are not supported"
Problem: The CSV successfully imported, but certain rows were ignored because they were missing data or had unsupported data—this will cause the transaction related to that row to be missing.
Solution: Check for the common causes of this error message:
Unsupported tags
Problem: Only certain CoinTracker CSV tags will be accepted by the importer—any other text will cause the import to fail or ignore the row containing an unsupported tag.
Solution: Review "Tags" column of your CSV and make sure the text exactly matches one of the available 'CoinTracker CSV Tags' listed in this help article, including case and underscore: Transaction Category Definitions.
Unsupported token symbol
- Review the missing transactions to see which token was ignored from the import.
- Check to see if CoinTracker supports the token
- If the token is not supported, create a custom currency
- If needed, edit your CSV to ensure the token symbol matches the custom currency and import CSV
"Unsupported tag in row"
Problem: Only certain CoinTracker CSV tags will be accepted by the importer—any other text will cause the import to fail or ignore the row containing an unsupported tag.
Solution: Review "Tags" column of your CSV and make sure the text exactly matches one of the available 'CoinTracker CSV Tags' listed in this help article, including case and underscore: Transaction Category Definitions.
"Could not parse [quantity type] Quantity in row: [row #]"
Problem: the data in the indicated column and row is not expected. This could be due to the wrong type of input (for instance, text where there should be numbers, as in the 'Quantity' columns) or missing data (for instance, data in the 'Received Currency' column, with no corresponding data in the 'Received Quantity' column).
Other Issues When Importing CoinTracker-Compatible CSV Format
Here are some import issues that may not have an associated error message:
Transactions Missing From Wallet After Import
Problem: The CSV successfully imported, but there are transactions missing from the wallet when viewed in CoinTracker. This indicates that rows with missing or unsupported data were ignored while the rest of the rows were accepted
Solution: Review common causes of missing transactions after import:
Unsupported tags
Problem: Only certain CoinTracker CSV tags will be accepted by the importer—any other text will cause the import to fail or ignore the row containing an unsupported tag.
Solution: Review "Tags" column of your CSV and make sure the text exactly matches one of the available 'CoinTracker CSV Tags' listed in this help article, including case and underscore: Transaction Category Definitions.
Unsupported token symbol
- Review the missing transactions to see which token was ignored from the import.
- Check to see if CoinTracker supports the token
- If the token is not supported, create a custom currency
- If needed, edit your CSV to ensure the token symbol matches the custom currency and import CSV
Token pairs in currency column(s)
Transaction history in CSV formats often categorize trades using token pairs. For instance, a trade where AREA tokens are exchanged for USDT might be listed as "AREA_USDT" and categorized as a "Sell":
To accurately represent this data, it's necessary to separate the token pair into individual entries:
Buy Transactions: When purchasing, the token on the left (base currency) is what you acquire, and it should be recorded in the 'Received Currency' column. The token on the right (quote currency) represents what you used for the purchase and should be noted in the 'Sent Currency' column.
Sell Transactions: When selling, the base currency (token on the left) is what you're selling and should be entered in the 'Sent Currency' column. The quote (token on the right) currency, which is what you receive in return, goes in the 'Received Currency' column.
Large CSV Files Fail to Import
For best results, import CSV files with 40,000 rows or fewer. If your CSV file has more than 40,000 rows, split it into smaller files.
To ensure the smaller files are counted as one wallet in CoinTracker, follow these steps:
- Import your first CSV file to create a wallet.
- Use the 'Import transactions' button on the created wallet to add all subsequent files.
For more details, refer to How to Import Transactions into a Synced Exchange or Imported Wallet.
Using Different Spreadsheet Programs
Solutions are generally the same whether you're using Microsoft Excel, Google Sheets, or another spreadsheet program. However, if you encounter formatting issues, especially related to date and time, we recommend using Google Sheets because it tends to handle CSV formatting more consistently.