Data & CSV

Extract unique CSV values

Export one column’s distinct values in first-seen or sorted order.

Your inputs

Your CSV data

UTF-8 CSV/TSV stays on this device. First row contains unique headings; maximum 25 MB, 50,000 rows and 200 columns. Fully empty rows are ignored.

Up to 25 MB per file, 50,000 data rows, 200 columns and 2 million data cells. Fully blank rows and columns are ignored before row, column and cell limits are checked. Individual tools may have smaller result or chart limits.

Or choose a CSV file

Column separator

Column

Output order

Exactly empty values

Results update as you type. Larger files run when you press Update result.

Processed on your device

Your result

LOCAL & PRIVATE

Your result will appear here.

Your inputs stay in this browser. Nothing is uploaded or saved.

A clear answer. Here’s how.

Extracts exact distinct cell strings from one chosen column. Case, surrounding spaces and leading zeros remain significant. Can retain first-seen order or use English locale text sorting. Returns a single-column CSV with the original heading; no source rows are otherwise edited.

See a worked example

Worked example

A fixed demonstration, separate from the values you enter above.

Your CSV data

ID,Name,Department,Amount,Date
001,Ada,Design,120,2026-01-05
002,Sam,Writing,80,2026-01-06
003,Jo,Design,150,2026-01-07
004,Lee,Writing,,2026-01-08
005,Alex,Design,60,2026-01-09

Column separator

Comma

Column

Department

Output order

First occurrence

Exactly empty values

Include empty value

Example result

Example result
Department
Design
Writing