CSV inspector
Check how a CSV file is actually structured before you import it into Excel or another system. You choose the encoding and the separator; the tool reports rows and columns, rows whose column count differs, quoting that breaks the CSV rules, leading zeros and values a spreadsheet may read as a formula. The same values can then be saved as UTF-8 CSV.
- Decode as UTF-8 or Shift_JIS by your choice; bytes that cannot be read are reported, never replaced
- Switch between comma, tab and semicolon separators to see how the same file splits
- Leading zeros, formula candidates and date-like values are listed without being rewritten
- The limit is 2,097,152 bytes (2 MiB). A larger file is refused rather than partly read
Open the CSV inspector → Import UTF-8 CSV in Excel without garbled characters Related practical guides