Save a CSV as UTF-8 with BOM for Excel

Accents and non-Latin letters turn into odd symbols when Excel does not realize a CSV is UTF-8. A BOM, a tiny marker at the start of the file, fixes that.

Open CSVFix

How to do it

  1. Drop your CSV file on CSVFix.
  2. Check the encoding shown in the summary line and the accents in the preview.
  3. Tick UTF-8 BOM (for Excel).
  4. Click Download CSV.

Why it helps

Excel on Windows often treats a UTF-8 file without a BOM as legacy text, so characters such as é, ñ or ü are read wrongly. The BOM tells Excel the file is UTF-8.

Questions

Does the BOM change my data?

It adds three invisible bytes at the start of the file. Excel hides them.

Should I always add it?

Not always. Some programs and importers read the BOM as part of the first column name, so use it only for files meant for Excel.

Is Windows-1252 supported?

Yes. CSVFix detects it when reading, and the download is always UTF-8.

Ready to clean your file?

Clean your CSV now

More CSV guides