Importing Trading212 transaction history CSV files as-is - Date error
Using my History export from Trading212, I'm trying to get a CGT calculation from the https://ukcgt.xyz/ tool.
I get a stream of errors like this:
14/07/2026, 21:55:29 - ERROR: Line 1: Invalid date '2025-03-20 12:15:31+00:00'.
Line 2: Invalid date '2025-03-28 14:16:00+00:00'.
Here are the header and a sample data row from my CSV:
Action,Time (UTC),ISIN,Ticker,Name,Notes,ID,No. of shares,Price / share,Currency (Price / share),Exchange rate,Result,Currency (Result),Total,Currency (Total),Withholding tax,Currency (Withholding tax),Stamp duty reserve tax,Currency (Stamp duty reserve tax),Currency conversion from amount,Currency (Currency conversion from amount),Currency conversion to amount,Currency (Currency conversion to amount),Currency conversion fee,Currency (Currency conversion fee)
Limit buy,2025-04-24 08:39:54+00:00,GB0005603997,LGEN,"Legal & General",,EOF31555637768,300.0000000000,236.7000000000,GBX,100.00000000,,,713.65,"GBP",,,3.55,"GBP",,,,,,
I am assuming that there is a conversion step needed to convert the Trading212 CSV format into a clean format for this CGT tool to accept. For a start, the time probably needs stripping from the Date column. But could not find a ready made converter so far. What am I missing?
probably you have loaded the CSV into a spreadsheet and saved it? Your spreadsheet has saved the date/time in a strange format?
You should just download the .csv files and then load them into ukcgt.
Or else T212 have changed the csv format recently?
I tried a alternative calculator and it was also behaving strangely, giving me all zeroes. Found the email address of the developer and sent a description of the issue.
Turns out that Trading212 had indeed changed the format of its History CSV export file (within the last month or two), seems the Date column was renamed or something. The dev did a fix overnight and when I tested the next day, all good, it nicely identified missing purchases (transferred in ones) for me to enter the details of manually, then it did a plausible calculation.
While I'm here, one enhancement that would be nice to have is an auxiliary more detailed report that one could spot check, just a sanity check for certain gain/loss on certain stocks of interest.
If this xyz calculator gets a fix I will try it too.
Thanks for letting me know. v4.29 should take care of the new UTC time code format used by T212. please try it and let me know.
You need to include all transactions for all years - right from day 1.
When you have tried it, come back to me with more details about your gains/loss query if necessary.
cheers
Steve