Hi xfinancnik, please use the UTF-8 or the file encoding type that is best tailored for your character set, then open it in Open Office – fill in your language and file encoding – or via Import Data from CSV within Excel and set the File Encoding option.
Hi there,
I do have the same problem with german characters like öäü etc.
Can you describe this once again slow?
I go tu plugin Site – Export – Choose as “Character encoding” UTF-8 and “Add BOM character” – YES.
When I open the .csv-file with Excel, the Characters look all like this: e.g. “- bis 60° befüllbar und spülmaschinengeeignet”.
What do you mean with “fill in your language and file encoding”? Should I manually change all characters?? That would be a lot of work, wouldn’t it?
Thanks for your help.
Hi 11Rick11, open WooCommerce > Store Exporter from the WordPress Administration, then open the Settings tab, and on that screen set the File encoding option to UTF-8, under CSV Settings there is an option called Enable BOM, turn this on too. That’s all.
You do not need to fill in any characters, just select the encoding type that matches your local character set (e.g. for Germany UTF-8 is fine), opening with Excel is another story as Excel doesn’t like UTF-8.
Open a new Excel spreadsheet then from the Data tab click Import from File and select the same encoding type that you used for the export (e.g. UTF-8), this will fix the CSV file in Excel for that session, use OpenOffice, it’s alot better at handling file encoding. 🙂
