If your euro CSV opens in Excel as one crowded column, or amounts such as 1.250,50 will not add up, the file and your computer disagree about two characters: the column separator and the decimal mark. Fix them by telling Excel how the file is built when you import it.
Why do commas cause so much trouble?
In many European regional settings the comma is the decimal mark, so a file that wants to separate columns with commas would break every price. Those systems often save CSV files with semicolons between columns. Send that file to a person whose computer expects commas, or the other way round, and the columns collapse or the numbers turn into text.
| File style | Column separator | Decimal mark | Example row |
|---|---|---|---|
| Comma style | comma | point | Groceries,52.40 |
| Semicolon style | semicolon | comma | Groceries;52,40 |
How do you open the file correctly?
- Open a blank workbook and choose Data, then From Text/CSV.
- Select the file and look at the preview.
- Change the delimiter to semicolon or comma until the columns separate.
- Use the Transform Data option if amounts stay as text.
- Set the amount column's locale or use Replace to swap the decimal mark.
- Load the data and save it as a normal workbook.
What does a worked total look like?
Say three rows read 52,40 for groceries, 1.250,00 for rent and 18,60 for transport. A computer expecting decimal points will not read these as numbers. After conversion they are 52.40, 1250.00 and 18.60, and the total is 52.40 + 1250.00 + 18.60 = 1,321.00. If your total in the sheet is 0 or an error, the amounts are still text.
Is there a formula fix if import is not possible?
There is. If the amounts are text with a decimal comma and thousands points, this works on a setup that uses a point as the decimal mark: =VALUE(SUBSTITUTE(SUBSTITUTE(C2,".",""),",",".")). It first removes thousands points and then swaps the comma for a point. On a system that already uses a decimal comma, you would not need it. In many European setups the formula separator in Excel is also a semicolon, so the arguments may need semicolons between them instead of commas.
Accents and symbols
- Names such as cafe names with accents can show as pairs of strange characters
- Set the file origin to UTF-8 in the import window
- The euro sign can break the same way, so check a known row
Making exports calmer
If you create the CSV yourself, pick one convention and keep it. SpendixAI is built around India and INR, so it does not target euro accounts, but its CSV download shows what to aim for: plain headers and one transaction per row.
Should you convert the file or your computer?
Changing your computer's regional settings affects everything else you do, so it is usually better to convert the file during import. Choose the locale in the import window so that amounts in the file are read the way they were written. Then save the sheet as a workbook, which stores real numbers and no longer depends on separators. When you send data to someone else, a plain table in a workbook avoids the question entirely; send a CSV only when the receiving system asks for one, and say which separator it uses.
Checklist
- Delimiter checked in the preview
- Decimal mark checked on a known amount
- Amount column passes ISNUMBER
- Encoding set to UTF-8
- Original file kept
Useful ideas start with a clearer picture of your own spending.
Explore your reports

