Excel doesn't properly parse .csv files on opening

Dickison

Board Regular
Joined
Jun 12, 2002
Messages
75
Recently I cannot get Excel to properly open a .csv file. All the data goes into column A without parsing. I know I can easily convert it to columns using text to column or importing it, but I just want it to do it automatically like it used to. I've checked the data with Notepad and confirmed that the data is ok. How do I get it to open automatically parsed?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

nbrcrunch

Well-known Member
Joined
Jan 1, 2003
Messages
2,062
When you open the file, your choice in the "Type of File" box is set to?......
 

Dickison

Board Regular
Joined
Jun 12, 2002
Messages
75
the option to specify the file type is when you import a file. I can import it, but by default Excel has always been able to correctly parse a .csv file. I've been opening .csv files for years without a problem just by double clicking on the icon for the file. When doing that it always parsed out to separate columns. Now everything goes into column A. I would like to find what setting changed and put it back to the way it was so I don't have to go through extra steps to import or convert to columns.
 

Dickison

Board Regular
Joined
Jun 12, 2002
Messages
75
I found the problem. The file was saved as unicode rather than ansi. When I changed it to ANSI it worked ok.

Thanks
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,052
Messages
5,835,142
Members
430,343
Latest member
Sailingexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top