How to use this office tool
- Choose a spreadsheet and select the worksheet to profile.
- Set the header row and whitespace option.
- Generate the profile, inspect column metrics, and download the CSV summary report.
#010 · Table Analysis & Summaries Tool
Spreadsheet Summary Report
Generate a compact CSV profile of each column, including filled cells, blanks, unique values, numeric counts, and simple numeric statistics.
Office File Tool
One spreadsheetrow
rows
Ad space
What this tool does
The profiler examines each column independently and writes a new report with completeness, uniqueness, and basic numeric measurements.
Column values → filled, blank, unique, numeric, minimum, maximum, average → CSV report
Statistics are descriptive only. Numbers stored as formatted text may not be included in numeric calculations unless the parser recognizes them.
Supported formats
Files are processed in memory on this device. Large or structurally complex workbooks may require desktop spreadsheet software.
| Input | Support |
|---|---|
| XLSX / XLS | Parsed locally with SheetJS CE |
| CSV / TSV | Supported with delimiter-aware parsing |
| Limits | 25 MB per file, bounded preview, up to 500,000 used cells |
Tips for better results
- Use a clear header row for meaningful column labels.
- Normalize missing-value conventions before profiling.
- Investigate columns with unexpected uniqueness or mixed types.
FAQ
What statistics are included for each spreadsheet column?
The report includes total data rows, filled and blank cells, unique values, numeric values, minimum, maximum, and average.
Does the first row count as data?
The selected header row supplies column names; profiling begins on the following row.
How are blank cells counted?
Null, undefined, and empty-string values count as blank. Whitespace-only text is blank when Trim cell whitespace is enabled.
Are text values converted to numbers for averages?
Only values that can be safely interpreted as finite numbers participate in numeric minimum, maximum, and average calculations.
Can the summary report change my source workbook?
No. Analysis is read-only and the results are downloaded as a separate CSV file.
Related office tools
Processing details
| Processing detail | Behavior |
|---|---|
| Browser processing | No file upload |
| Preview | 5–100 rows |
| Output | New generated file |
Browse more office tools
Office tool hubsSpreadsheet ConversionConvert Excel, CSV, JSON, HTML, and other table formats.View all
Spreadsheet CleanupRemove duplicates, blanks, extra spaces, and inconsistent values.View all
Merge Split & OrganizeCombine, divide, extract, and arrange workbooks and sheets.View all
CSV & Delimited FilesView, edit, clean, validate, and convert delimited data files.View all