Bank statement CSV to Excel
A CSV export is already tabular, so this is less about parsing and more about normalisation. Banks export the same information in wildly different shapes — two amount columns, local date formats, currency symbols baked into the numbers.
The four things that differ between bank CSVs
These are the variations that make two exports from two banks incompatible with each other:
- Debit and credit as two separate columns, instead of one signed amount.
- Dates as DD/MM/YYYY, MM/DD/YYYY or a bare serial number, with no indication of which.
- Amounts wrapped in quotes with a currency symbol and thousands separators, which Excel reads as text.
- Columns in a different order, sometimes with extra reference and category columns interleaved.
What normalisation produces
One table with the same four columns every time: date as YYYY-MM-DD, description as plain text, amount as a signed number, balance as a number or empty. That consistency is what lets you stack twelve months of exports and get a single pivot table out the other end.
Watch the sign convention
Some banks export withdrawals as positive numbers with a separate type column. Taken at face value, a month of spending looks like income. The converter reads the type column and applies the sign, so a negative amount always means money left the account.
Questions
Will it handle a semicolon-delimited export?
Yes. European bank exports often use semicolons and decimal commas; both are detected and normalised to a standard decimal point.
Can I merge twelve monthly exports into one sheet?
Convert each, then stack them in one sheet and deduplicate on date, description and amount. Overlapping periods are the usual source of doubled rows.
Is the original file modified?
No. The source is read only; the result is a new file you download.
Other formats
Try it on your own statement
No account, no card, no email. Convert one file and check the rows against the original.
Open the converter