How to open CSV file with Microsoft Excel and get the information into separate columns?
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".


Select the CSV file to import.
Select "Delimited" in the "Text Wizard Import 1 of 3" dialog.
Make sure the "Comma" checkbox is checked in the "Text Wizard Import 2 of 3" dialog.
Unselect "Tab" if you have tabs embedded in your data in the same dialog.
Continue with the text wizard dialogs and select finish.


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.