Why Do Banks Give You Statements in PDFs Rather Than Csv?

Why do banks give you statements in PDFs rather than CSV/XLS files you can run computations on?

First, it seems that only column A is made of numbers. Second, I understand it is private information, but it is very hard to figure out what went wrong in this particular case without seeing the actual data. For example, on cell E11, is it only digits or is it any combo ? For example 10432.98 could be represented as 10.432,98 or as 10 432,98 or 10 432.98. When you import, Did you make sure you picked the right import format? Third, you could always correct its content by formulas. As you can see, substitution of “,” by “.” solved the problem here in this case. You could probably write a formula like =1*SUBSTITUTE(SUBSTITUTE(D1,”,”,”.”),” “, “”) The two imbricated substitute eliminate spaces and replace comma with period then, the multiplication force Excel to attempt changing (not really since it multiplies it by 1!) the resulting numerical text into a true number made of a product of 1 by something. But your best bet is probably to open the CSV manually to see how your fields are made and apply the right data format in the Text/CSV import wizard. If it still doesn’t work, find a way to show us more of your current file format.