Importing csv files from the bank

users
#1

Hi,
I am having troubles importing csv files from the bank. When I import the files, they do not include decimal figures, only whole numbers, so the system won't balance. Any ideas as to how to get the whole figures imported?

Best regards,
Vicki Nielsen

#2

You have checked that the columns with amounts in aren't formatted to integers only?

#3

What Bank and what version of LO?
My bank (Lloyds UK) exported csv files show the decimal places...

#4

If the number has a monetary symbol after it, use find-and-replace to add decimal, zeroes and remove symbol in Writer or most document software.
Then import.

More complex.
Use Base to import and then copy to Calc.

Hope this helps.

#5

Hi :slight_smile:
Yes, can you open the Csv by right-clicking on it and "Open with ..." a
text-editor such as Notepad or Gedit or Kate or something?

Hopefully that might show that the values in the Csv file do have 2 decimal
places!

If the Csv file doesn't have decimal places in it's values then they are
doing something weird but we might be able to figure out what and how to
correct for it.
Regards from
Tom :slight_smile:

#6

I see your name is Nielsen, which could indicate that you are Danish or
Norwegian. Can it be that you have one of these two languages/regions
as your default, which means, amongst other things that the decimal
separator is a comma. If you are importing from an english or american
bank, the decimal separator will be a dot.

James

#7

Indeed I believe this should be the problem.

To solve just select "english/us" on the amounts columns when you import
CSV.

In this way it should consider and replace decimal dots with your country's
decimal separator (comma).