CleanCSV

Free CSV & Excel tools

Every tool opens the same private workspace with the right options switched on, so you can combine them: remove duplicates, fix dates and convert to Excel in one go. Files are processed in your browser and never uploaded.

Clean & fix

Remove duplicates, fix spacing, encoding, dates, emails and phone numbers.

Remove duplicatesFind and delete repeated rows in seconds. Compare entire rows or only the columns that matter, such as email or ID, then download a clean file.Remove empty rowsGet rid of blank lines, spacer rows and columns that contain nothing, without touching rows that are only partly filled.Trim spacesRemove leading, trailing and repeated spaces, plus non-breaking spaces and zero-width characters that break lookups, matching and imports.Find & replaceRun several replace rules at once, target one column or all of them, use regular expressions and fill empty cells with a default value.Change text caseConvert text to lowercase, UPPERCASE or Title Case in every column or only the ones you pick, and capitalize person names properly.Remove line breaksJoin multi-line cells, such as addresses and comments, into a single line so every record fits on one row in any system.Fix encodingRepair text like “Café” and “It’s”, read files saved as Windows-1252 or UTF-16, and export UTF-8 that Excel and other apps display correctly.Standardize datesTurn “5 Jan 2024”, “01/05/24” and “2024-1-5” into one consistent format. Day-first and month-first columns are detected from your data.Clean email listRemove duplicate and invalid addresses, fix common typos and tidy formatting so your list imports cleanly into Mailchimp, HubSpot, Klaviyo or your CRM.Clean phone numbersTurn “+1 (555) 010-2030” and “555.010.2030” into consistent digit-only numbers that CRMs, SMS tools and dialers accept.

Organize

Edit columns, sort, split large files and merge several into one.

Convert & view

Move between CSV, Excel and JSON, change delimiters and view files.

Excel to CSVTurn any sheet of an XLSX, XLS or ODS workbook into a clean UTF-8 CSV, with dates and leading zeros intact, and optionally clean it on the way.CSV to ExcelGet a proper .xlsx file with numbers stored as numbers, dates as dates, leading zeros kept, columns sized to fit and filters on the header row.CSV to JSONTurn a CSV or spreadsheet into a JSON array of objects, with headers as keys and sensible types, ready for code, APIs and test fixtures.JSON to CSVTurn JSON files into a table: arrays of objects, nested fields, API responses and NDJSON all become clean CSV or Excel.Excel to JSONTurn any sheet of an Excel workbook into a JSON array of objects, with header names as keys and sensible types, without uploading the file.CSV to SQLTurn a CSV or spreadsheet into a ready-to-run SQL script: a CREATE TABLE with detected column types and batched INSERT statements for your database.CSV to MarkdownPaste-ready Markdown tables from any CSV or spreadsheet, for README files, wikis, issue trackers and note apps.CSV to HTMLGenerate clean, unstyled HTML table markup from any CSV or spreadsheet, ready to paste into a website, CMS or email template.TSV to CSVTurn tab-separated files from databases, spreadsheets and analytics exports into standard comma-separated CSV that every app accepts.Change delimiterConvert between comma, semicolon, tab and pipe separated files. The current delimiter is detected for you and quoting is handled correctly.CSV viewerOpen a CSV, Excel or JSON file instantly to browse, search and spot problems, without installing anything or uploading your data.