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
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,420
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile

Some videos you may like

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

Ramsee2020

New Member
Joined
Mar 8, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
Thank you again.
I guess there ia no solution to my problem. I will install 2013 on my other laptop
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
13,420
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
  2. Mobile
I guess there ia no solution to my problem.
Not what I said in my last post... by the way my 365 opens them fine by default if they are comma separated.
 

Ramsee2020

New Member
Joined
Mar 8, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

Thank you. Will do.
 

Ramsee2020

New Member
Joined
Mar 8, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows
Thanks.The file downloaded correctly but I see there are no numericals so i dont know if numbers will display as tex or as numerical values
i attach hereto my csv file
I tried send the file but error message
-----The uploaded file does not have an allowed extension----
 

Ramsee2020

New Member
Joined
Mar 8, 2020
Messages
26
Office Version
  1. 2016
Platform
  1. Windows

ADVERTISEMENT

here is a screen shot of my csv file
1583756020963.png
 

Watch MrExcel Video

Forum statistics

Threads
1,112,783
Messages
5,542,497
Members
410,557
Latest member
chidambaramseetha
Top