I have come across a problem or maybe this is normal and there is a step I am missing.
I export a csv of all products, and import into excel using data - From text. set all parameters and then view in excel.
I have tried removing all “& a m p ;” and replaced with & thinking that the html entities are causing issues…
I am wondering if the html in the magento descriptions are causing a problem? I manually input all these descriptions using the WYSIWYG editor in the magento general product tab.
I have tired opening in open office, excel and CSVed.
Click thumbnail to see full-size image