When exporting transactions to Excel the .CSV format is used. The comma is used as separator. However the comma is also used as a delimiter for the thousands. As a result importing transactions or balances larger than one thousand messes things up.
Example:
03 May 2017 , Exchange to EUR , , €15.71 , , , 1, 298.05, general
Because of the comma “1,298.05” is interpreted as two separate values “1” and “298.05” in stead of the value “1298.05”.
You might remove the comma as delimiter for thousands when exporting to CSV. Thanks!
Just came across this too. The date is also not idea as it needs a special date format to be selected in order to be converted. This makes is ver tedious to export the data to budgeting apps such as YNAB. Another option would be to suply the data in a standard .qif or Microsoft money format.
I also don’t get why they don’t even add the time of the transaction when they even show it in the app. Is it that hard to proper format a simple csv? Why??
Up! This issue has been known since Jul 2017 already. 4 years!
When exporting the historical data into a csv, the digit grouping symbol that is commonly used in the UK and in French-speaking country is the comma (,). However, this (,) can be found in the description name of each transaction and in the thousands separator. When generating the csv, this leads to extra (empty) columns instead of column ‘Completed date’, ‘Description’, to ‘Notes’.
Hence, a transaction which description is “Bought XAG with GBP FX Rate £1 = 0.04621 XAG, Fee: £0.27” is splitted in two columns “Bought XAG with GBP FX Rate £1 = 0.04621 XAG” (column C) and “Fee: £0.27” (column D).
A transaction in paid in which is “1,000£” (column D) is split in 2 columns “1” (col. D) and “0” (col. E). Opening that exact file in a Google Sheet gives you “1” and “000”.
This is still an issue. OS language is set to Polish on my phone. I’m getting something like this in the “CSV”:
25.02.2021 , aliexpress.com , 5,80 , , , , 12,04, Zakupy,
Good luck with parsing this
It should be
25.02.2021 , aliexpress.com , 5.80 , , , , 12.04, Zakupy,
Something changed during the last weeks indeed.
Good thing: I can save CSV directly and not forced to use GMail to send it to myself.
Bad thing: using same character for separators as for number separator.
My banking application cannot work with that. I can configure it for different characters so I don’t care that much about which character is used for what but the field separator must be unique!
Has anyone reached out to the official support yet?
I also have this problem when trying to upload my revolut crypto portfolio to koinly.io and accointing. Owing to Revoluts poor CSV format , I have to painstakingly amend revoluts CSV or enter each transaction manually. It’s awful. Revolut isn’t a good place to buy cryptoassets or report on them.
Same here with hungarian settings. The numbers contains commas, so the CSV is unusable!! Please fix this and use semicolons as seperator or point in the numbers
One file as the input, regular expression replaces “,” to “.” but only for those occurrences where “,” was between digits. The second file as the output. That’s all.
It happened to me yesterday upon first time I have needed to do it. I was in a “Live Chat” session with ultimately 2 support guys on this subject. Whether this had anything to do with the rollout of v8 - who knows?
The 1st support guy sent me the same csv file which opened up in my excel, and it was perfect in terms of formatting the numbers greater than 999.99 but the columns were completely different, ie new columns, ordered differently, the transaction “Notes” column dropped/missing. They seemed to think this was a non-issue, resolved previously, or an unknown bug. As a retired computer programmer/support analyst I assume they did not extract the file as a “customer” and their extract was handled correctly. As the chat went on way beyond 1am thhe issue was not resolved and I closed the chat
It seems Revolut solved all CSV issues by removing support for the format altogether. I cannot find it on my iOS app anymore. Anyone here can see anything else than PDF export (related Data export - #5 by valtf ).