Summarize a spreadsheet

A profile of every column — types, blanks, totals, ranges, most common values — plus what in the data is worth a look.

How it works

Your file is opened in an isolated sandbox with no internet access, processed, and the sandbox is destroyed. Nothing is stored, and no account is needed.

It uses the same reader as the full product, which is built for the spreadsheets people actually have: headers that are not on row 1, merged cells, totals rows pasted at the bottom, dates in two formats, and numbers stored as text. Everything it changes is listed back to you.

Common questions

What does the summary include?

For each column: its type, how many cells are filled and blank, how many distinct values, and either the min, max, average and total (numbers), the earliest and latest date (dates), or the three most common values (text).

What is 'worth a look'?

Things computed straight from the rows that a colleague would point out: the headline change between periods, the group growing or falling fastest, an unusual month, one group carrying most of the total, a column that is mostly empty. No AI writes these, so no figure is invented.

Does it fix the file too?

It reads the file the way DataMimi does — real header row, merged cells, totals rows removed — but it gives you a report, not a changed copy. Use Clean a messy spreadsheet for that.

How big a file can it handle?

Up to 50 MB with no signup, which is several hundred thousand rows for a typical export.

Other free tools

Merge Excel filesCombine several spreadsheets into one, even when the columns do not match.Clean a messy spreadsheetFix merged cells, headers buried in row 5, and numbers stored as text.Excel to PowerPointTurn a spreadsheet into slides with charts, in one step.Find duplicates in ExcelSpot repeated rows across sheets and files, with the originals kept.Fix numbers stored as textTurn $1,250.00, 12% and 03/15/2026 typed as text into real numbers and dates you can sum and sort.Remove blank rows and columnsDelete every completely empty row and column in one step, and keep everything else exactly as it was.Compare two Excel filesSee which rows were added, which were removed, and which cells changed between two versions.Make a chart from a CSV or Excel fileUpload a file and get a clean chart back: a trend over time, a ranking by category, or a distribution.Unpivot data: columns to rowsTurn a wide table with one column per month or product into a long table a pivot table can use.Convert a bank statement PDF to ExcelOne row per transaction, amounts as numbers, every page in one sheet.Make a dashboard from your spreadsheetUpload a file, see its headline figures, trend and top groups — free.Convert CSV to ExcelAny CSV — any encoding, any delimiter — as a spreadsheet with real dates and numbers.Convert Excel to CSVA clean UTF-8 CSV from a workbook: header on row 1, no title rows, no totals.Convert text to dates in ExcelText dates and mixed formats turned into real dates you can sort and group.Convert a PDF table to ExcelTables from invoices, reports and statements as spreadsheet rows.