FAQ: When opening .CSV file all data appears in one column

When you open a .CSV file all your data might appear in one single column separated with commas. This is to do with your computer's regional setting. The best option in this case is to 'import' your .CSV sheet into Excel rather than 'open' it. 

Here's how you do it:

MS Excel 2007 - 2012

1. Open Excel
2. Go to 'Data' tab
3. Select 'From Text' (third option from left) and select the .CSV file you want to import.
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. Click 'Finish' when you're done with editing. 

MS Excel 2003

1. Open Excel
2. Go to 'Data' tab
3. Select 'Import External Data' and then 'Import Data' from the drop down menu.
4. Select the .CSV file you want to import.
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. 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.