Support

Search results for ""

Sorry, no results found. Perhaps you would like to search the documentation?
All Topics
Jerry

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,

11 months ago
Stefan
Developer

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

11 months ago

You must be logged in to reply to this topic.