Csv files

[Ramsee2020]

When i down loaded a csv file and opened it in excel 2013 all data is loaded correctly in the excel worksheet. I.e all data is in columns and numerical values are displayed as numbers.
When I open a csv file in excel 2016 all data is displayed as comma delimited data in one row.

Is there a setting in excel 2016 that i can use to avoid the long process of converting data into colums

 

[navic]

Still doing it with excel 13 but for some inknown reason excel 2016 on my other laptop does not do it. Nobody have an explanation

This below is copied from the link.
Maybe it can help you.

CSV files are character separated value files, not necessarily comma separated. For more than half the world the separator character is a semicolon (; ), not a comma (,)
Excel 2016 properly respects your Windows regional settings, and uses the specified List Separator character
One solution is to change your regional settings for the List Separator attribute to the character you want Excel to default to using, e.g. a comma (,)
This can be changed in the operating system Control Panel, under Region settings, Additional Settings, List separator
For various reasons some people seem to have the incorrect regional settings for the culture they most commonly work in, and therefore have semicolon as the default separator
If you prefer not to change your operating system regional setting to what you think is normal for CSV files, you can change the default behavior in Excel with the Use system separators checkbox under the File/Options/Advanced menu
If you want custom options each time you open a CSV file, use the Data/From Text menu, but this becomes slow and awkward for lots of files
CSV References:

• Decimal separator - Wikipedia (see map of world using comma as decimal point separator, it's very common, and hence CSV's often use semicolon separators)
• CSV files use delimiters other than commas - Data-gov Wiki
• Comma-separated values - Wikipedia (spec point 3)
• https://ec.europa.eu/esco/portal/escopedia/Comma-separated_values_%28CSV%29
• https://parse-o-matic.com/parse/pskb/CSV-File-Format.htm

 

[Ramsee2020]

Will check let u know. Am not home right now

 

[Ramsee2020]

What is your default character for the list separator in your Windows regional settings on the laptop with 2016 , or ;?

Sorry. I do not find regional settings in windows10

 

[MARK858]

Control Panel - Clock and Region - Region - Additional settings - check the List separator.

 

[Ramsee2020]

Thank you. It is a comma

 

[Ramsee2020]

You can only use point or comma. Nothing else

 

[Ramsee2020]

Should I change it to a point ( . )

 

[MARK858]

You can only use point or comma. Nothing else

You can change it to anything you like, you just manually type it in and click apply

Should I change it to a point ( . )

No
Check what it is set as in excel, as below

If you prefer not to change your operating system regional setting to what you think is normal for CSV files, you can change the default behavior in Excel with the Use system separators checkbox under the File/Options/Advanced menu

If it is set as , then we need to see the CSV file as sandy666 has already requested.

 

[Ramsee2020]

Thank you very much. Will do and see if it has any effect

 

[Ramsee2020]

In excel 2016 the system separator is a comma (,)
Should i change it?