I am desperate for some help. Everytime I export a report of products sold into CVS from the site, it comes out with special characters in them replacing some of the vowels.
Like this: "gyerek okosÃ³ra kiegÃ©szÃtÅ‘" instead of this "Gyerek okosóra kiegészítők". These are hungarian characters.
I have tried switching to hungarian excel, nothing changed. I made sure it is decoded as UNICODE (UTF-8) and tried to import from CSV or txt format. Again nothing changed. The problem is that the CSV dowloaded from Shopify already contains these characters and I can't think of anything else to do to change them back.
Please let me know if you know any solution to this, it would mean a lot.
Solved! Go to the solution
Excel doesn't support opening CSV files with UTF-8 characters so try doing the following:
Hopefully that helps.
Are the characters correct within Shopify? If so can you send me a sample of the file to my email and I will have a look? - email@example.com
This is an accepted solution.
The solution was to open the file with notepad not excel. In there confirm the characters look ok so there was no issue with export.
Then do the following: