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.
Edit columnsKeep only the columns you need, give them the names your import expects and put them in the right order.Sort rowsSort rows by name, amount, date or any other column, with numbers ordered by value rather than as text, and download the sorted file.Split CSVBreak a big file into parts of any size, each with the header row, so it fits import limits, email attachments or Excel.Merge CSV filesStack several files into a single table, even when their columns are in a different order or not all the same, then clean and download it.Combine Excel sheetsStack every tab of a workbook, or of several workbooks, into a single sheet with a column showing where each row came from.
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.