I have a problem opening my .csv files in Excel; when importing them, all the information is in one column. How do I get Excel to separate the information automatically into different columns?
I have a MacBook Pro and I’m using Excel 14.3.8.
How to open CSV file with Microsoft Excel and get the information into separate columns
csvms office
Related Solutions
Assuming you have a valid/consistent CSV file, create a new workbook and then choose File -> Import. The first option on the list is "CSV file":
From the Home tab, select the cells you wish to format, and from the format drop-down under Number select Custom. Or, right-click and choose Format Cells, or hit Cmd-1.
This will pop-up a dialog window with the various formatting options.
Again, make sure you're on Custom.
In the Type box type in: 000000
Click Ok.
Alternatively - change the formatting type to text. This will keep whatever you type in the box.
Best Answer
It is interesting that if you really have a comma separated text file, you actually have to select the comma separator, the only separator that is selected by default is "Tab".
The final screen, when "Finish" is enabled, will show a sample of how your data will be imported so you can see before you finish that it will be properly separated into columns.