DataMimiDataMimi

Summarize Excel data

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

Want it to work exactly your way?

Keep this tool in your Mini-Apps to run it again in one click, or describe the job and AI builds an app of your own.

✦ Make your own app

How to use Summarize a spreadsheet

  1. 1Select your file, or drop it on the page
  2. 2Run it — nothing to set up
  3. 3Download summary.xlsx

Your file is opened in an isolated sandbox with no internet access, processed and deleted with it. It is read the way people's spreadsheets really are — headers that are not on row 1, merged cells, totals pasted at the bottom, dates in two formats — and everything that is changed is listed back to you.

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.

More Excel tools

See all