#145 · Table Analysis & Summaries Tool

Missing Value Summary

Measure blank values by spreadsheet column and download a CSV summary with counts and missing-value percentages. The original file stays unchanged.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Choose the source file; processing begins only after you press the action button.
  2. Set the header row and the options needed for this missing value profiler.
  3. Review the limited preview and statistics, then download the newly generated result.

What this tool does

This missing value profiler examines blank counts and percentages for each selected-sheet column. It performs the work locally and leaves the source file untouched.

Processing rule: analyze blank counts and percentages for each selected-sheet column, show a bounded preview, then create a separate downloadable result.

Keep the source file and review the output before using it in a production workflow.

Supported formats

The tool accepts XLSX, XLS, CSV, and TSV. It reads cell data in the browser; macros, charts, external links, and advanced Excel formatting are outside its preservation scope.

FormatSupport
XLSX / XLSCell data and workbook structure where applicable
CSV / TSVDelimited text parsed locally

Tips for better results

  • Use a clear, single header row before running the missing value profiler.
  • Check identifiers with leading zeros and date-like text in the preview.
  • Work on a copy when the workbook contains macros or advanced formatting.

FAQ

Does Missing Value Summary upload my workbook?

No. The missing value profiler reads and processes the selected file inside your browser. Your spreadsheet is not sent to Calloffice.

Which spreadsheet formats work with this missing value profiler?

XLSX, XLS, CSV, and TSV files are accepted. Older or unusually structured workbooks may lose unsupported Excel-only features in a generated output.

How are blank cells handled by the missing value profiler?

Blank cells remain distinguishable from zero and text. The exact treatment is shown in the preview and described in the downloaded result.

Will formulas and formatting remain intact?

The tool focuses on cell data and its stated task. Formula text is read where relevant, but Excel calculation behavior, charts, macros, and advanced formatting are not guaranteed.

What should I check before using the downloaded result?

Review the bounded preview and open the downloaded file in a spreadsheet editor. Keep the original workbook until column names, dates, and special values have been verified.

Processing summary

StageBehavior
InputRead locally in the browser
TaskBlank counts and percentages for each selected-sheet column
OutputNew downloadable file

Browse more office tools

Office tool hubs