Extract Unique Values from Parquet Files Online
Extract all distinct values from any column in Parquet files directly in your browser. Download the unique values list — no upload required.
About this tool
Extract a deduplicated list of all distinct values from any column in a Parquet file. Download the result as a standalone file. Useful for building lookup tables, populating dropdowns, or auditing category fields.
Frequently Asked Questions
What is the difference between unique-values and count-by for Parquet files?
Unique values returns a list of distinct values with no frequency information. Count-by adds a row count for each value. Use unique values when you need the list itself — for example to populate a dropdown or check what categories exist.
Can I extract unique values from multiple columns of a Parquet file?
One column at a time. The output is a single-column file of distinct values ready to download.
How many unique values can the tool extract from a Parquet file?
There is no limit. The tool computes distinct values across the full dataset regardless of file size, within your device's available RAM.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Get Top N Rows from Parquet Files Online
Extract the top N rows per group from Parquet files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to Parquet Files Online
Add a percentage-of-total column to Parquet files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Parse URL Column in Parquet Files Online
Parse URL columns in Parquet files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.
Add Lag / Lead Column to Parquet Files Online
Add a LAG or LEAD column to Parquet files to shift any column forward or backward by N rows. See previous day's sales, next value in a sequence, or any time-shifted comparison — runs entirely in your browser.
Filter by Date Range Parquet Files Online
Filter Parquet files to rows within a date range using simple start and end date pickers. See a live match count before you apply the filter — no upload required, runs in your browser.