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:

Mac Numbers

1. Drag the file to the Numbers icon in the Dock or in the Applications folder.

2. Click anywhere in the table to select it.

3. In the Format sidebar, click the Table tab, then click Adjust Import Settings.

4. Click the Delimited tab in the Import Settings window.

5. Select 'Comma' delimiter options next to Separate Values Using, or enter a custom delimiter.


MS Excel 2003

1. Open Excel
2. Go to the '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 select 'Comma' in the next window. Click 'Finish' when you're done with editing.

Mac Numbers

1. Drag the file to the Numbers icon in the Dock or in the Applications folder.

2. Click anywhere in the table to select it.

3. In the Format sidebar, click the Table tab, then click Adjust Import Settings.

4. Click the Delimited tab in the Import Settings window.

5. Select 'Comma' delimiter options next to Separate Values Using, or enter a custom delimiter.

1. Open Excel
2. Go to the '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 select 'Comma' in the next window. You should see your data applied into the columns below already. You can add any other information if you need to here. Click 'Finish' when you're done with editing.

Did this answer your question?