Problems with Excel and CSV Files

General General Questions
1

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:



MA00180L;T;0.01



But it looks like:



MA00180L;“T”;“0.01”



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.



Brandon

2

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.

3

Baballuci



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





Brandon