\n
#070 · Table Analysis & Summaries Tool

Spreadsheet Data Profiler

Upload a spreadsheet and choose a sheet and header row. The tool samples display values, calculates column metrics, previews the profile, and exports it.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Select or drop the supported file.
  2. Review the detected sheet and adjust the operation-specific options.
  3. Process the file, inspect the limited preview and output counts, then download the new result.

What this tool does

Each column receives nonblank, blank, unique, inferred type, minimum, maximum, and example metrics.

Profiling describes the selected sheet; it does not infer business meaning or guarantee that outliers are errors.

XLSX, XLS, CSV, and TSV are supported. A new XLSX profile report is created.

Supported formats

XLSX, XLS, CSV, and TSV are supported. A new XLSX profile report is created.

FormatUse
XLSX / XLSWorkbook data and formulas where applicable
CSV / TSVDelimited tabular data with detected quoting

Tips for better results

  • Keep a copy of the original before changing production data.
  • Use a clear, unique header row.
  • Check identifiers, dates, formulas, and a sample of output rows.

FAQ

Does Spreadsheet Data Profiler upload my spreadsheet?

No. Processing happens in your browser, and the selected file is not sent to Calloffice.

What happens to formulas when I use this profile tool?

Formula cells are preserved where the selected operation can retain them, but the browser does not reproduce Excel's full calculation engine.

Can I use large files with Spreadsheet Data Profiler?

Yes, within your browser's available memory. The preview is capped, and very large workbooks may take longer or need to be split first.

How are dates, IDs, and leading zeros handled?

The tool uses displayed spreadsheet values where appropriate and avoids intentional numeric conversion unless the selected operation requires it. Review identifier columns after export.

What should I check before using the downloaded file?

Check the preview, output counts, headers, and a few representative rows. Keep the original file until the result has been verified.

Processing summary

StageBehavior
InputTable Analysis & Summaries
PrivacyLocal browser processing
DownloadNewly generated result file

Browse more office tools

Office tool hubs