To get a BBVA statement into CSV, first check whether your own online banking offers a CSV or Excel download for the period you want. If it does, the usual trouble is not the download but how the sheet reads it: euro files often use a comma as the decimal mark and a semicolon between columns, so amounts and dates can land in the wrong cells. The fixes below are about the sheet, not about any bank screen.
Why do my amounts look wrong after opening the file?
Many European files write 1.234,56 for one thousand two hundred and thirty-four euros and fifty-six cents. A sheet set to a locale that uses a decimal point reads that as text, or as a wrong number. Some CSV files also separate columns with semicolons, so everything lands in one column.
| Raw text in the file | What a point-decimal sheet shows | After conversion |
|---|---|---|
| 1.234,56 | Text, cannot be summed | 1234.56 |
| -45,90 | Text | -45.9 |
| 12,00 | Text | 12 |
How do I convert them?
- Use the sheet's import tool for text or CSV files, and choose semicolon as the separator if the data is in one column.
- Set the locale of the file or the sheet to match where the file comes from, if the tool offers it.
- If you must fix by formula, with the text in C2 and a sheet that uses a decimal point, use =SUBSTITUTE(SUBSTITUTE(C2,".",""),",",".")+0. It removes the thousands dots and swaps the comma for a point.
- Fill down and copy the result as values before deleting the original column.
What about dates?
Day-first dates such as 03/07/2025 mean the third of July in this style, and a sheet in a month-first locale reads them as March 7th. Check a row where the day is above twelve, such as 25/07/2025, since that cannot be a month. If the day-first dates are text, =DATE(RIGHT(A2,4), MID(A2,4,2), LEFT(A2,2)) builds a real date.
How do I check the result is complete?
Take made-up euro totals: opening balance €2,340.10, credits €1,800.00, debits €2,065.45. The closing balance should be 2,340.10 + 1,800.00 - 2,065.45 = €2,074.65. Add the converted credit and debit columns and compare. If the debits sum is lower, some amounts probably stayed as text, and a sheet quietly skips text in a sum.
When a sheet stops being enough
For one account a sheet is fine. If you add more accounts or want automatic categories, SpendixAI accepts statements as PDF, CSV or Excel with a review step before anything is saved. It is built around India and rupees, so judge whether it fits a euro account before using it.
What if the description column splits into two?
When a description contains the same character the file uses as a separator, the row can break into an extra column. A row such as 12/07/2025;Supermercado; compra tarjeta;-48,20 has one semicolon too many. A good import tool treats text in quotation marks as one cell, so choose that option. If your file has no quotation marks, look for rows with one more cell than the others and merge those cells by hand.
A last habit worth building: keep the raw file exactly as the bank gave it, and do all conversions on a copy. If a formula goes wrong at row 300, you can start again from the original in a minute. Name the copy with a suffix such as cleaned, and write the date you converted it in the first cell of a notes tab, so that months later you know which version your totals came from.
Checklist
- Separator and locale set before conversion.
- Dates verified on a row with a day above twelve.
- Amounts are numbers, not text.
- Opening plus credits minus debits equals closing.
- The original file is kept untouched.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


