Count Unique Values (Frequency Counter)

About the Count Unique Values (Frequency Counter)

Paste a list — one value per line — or open a CSV or Excel file and pick one or more columns, and see how often every value appears: the count, its share of all values, the running (cumulative) share and a bar for each, from the most common down. It is COUNTIF for every value at once, or a spreadsheet’s “count unique values” and a pivot table’s count, without building either.

Choose what counts as the same value — “Red” and “red”, extra spaces, accents, punctuation at the ends, or numbers written as 1 and 1.0 — and split cells that hold several values, such as “Red; Blue” from a multiple-choice survey answer. The table shows which spellings were counted together. Your list is counted in your browser; nothing is uploaded.

Common uses

• Counting the answers to a survey question, including multiple-choice answers in one cell.
• Finding the most common products, cities, error codes or customer names in an export.
• Checking a column before a pivot table or a chart: spelling variants show up as separate values.
• Finding duplicates in a list of e-mail addresses, IDs or invoice numbers (counts above 1).
• A Pareto view: the cumulative percent shows how few values make up most of the total.

What counts as the same value

Each option makes more spellings count as one value:

• Upper and lower case — “Red”, “red” and “RED”.
• Spaces at the ends and runs of spaces inside a value — “ New York ” and “New York”.
• Accents — “café” and “cafe”, “Zoë” and “Zoe”.
• Punctuation at the ends — “Blue.”, “Blue!” and “(Blue)”.
• Numbers written differently — 1, 1.0 and 01, or 1,000 and 1000 (commas are read as digit grouping).

The table shows each value in its most common spelling and lists every spelling counted with it, so nothing is hidden.

Percent and cumulative percent

The percent is the value’s count divided by all values counted (blank cells are left out unless you count them). The cumulative percent adds up the percents from the top of the table down, so with the most common values first it shows how many values make up, say, 80 % of everything — the idea behind a Pareto chart. When cells are split, each part counts once, so the counts add up to the number of parts, not of cells.

Files and columns

CSV and TSV files (any delimiter and encoding the reader detects), Excel workbooks (XLSX, XLS), OpenDocument (ODS) and Numbers files are read in your browser; pick the sheet, say whether the first row holds column names, and tick one column or several (all of them are counted together, as for a set of “Choice 1, Choice 2, Choice 3” columns). Formulas count as their last saved values.

Limitations

• The page shows the first 1,000 values of the table; the copy and the downloads have every value.
• Text files up to 100 MB and workbooks up to 50 MB, as far as your device’s memory allows.
• Values are compared exactly after the options you choose; similar but differently spelled values (“Jon” and “John”) stay apart — the Fuzzy Match tool finds those.

Privacy

Everything happens in your browser. What you enter or open here is not uploaded or stored by MySmartCoPilot.