|
Cod106
|
December 11, 2016 at 1:47 am
Hello, I am still not finding the solution to open my CSV in excel without the problem of special characters in french. I looked at the ideas on the links cited in the old post. What can I do?
Old post: https://eventespresso.com/topic/file-csv/
Thanks
|
|
Tony
|
December 12, 2016 at 8:11 am
Hi there,
Event Espresso already sets headers to ensure the CSV is in UTF-8
It sets header("Content-Type: text/csv; charset=utf-8"); and also sets the UTF-8 BOM shown HERE.
The problem is that some versions of Excel ignores the above so some versions will work, others will not.
To consistently open the exports using UTF-8 you need to import the data from file or use another program such as OpenOffice that automatically requests details of the file when opening.
To import within Excel go to Data -> ‘Get External Data’ -> From text (or from file if you have the option)
Select the CSV you downloaded from the site.
Set Delimited and chose UFT-8 for the file origin – http://take.ms/VfJLd
On the next page select comma as the delimiter – http://take.ms/3YVUe
Finish and open in new worksheet – http://take.ms/jZA7l
Some info on UTF-8 CSVs:
http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically
http://stackoverflow.com/questions/155097/microsoft-excel-mangles-diacritics-in-csv-files
|
