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

 

[sandy666]

 

[Ramsee2020]

Yes i did but please read my question..
I do want the csv file open automatically i.e all data
, text and values in columns and values display as numbers so that it is not necessary to convert after opening thd csv
Your help is appreciated

 

[sandy666]

open automatically or convert automatically?
if the second: Data - New Query - From file - From CSV

 

[Ramsee2020]

When i down loaded my bank statement it down loads as a csv file
If i open tbe csv file in excel 2013 all data is correctly displayed. No need to convert.
All text in correct columns. Numerical values can be calculated. No need to first convert
When I open the csv file in excel 2016 it opens as a comma delimited file
All data in one row. I have to convert all data first before i can use it in a spread sheet

 

[sandy666]

an example of csv?

 

[Ramsee2020]

I dont have on mobile. I will send later from laptop.
Thanks for assisting me

 

[sandy666]

CSV incorrectly associated with Excel can cause bad formatting in worksheet
CSV is NOT an Excel file and shouldn't be opened by double click but imported via wizard

Comma-separated values - Wikipedia

en.wikipedia.org

 

[Ramsee2020]

Tx. I understand. But I hve been doing this for 20 years snd ir never eas a problem. 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

 

[MARK858]

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