About csv viewer / cleaner
A CSV opened in a text editor is hard to read. The viewer shows it as a table, and can clean it up by trimming spaces and removing empty rows.
Useful cleaning steps
- Trim whitespace around values.
- Remove blank rows and duplicated header rows.
- Check that all rows have the same number of columns.
A worked example
A CSV exported from a billing system opens with columns shifted because one description contains a comma that was not quoted. The viewer shows the table so you can see which rows have too many columns, and trim spaces or remove empty rows.
Cleaning checklist
- Make sure every row has the same number of columns.
- Remove duplicate header rows from merged exports.
- Check dates, since 03/04/2026 can mean 3 April or 4 March.
