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. If you need a more complete guide on how to convert CSV files to the CoinTracker CSV format, please take a look at our CSV formatting guide.
Remember: Ensure your file is correct format by using our template
- Download the correct CSV template from CoinTracker. You can find it here.
- Open the template with Google Sheets for optimal compatibility.
- Check that your CSV file aligns with the format specified in the template.
Complete instructions for formatting your CSV for import are available here.
Solutions to Common CSV Errors
“Header is invalid” Error Message:
- Problem: Your CSV file must have the correct header row to be accepted. An invalid header often means that the columns in your CSV don't match what our platform recognizes.
- Solution: 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 the same as this:
Date Received Quantity Received Currency Sent Quantity Sent Currency Fee Amount Fee Currency Tag
“File Does Not Contain Any Transaction Rows” Error Message:
- Problem: This error pops up when your CSV file doesn't have any transaction data, meaning it's either empty beneath the header row or the transaction data is incorrectly formatted.
- Solution: Verify that your CSV file includes at least one row of transaction data below the header. Ensure that this data is correctly formatted according to our template. Each transaction must be on a new row, and each detail of the transaction must be in the correct column.
“Transaction is missing required data” Error Message:
- Problem: Each transaction row in your CSV needs certain essential data for our system to process it. If any required data is missing, you'll encounter this error.
- Solution: Check each transaction row in your CSV to confirm that no required data is missing. Required fields will vary based on the transaction type but generally include Date, Received/Sent Quantity, and Received/Sent Currency. If any fields are left blank in your transaction rows, fill them in with the appropriate data.
Problem: If you've converted a CSV to the generic format and have included a tag that is not supported in the "Tag" column, it will cause the import the fail. The only supported tags are: gift, lost, donation, margin fee, fork, airdrop, mined, payment, staked, margin, margin rebate, or interest.
- Learn more about how tags modify your transaction data with our Transaction Tag Definitions guide.
- Solution: Remove any tags that are not supported.
- Problem: If you've converted a CSV to the generic format and have included a tag that is not supported in the "Tag" column, it will cause the import the fail. The only supported tags are: gift, lost, donation, margin fee, fork, airdrop, mined, payment, staked, margin, margin rebate, or interest.
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, try using Google Sheets. It tends to handle CSV formatting more consistently. If using Excel, double-check your data formats, particularly dates (MM/DD/YYYY HH:MM:SS is preferred).