How To Fix Date Format In Standard CSV

How To Fix Date Format In Standard CSV

If you are seeing the wrong year appearing for the date of a trade on the trading tab, or if you get an error message that says no date (or something similar) when you try to import trades, but you know there is a date column, please try the steps below to correct the issue. 

 

1- Open the file in Excel

2- Select the whole Date column (1)

3- Navigate to the Data tab (2) at the top

4- Click the Text to Columns (3) option

5- In the pop up window select Fixed width (4), and click Next (5)


6- On the next screen click Next (6)


7- Make sure the section that contains the date is selected (7), and choose Date (8)

  • If the Next button (9) is available, click it, and select the next section (10), then choose Do not import confirm (skip) (11). Repeat those steps for any additional section. 
  • If the Next button (9) does not appear, simply click Finish (12)

8- Finally click OK (13)

Following those steps should allow you to create a CSV file that will import all the information correctly. 

    • Related Articles

    • Standard CSV Formatting & Sample Files

      The Standard CSV import option allows you to import trades from a generic CSV file that you create yourself. This is the best way to import large amounts of data from exchanges that do not support automatic importing. Most exchanges (and wallets) ...

    • How To Locate And Fix Unmatched Trades ("More Sales Than Buys")

      If your capital gains seem inaccurate, you see a message in red saying "more sales than buys" in the Calculate Tab, or you see trades highlighted in red on the Reports & Export Tab, you have unmatched trades that need to be corrected. An unmatched ...

    • Checklist For Resolving Unmatched Trades

      Below is a list of the reasons that could cause an unmatched trade. Read through them, and if you answer yes to a question, expand it, so you can see how to correct that specific reason. Your account may have unmatched trades caused by multiple ...

    • Bitcoin.Tax Doesn't Support My Exchange - What Now?

      We are always working to add support for requested exchanges/wallets. When users submit their CSVs for these sources, it helps us to determine if the CSV provided has all of the proper information in order to support it. If you'd like to share your ...

    • Trading Tab

      The Trading Tab is the first place you should start - it's where you will import the majority of your data. The Trading Tab will consist of all your cryptocurrency trades: your BUYS and SELLS. Keep in mind, a "trade" can be viewed as both a "buy" and ...