26
6
I am using a variety of tools to regularly prepare data for the web. One stage requires me to open a CSV in Excel, make changes and save the file.
Is there a way to force Excel to accept UTF-8 encoding, and to save its files with that encoding?
1To clarify, I would like to change a setting so that Excel assumes an input file is UTF-8 by default. As mentioned below, LibreOffice/OpenOffice does this. – Dizzley – 2015-10-30T12:02:17.747
If you don't actually have Unicode characters to deal with, I'd consider using a middleware to convert all CSVs to ASCII and then open in Excel. – Vassile – 2016-02-28T07:54:12.847
1
Related question here but not exactly the same.
– hhh – 2017-01-27T08:09:50.747