Excel UTF-8 CSV Encoding FAQ

Why does Microsoft Excel show strange symbols like ü when I double-click a UTF-8 CSV?

Without a 3-byte UTF-8 Byte Order Mark (EF BB BF) at the start of the file, desktop Excel defaults to your operating system's legacy 8-bit ANSI code page (such as Windows-1252), splitting multi-byte UTF-8 characters into garbled symbols like ü or €.

How do I add a UTF-8 BOM to a CSV file so Excel opens it cleanly on double-click?

Prepend the Unicode BOM character (\uFEFF, bytes EF BB BF) to the UTF-8 text before saving, use Python's utf-8-sig encoding, or download the CSV with Include UTF-8 BOM enabled in our browser-based JSON to CSV converter.

Why did my UTF-8 CSV open with all columns merged into Column A in Excel?

In countries where a comma is used as the decimal separator (such as Germany, France, Spain, and Brazil), Excel expects semicolons (;) instead of commas (,) to separate CSV columns on double-click.

If I already opened a CSV in Excel and saw garbled characters, is my file permanently corrupted?

No, as long as you close the file without saving. Re-open a blank Excel workbook, go to Data -> From Text/CSV, and choose File Origin 65001: Unicode (UTF-8) to load the original UTF-8 bytes cleanly.