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.
To over come this problem you can do one of the following methods,
Solution 1:
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.
Solution 2:
The problem is from regional Options . The decimal separator in win 7 for European countries is coma .
You have to open Control Panel -> Regional and Language Options -> Additional Settings
or
In the Region and Language window, click on the Additional Settings button.
In the Decimal symbol field enter '.' and in the List separator field enter ','
Click on Apply and then on OK.
Now you can directly open .csv files without importing them.