Spreadsheets & data
Two versions to compare, tables to join, columns full of junk. Sorted in your browser.
10 tools · free · no upload
- Spot what changed between filesCompare spreadsheets
- Column has mixed formatsData type checker
- Workbook has broken formulasExcel formula checker
- Same names, spelled differentlyFuzzy match lists
- Names and emails in a tableAnonymize spreadsheet
- How do these tables connect?Find table relationships
- Need stats for every columnCSV column profiler
- VLOOKUP keeps breakingJoin spreadsheets
- Totals by group, no ExcelPivot table maker
- Messy CSV with blanks and copiesCSV cleaner
How the spreadsheet tools work
Drop a CSV or Excel file, or paste rows straight from Excel or Google Sheets. The file is read in this tab: Excel workbooks are unpacked by the browser itself, CSV separators and text encodings are detected for you, and results update as you change an option. Client lists and payroll sheets never leave your device.
Which tool for which problem
- Two versions of a sheet: compare them and see the added, removed and changed cells.
- Data from two sheets belongs together: join them on a shared column, like a VLOOKUP without formulas.
- Names are spelled differently in each list: fuzzy match them.
- A summary by month or by region: make a pivot table.
- A sheet looks fine but sums go wrong: check each column’s data type, then profile the columns for gaps and outliers.
- An export is a mess of spaces, odd characters and mixed dates: clean the CSV.
- A workbook gives strange results: check its formulas for errors and risky patterns.
- Several tables with IDs: find how they connect, including rows that point at nothing.
- A sheet has to be shared without personal details: anonymize it first.
Questions
Are my spreadsheets uploaded?
No. CSV and Excel files are read and processed in this browser tab, and the results are downloaded from it. Nothing is stored after you close the page.
Which files can I use?
CSV, TSV and text files with any common separator, and Excel workbooks saved as .xlsx or .xlsm. Older .xls files and Numbers or OpenDocument files need to be saved as .xlsx or CSV first.
Do the tools recalculate my formulas?
No. Excel saves the last result of every formula in the file, and the tools read those saved values. The formula checker also reads the formulas themselves.
How big can a sheet be?
Tens of thousands of rows work well in a current browser; hundreds of thousands work on a computer with enough memory. Very large tables show a preview on screen while the download holds every row.