Excel, CSV, and Smart Quotes

Friday, September 25, 2015, 1:52 PM

Or how to stop Excel from substituting garbage characters for accents and special characters 

1. Open .csv in a real text editor, set Encoding to UTF-8 BOM, save

2. then and only then open in Excel

In Excel, before setting BOM
In Notepad++
Excel after the fix

 

Further reading

• Microsoft Excel mangles Diacritics in .csv files?