When a CSV Looks Garbled
Key points
- Convert
- Open
Opening a CSV directly can garble text because of character encoding differences.
Steps
- Convert the CSV with Convert CSV to Excel (.xlsx).
- Open the resulting .xlsx in Excel.
- Japanese text displays correctly.
Tools that go well with this
- Convert Excel to CSV or JSON: Convert an Excel sheet to CSV, TSV or JSON.
- Convert CSV and JSON: Convert between CSV and JSON instantly.
- Remove Duplicate Lines and Sort a List: Remove duplicate lines and sort them.