CSV file opening as a text format

  • Thread starter Thread starter Washeacrim
  • Start date Start date
W

Washeacrim

At the moment i have CSV files opening up in Excel as a text format ie where
all the data is seperated by a comma and is located in the first column ie
112,334,33443,,,,12

How do I get the CSV file to automatically open so that the data is in
separate columns? ie 112 334 33443 "blank" "blank" "blank"
12
 
At the moment i have CSV files opening up in Excel as a text format ie where
all the data is seperated by a comma and is located in the first column ie
112,334,33443,,,,12

How do I get the CSV file to automatically open so that the data is in
separate columns? ie 112 334 33443 "blank" "blank" "blank"
12
Click to expand...
It should really open that way by default, but there a one or two
exceptions I've come across. The first issue I had was where the commas
were not the expected ascii value. If this is the case then you need to
replace all the commas with the right ones.

Another possible reason is that excel is actually set to open them that
way, in one of the options menus. This might have been done by another
user. These menus vary by version, but you can read about them by
looking at the help file, under importing data.
 
Back
Top