Extract Unique Values from Excel Column Online — Free, No Upload, 1 Click
List distinct values with optional counts. No upload, no sign-up — file stays on device.
Drop one .xlsx, .xlsm, or .xls file here, or click to browse
Supports .xlsx / .xlsm / .xls · processed locally · never uploaded
What the Output Looks Like
The result is a new workbook: every usable source sheet produces one result sheet named “{source sheet} unique”. The Value column lists distinct values in first-seen order, and the optional Count column shows how many times each value appeared.
| Original column (City) | Value | Count |
|---|---|---|
| NYC | NYC | 3 |
| LA | LA | 1 |
| (empty cell) | (blank) | 2 |
How to Extract Unique Values from a Column Online
- Drop one .xlsx, .xlsm, or .xls workbook — it is parsed locally and never uploaded.
- Choose a column from the candidates read from the first sheet (for example “A — Name”).
- Keep “First row is a header (skip it)” and “Include occurrence count column” checked, or adjust as needed — both are on by default.
- Click Extract unique values — every sheet is scanned by the same column index; sheets narrower than that column are skipped automatically.
- Review the per-sheet report and download the result as your-file-name-unique-values.xlsx.
When You Need This
- Data validation: list every value that actually appears in a column and compare it against the set of values you expected.
- Dropdown source: turn a messy column into a deduplicated option list for an Excel data-validation drop-down, with counts.
- Spot dirty-data variants: “NYC”, “NYC ” (trailing space), and “New York” show up as three distinct entries, so inconsistencies are easy to find and standardize.
- Frequency audit: use the Count column to find the most and least frequent codes and catch typos or misspellings.
Blank Cells, Empty Strings, and Value Types
Uniqueness is decided after normalization: truly empty cells (including cells missing past the end of ragged rows) collapse into one blank entry, which is written back as a genuinely empty cell and appears as “(blank)” in the list.
Note the fine distinctions: a typed empty string "" is a separate unique item from a truly empty cell; a whitespace string " " is yet another item; the number 1 and the text "1" never merge; and dates with the same instant (identical ISO timestamp) are merged into one item.
This Tool vs Remove Duplicate Rows
| Feature | Extract unique values | Remove duplicate rows |
|---|---|---|
| Output | A brand-new workbook listing distinct values per sheet | A workbook with the same shape, minus duplicate rows |
| Scope | One selected column | Whole rows compared across all columns |
| Occurrence counts | Optional Count column | Not provided |
| Typical goal | Dropdown sources, value inventories, finding dirty variants | Removing repeated records |
Frequently Asked Questions
Is this tool free, and is my file uploaded?
Yes — 100% free with no sign-up and no file limit. Parsing, extraction, and workbook rebuild all happen in your browser; the file never leaves your device.
How is uniqueness decided?
Values are normalized before comparison (dates become ISO timestamps, empty cells become null) and comparison is type-sensitive: the number 1 and the text "1" are different items, and leading or trailing spaces matter.
Do blank cells count as a value?
Yes — all truly empty cells in the column become one blank entry, written back as an empty cell. A typed empty string "" is different from a truly empty cell and counts as its own item.
What if some sheets do not contain the selected column?
Sheets narrower than the selected column (or with no data rows) are skipped automatically and listed as skipped in the report; all other sheets are still processed.
How is this different from removing duplicates?
This tool builds a standalone list of distinct values in a new workbook — it never deletes rows or changes the structure of your original data. Remove duplicate rows rewrites the same table with repeated rows deleted.
In what order are the values listed?
Strictly in first-seen order — the order in which each distinct value first appears when scanning the data rows top to bottom. No sorting is applied.
Which formats are supported, and what about encrypted files?
.xlsx, .xlsm, and legacy .xls are accepted; the result always downloads as .xlsx. Encrypted workbooks that require a password to open cannot be read.
Related Tools
Want the full walkthrough? Read How to Extract Unique Values in Excel Without the UNIQUE Function — step-by-step instructions, the manual Excel method, and FAQ.
Need the full reference? Read INDEX MATCH in Excel: Syntax, Examples and Errors — syntax, examples, common errors, and FAQ.
Want to review, filter, or edit the data behind the list?
Open the free online Excel editor