About Unique Values in a CSV
This page opens with SELECT DISTINCT product FROM orders, which returns every product once however many times it was ordered. It is the quickest way to see what values a column holds and to spot typos. It is free, needs no sign-up and runs in your browser, so nothing you enter is uploaded.
The sample has 6 different products: Desk lamp, Keyboard, Laptop, Monitor, Notebook, Pen set. To count how often each appears, use GROUP BY product with COUNT(*) instead. DISTINCT works on several columns too, and then returns each different combination once.
How to use Unique Values in a CSV
- Look at the Tables list to see the sample tables and their columns, or add your own CSV, TSV, XLSX, XLS or ODS files.
- Write a query in the SQL box, using the table and column names shown in the list.
- Press Run, or use Ctrl or Cmd with Enter.
- Read the result table below, move between pages if there are many rows, and download it as CSV.
- Remove a table with the cross, or add more files to join them.
Features
- SQLite running as WebAssembly in a Web Worker, served from this site.
- Several tables at once, so you can join files.
- CSV, TSV, XLSX, XLS and ODS input, one table per file or sheet.
- Column types detected from the data, blank cells stored as NULL.
- Results with paging, and an export of the full result as CSV.
- A time limit on queries, so a runaway query is stopped and your tables are reloaded.
- Clear SQL error messages from the engine.
Worked examples
SELECT DISTINCT product FROM orders ORDER BY product gives Desk lamp, Keyboard, Laptop, Monitor, Notebook, Pen set
6 distinct products from 10 orders.
Privacy: how it works
- Files are read in this browser tab and loaded into an in-memory database that disappears when you close the page. Nothing is uploaded, and the SQL engine file comes from this site, not from a CDN.
Tips
- Table and column names are cleaned to letters, digits and underscores, so "First Name" becomes First_Name.
- Use LIMIT while you are exploring a big table.
- Quote text with single quotes: WHERE country = 'UK'. Double quotes are for names.
- To check a join, count rows before and after. A join on a column with duplicates can multiply rows.
Frequently asked questions
Is it really free?
Yes. There is no price, no trial and no credit card. Ulkaa Tool does the work with your own device, so there is no server bill to pass on to you.
Do I need an account?
No. There is no sign-up and no login. Open the page and use it. An Ulkaa account is not needed for anything on this tool.
Does it run in my browser?
Yes. Your files and queries are processed by code running in your browser tab, on your own device.
Is my data uploaded?
No. Your files and queries are never sent to Ulkaa or to anyone else. You can check this yourself by watching the Network tab in your browser developer tools while you use the tool.
How do I remove duplicate rows from a CSV?
SELECT DISTINCT * FROM your_table returns each different row once. The data cleaner tool also removes duplicates and downloads a cleaned CSV.
More Run SQL on CSV pages
- Run SQL on CSVLoad CSV or Excel files as tables, write SQL and see the results.
- GROUP BY on a CSVSummarise a CSV file by category with a SQL GROUP BY query.
- Join CSV Files With SQLCombine two files on a shared column, such as an id.
- Filter a CSV With SQLKeep only the rows that meet your conditions.
- Sort a CSV With SQLOrder rows by any column and keep the top few.