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,

6 months, 3 weeks 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

6 months, 3 weeks ago

You must be logged in to reply to this topic.