In order to successfully import large CSV files (files with more than 3,000 transactions), you must split the file into smaller files of 3,000 transactions or less. Follow this guide to get your file to a size that can be imported via TaxBit's generic CSV converter.
Headers
It is imperative that each file you import has the correct headers. The headers for generic CSV files should be the following:
| Date and Time | Transaction Type | Sent Quantity | Sent Currency | Sending Source | Received Quantity | Received Currency | Receiving Destination | Fee | Fee Currency | Exchange Transaction ID | Blockchain Transaction Hash |
Each file you split must have these headers in the top row.
Splitting Transactions
Begin with your original file. Skip to line 3001. From that line, copy all data to line 6,001. Paste that data into a new CSV file with the headers listed as described above. Save the new file. Continue this process in increments of 3000 transactions until you reach the end of your original file.
Importing the Files
Import each file using the regular generic CSV import process. Follow this article to import the file, selecting "Upload a Generic CSV" on Step 3: https://help.taxbit.com/hc/en-us/articles/4403274294295-How-to-Add-a-CSV-File
Once your file has been imported, you will see a message appear notifying you that your file has been imported successfully.
Still have questions? You can interact with our Chatbot by selecting the Chat Widget located at the bottom right side of your screen, or fill out this form HERE to submit a support inquiry request. Our team is happy to help!
Disclaimer: Keywords below are added to articles to enhance searching for content within our Help Center.
Keywords:
Large CSV
Split CSV
CSV Too Big