All Topics
Developer
Export Tool Exports dashes as – and apostrophes as ’
I have a client who opens their export from Admin Columns and Xcel shows ’ for apostrphes and – for dashes. Is this solvable or even an Admin Columns issue?
Thank you,
Can you tell me which version of Excel your client is using?
The exported files are exported as a UTF-8 CSV.
I believe that for some older Excel versions, you’ll need to import the file as a UTF-8 CSV.
For newer versions of Excel, this is not necessary if I’m correct.
You could have a look at this URL to see how you can import a CSV as UTF-8:
https://www.ias.edu/itg/content/how-import-csv-file-uses-utf-8-character-encoding-0
You must be logged in to reply to this topic.