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.
Ask Different is a question and answer site for power users of Apple hardware and software. It only takes a minute to sign up.Sign up to join this community
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.