Importing from csv loses decimal formatting

1

Hi Community!

I’m having trouble importing data from a csv file. After running the import process, I see that the numerical values with decimals have been altered.

This is the original excel file:

image

And this is the data imported to Coda:

image
image.png318×696 4.05 KB

Do you know what might be going on?

1 Like
2

Hi @Ruben_Digital,

I assume that your *.csv file uses the European formatting 12,56 (comma) and Coda uses the USA formatting 12.56 (dot)

Just covert your *.csv to USA format.

2 Likes
3

It worked, thank you @Jean_Pierre_Traets!!

1 Like