#133 · Table Analysis & Summaries Tool

Unique Value Count by Column

Count distinct non-empty values in every column of a worksheet and export a compact summary for quick profiling.

Office File Tool

Local browser processing
row
rows
Ad space

How to use this office tool

  1. Choose the source spreadsheet or text table.
  2. Select the worksheet and adjust the visible options.
  3. Click Count unique values, review the bounded preview, then download the new result.

What this tool does

Count distinct non-empty values in every column of a worksheet and export a compact summary for quick profiling.

Count unique values → validate the result → create a separate downloadable file.

The original file is never overwritten. Review the downloaded result before using it in production.

Supported formats

This tool accepts common spreadsheet and delimited-text formats within practical browser limits.

FormatSupport
XLSX / XLSRead with SheetJS; complex Excel-only features may not be preserved.
CSV / TSVParsed locally with delimiter and quoting awareness.

Tips for better results

  • Keep a backup of the original workbook.
  • Preview the result before downloading.
  • Check identifiers and dates after conversion.

FAQ

Does Unique Value Count by Column upload my workbook?

No. Processing happens in your browser. The page does not send workbook contents to a server.

Will Unique Value Count by Column overwrite the original file?

No. It creates a separate download, so your selected source file remains unchanged.

How are blank cells handled?

Empty cells are distinguished from zero and from text containing spaces. Optional trimming only affects text values.

Are formulas recalculated like desktop Excel?

No. Formula text can be preserved or inspected, but this browser tool is not Microsoft Excel's calculation engine.

What size workbook should I use?

For dependable browser performance, use files under 40 MB and worksheets below 750,000 cells. Split larger files first.

Processing summary

StepBehavior
InputUnique Value Count by Column
OutputNew XLSX workbook

Browse more office tools

Office tool hubs