Problems with Excel and CSV Files

I am using Excel 2007 on Windows Vista and I am having problems with my product exports in the CSV format. For some reason when I export my products using the semicolon as the delimeter Excel adds parenthesies.

The export should look like:


But it looks like:


With this format I can’t import my products back into my site. I checked the export with CSVed and the export seems o.k. so I think the problem is how Excel reads the file.

I guess what I am wondering is:

Is there a way to fix this?

Does anyone else have this problem?

What does everyone else use to change their CSV files?

Any help is appreciated.


Export the file using comma instead of semi-colon. Once you make your changes click ‘YES’ to keep the workbook in the current format.

That seems to work for me.


Thank you for the help, that worked perfectly. I just don’t know why I didn’t try this sooner.