Count Unique Values Online

Count distinct values and see a frequency table from your list.

100% private. Everything runs in your browser. Your data never leaves your device.

Count Unique Values

What does this tool do?

This tool counts how many unique (distinct) values are in your list and shows a frequency table of each value and how many times it appears. Runs entirely in your browser.

How to use Count Unique Values - Free Online Tool

  1. Paste your values, one per line, or click "Try with sample data".
  2. Choose whether to ignore case and spaces.
  3. Click Count.
  4. See the unique count and frequency table, then copy or export.

Example

Counting values:

Before

Value
A
B
A
A

After

Value Count
A 3
B 1

2 unique values; A appears 3 times.

Excel formula alternative

Prefer a formula? You can achieve a similar result with COUNTIF / UNIQUE:

=SUMPRODUCT(1/COUNTIF(A2:A100,A2:A100))

Counting distinct values in Excel needs tricky formulas. This tool shows counts and frequencies instantly.

When should I use this tool?

Counting distinct customers or SKUs
Building a frequency table
Finding the most common values
Data quality checks
Summarizing categories
Quick value counts

Frequently Asked Questions

Yes, it produces a frequency table sorted by count.

Yes, so "Apple" and "apple" count as one value.

No, it runs in your browser.

Yes, copy or download it.

Related tools

Find Duplicates
Remove Duplicates
Data Profiler & Health Check
Word & Character Counter
Sort Data

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Add Serial Numbers Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator