Csv files

Ramsee2020

New Member
Joined
Mar 8, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
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
 

Ramsee2020

New Member
Joined
Mar 8, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
The question is why does it open in my version of excel 2016 as a comma delomted file
All info in one row
 

Some videos you may like

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
7,055
I don't understand your question
as in post#38 your csv is opened properly
maybe you should show example what you want to achieve?

I'll try again
did you double click your example csv file and what you see after that ?

what else you can do is update your Office 2016 to the last updates
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,112,785
Messages
5,542,503
Members
410,559
Latest member
jordansmith6532
Top