When you open a CSV file all your data might appear in one single column separated with commas. This is sometimes an issue with your computer's regional setting. The best solution is to 'import' your .CSV file into Excel rather than 'opening' it.


Here's How You Do It


MS Excel 2007 - 2012


Step 1. Open Excel


Step 2 .Go to 'Data' tab


Step 3. Select 'From Text' (third option from left) and select the .CSV file you want to import.


Step 4. Click 'Next' on the pop-up window. Make sure you tick off 'Comma' selection in the next window. You should see your data applied into columns below already. You can add any other information if you need to here.


Step 5. Click 'Finish' when you're done with editing.


MS Excel 2003


Step 1. Open Excel


Step 2. Go to 'Data' tab


Step 3. Select 'Import External Data' and then 'Import Data' from the drop down menu.


Step 4. Select the .CSV file you want to import.


Step 5. Click 'Next' on the pop-up window. Make sure you tick off 'Comma' selection in the next window. You should see your data applied into columns below already. You can add any other information if you need to here. Click 'Finish' when you're done with editing.