Find Unique Values in Column screenshot

Find Unique Values in Column

List the distinct values of one column of a pasted data set, in order.

Privacy First
0 Runs
Updated 2026-11-06
No upload

What this page computes

Paste a data set and the page prints the distinct values of the column you name, in the order they first appear, with a count. The column number is 1-based and the width is taken from the first row.

Where it stops

A column number past the width of the first row is refused with the width, so a typo cannot quietly print one empty value. Values are trimmed for comparison and case is not folded; a header row is skipped when you say the first row is one.

Why the answer repeats

The distinct list is a Set built in this tab, so the same paste always prints the same values in the same order, and no column of data is uploaded.

Prints the distinct values of one column of a pasted data set, in first-appearance order, with a count and the data-row total. The column number must exist in the first row; a header row is skipped when declared.

How to use it

Paste the data, set the delimiter, column number and header flag, then press Run.

The arithmetic

Rows are split on the delimiter and the field at column − 1 is trimmed. A Set records what has been printed, so a repeated value is skipped while the order stays that of the paste.

What to Expect

Best for

  • listing categories in an export
  • counting distinct values in a column

What this tool keeps

  • the distinct values and their count

Sample input

a,b / 1,x / 2,x / 3,y with column 2 and a header

Sample output

x y Unique values = 2 in column 2 of 3 data row(s).

Frequently asked questions

How do I use the find unique values page?

Paste the data, set the column number and options, then press Run.

Is anything uploaded?

No. The whole calculation runs in this tab with JavaScript: no request is made, no account is needed, nothing is stored, and the page keeps working offline once it has loaded.

What are its limits or bounds?

The column must be a whole number from 1 to the width of the first row, and the box must hold data. A column past the width must be refused with that width.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.