Problems when importing CSV files into Excel/Google Sheets

[woodwindblues]

Hello,

Edit: Never mind, of course I found the solution shortly after posting here. Neither of the programs recognised a dot as the decimal delimiter. In excel this can be changed during the import process (under "advanced"), in google sheets I solved it with find & replace all.

I am running into problems when I try to import the recorded csv files from mind monitor into Excel or Google Sheets:

Google Sheets:

• importing without having google recognise the type of cell contents: everything imports correctly but apostrophes get added in front of all numbers, so they can't be used for any graphs/calculations etc

• importing with automatic type recognition or choosing the type manually after importing: the apostrophe-prefixed number-strings get turned into numbers, but in a wrong format:

Code: Select all

'0.8893718975672459 => 8.893.718.975.672.450,00
'1.289408160005209 => 1.289.408.160.005.200,00
'-0.03053132253523353 => -3.053.132.253.523.350,00

Excel:
Excel manages to convert some of the numbers correctly, but only if they start with a 0

Code: Select all

0.8893718975672459 works
1.289408160005209 => 1.289.408.160.005.200
-0.03053132253523353 works

Can anyone tell me what causes this behaviour and how to solve the problem?

Thank you for your help!

[James]

I've seen issues like that before. I think it's a problem with non English localization.
I'm getting you're from a European country where they use comma as a thousand seperator? e.g. (1,000)
The trouble is CSV stands for "Comma Separated Values", so the comma is very much the standard

You can likely fix this by opening the file in Notepad and putting this at the very top of the CSV file to force whatever is reading it to treat the CSV file as comma separated:
SEP=,