What to Do When a CSV Looks Garbled in Excel
Key points
- Tick "UTF-8 with BOM"
- Save
- Open in Excel
Merge and Split CSV Files can add a BOM when saving, which keeps Excel from garbling the text.
Steps
- Tick "Save as UTF-8 with BOM"
- Run and save
- Open the saved CSV in Excel
If the original file is already garbled, use Convert Text Encoding.
Use "Merge, Split and Pick Columns from CSV" (free)
Tools that go well with this
- Convert CSV and JSON: Convert between CSV and JSON instantly.
- Convert CSV to Excel (.xlsx): Convert a CSV to an Excel (.xlsx) file.
- Convert Text Encoding (Fix Garbled Text): Convert text files between Shift_JIS, UTF-8, EUC-JP and more to fix garbled text.