If you’re encountering error messages while importing your CSV to CoinTracker, we’ve compiled tips to help you resolve them.
If you’re having trouble importing your CSV but aren’t receiving an error message, try the one of the troubleshooting steps below.
Check missing transactions
The CSV successfully imported, but some rows were ignored due to missing or unsupported data. As a result, the transactions related to those rows will be missing. Follow the steps to check and fix missing transactions.
Reformat trading pairs
CSV transaction histories often categorize trades using the trading pairs. For example, if AREA is traded for USDT, it might be listed as AREA_USDT and categorized as a Sell:
To accurately represent this data, separate the trading pair into individual entries:
- Buys: The asset on the left (base currency) is what you acquire. It should be recorded in the Received Currency column. The asset on the right (quote currency) represents what you used for the purchase, and should be noted in the Sent Currency column.
- Sells: The base currency (asset on the left) is what you're selling, so it goes in the Sent Currency column. The quoted currency (asset on the right) is what you receive in return, so it should go in the Received Currency column.
For example, in a trade of AREA_USDT, AREA is the base currency (what you’re selling) and should be recorded in the Sent Currency column, while USDT is the quote currency (what you receive) and should be entered in the Received Currency column.
Import with smaller files
If your CSV file exceeds 40,000 rows, split it into smaller files and import them. To ensure they’re counted as one wallet, import the first file to create a wallet, then use the Import transactions option to add the remaining files.
Use Google Sheets
Solutions work similarly across spreadsheet programs like Microsoft Excel, Google Sheets, or others. For formatting issues, especially with dates and times, we recommend Google Sheets for its consistent handling of CSV formatting.