Trying to manage our company's products through bulk csv uploads. I very much prefer to work in Excel. Mainly because of sorting by color on items I've conditionally formatted. And some other smaller issues with say Google Sheets or Open Office, etc.
As I understand it, Excel doesn't play nice with Magento csv exports for a few reasons: 1) Non Native UFT-8 Format 2) commas in product data (for example product descriptions) mess up column alignment when opening the file.
Is there a way to export pipe delimited (I only see csv as file type in our native export page)? Or some other way to properly open the file in excel to mitigate against these 2 issues listed above?
Bonus points: is there a way to have all the additional_attributes export into their each / own column?
