Free CSV tools
Nine small tools for the fixes almost every export needs. They run in your browser, so files are never uploaded, and you don’t need an account.
- Nothing uploaded
- Instant results
- No account needed
Clean
Fix the values themselves.- Remove duplicate rows from a CSV
Drop repeated rows in seconds. Match on every column or only the ones that identify a record, and keep the first copy of each.
- Trim whitespace in a CSV
Strip the invisible spaces that stop values from matching: leading and trailing spaces, non-breaking spaces and zero-width characters.
- Remove empty rows from a CSV
Delete rows with no values at all, including rows that only contain spaces or empty commas, and drop columns that are blank from top to bottom.
- Fill blank cells in a CSV
Replace empty cells with a value you choose, or fill down from the row above to repair exports where repeated values were left blank.
Check
Find problems before they spread.- CSV validator and checker
Find out what’s wrong with a CSV before an import fails: broken quotes, ragged rows, duplicate headers, blank lines, stray spaces and formula-like cells.
- CSV injection sanitizer
Make a CSV safe to open in Excel or Google Sheets by neutralising cells that would otherwise run as formulas.
Convert
Change the format, keep the data.- Convert CSV to JSON
Turn a CSV into clean JSON: one object per row, keyed by the header, with optional number and true/false detection.
- Convert JSON to CSV
Paste a JSON array or JSON Lines and get a spreadsheet-ready CSV, with nested objects flattened into columns.
- Change a CSV’s delimiter
Convert semicolon, tab or pipe separated files to commas, or the other way round, without breaking quoted values.
Need undo, history
and saved files?
The free workspace keeps every dataset in your account. See features