Development Tools
CSV Viewer and Cleaner
Open a CSV file, or paste one, and read it as a table you can sort by any column, filter by text and clean: trim extra spaces, remove empty rows and remove exact duplicate rows. Comma, semicolon, tab and pipe delimiters are detected automatically, quoted fields with commas and line breaks are handled, and rows with the wrong number of fields are padded and counted. Download the cleaned result as CSV with spreadsheet formulas neutralised. Files up to about 30 MB and 300,000 rows are read in your browser and never uploaded; the table draws the first 1,000 matching rows at a time.
How to use it
- Open a CSV file or paste CSV.
- Sort by clicking a column heading, filter with the search box and tick the cleaning options.
- Download or copy the cleaned CSV.
Example
A semicolon-separated export with three rows, one a duplicate, shows as a table; removing duplicates leaves two rows and the download uses commas.
Related tools
Convert between formats with the JSON to CSV converter, analyse Search Console exports with the export analyzer and compare crawl exports with the crawl export comparator.
Which tool fits your task?
This page is for sorting, filtering and cleaning a CSV file.
- JSON Viewer: for validating and formatting JSON, not sorting, filtering and cleaning a CSV file.
- XML Formatter and Validator: for checking and indenting XML, not sorting, filtering and cleaning a CSV file.
- SQL Formatter: for tidying SQL queries, not sorting, filtering and cleaning a CSV file.
- JSON to CSV and CSV to JSON Converter: for converting between JSON and CSV, not sorting, filtering and cleaning a CSV file.
Questions
Why does the table show only 1,000 rows?
Drawing hundreds of thousands of rows would freeze the page. Filtering and sorting still work on all rows, and the download contains every matching row.
How are numbers sorted?
If every value in a column is numeric (commas as thousands separators are allowed) it sorts numerically; otherwise it sorts as text with natural ordering.
Why do some cells start with an apostrophe in the export?
Cells beginning with =, +, - or @ could be run as formulas by a spreadsheet, so the export prefixes them with an apostrophe.
Does it change my original file?
No. It reads the file and creates a new cleaned download; the original is untouched.
Is my data uploaded?
No. Everything runs in your browser.
Get practical SEO tips by email
Occasional emails with new guides and tools. Confirm by email first; unsubscribe in one click.