Category: Developer tools
CSV Column Profiler
Profile pasted CSV columns: type guess, blanks, unique values and examples
Paste CSV data and get a per-column profile: a guessed type, how many cells are blank, how many distinct values appear, and a few example values. Runs entirely in your browser.
| Column | Type | Blanks | Unique | Examples |
|---|---|---|---|---|
name | Text | 0 | 3 | Ada Lovelace, Grace Hopper, Alan Turing |
age | Integer | 1 | 3 | 36, 41 |
active | Boolean | 0 | 2 | true, false |
joined | Date | 0 | 2 | 2024-01-15, 2024-02-01 |
Everything on this page is processed in your browser. Nothing is uploaded.
What this tool does
Before cleaning or importing a CSV export, it helps to know what's actually in it: which columns are mostly blank, which look numeric versus free text, and how much variety each column has. This tool parses the pasted CSV and profiles every column positionally, so ragged rows still profile every column the header names.
How to use it
- Paste CSV data, choose the delimiter, and mark whether the first row is a header.
- Read the profile: a guessed type (text, integer, number, boolean, date or empty), blank count, unique count and up to three example values, for every column.
Privacy
This tool runs entirely in your browser. Your input is never uploaded, stored or shared — closing the tab removes it.
Frequently asked questions
- How is the type guessed for a column?
- Every non-blank value in the column is checked against integer, decimal number, boolean (true/false) and ISO-style date patterns; the column gets that type only if every value matches, otherwise it's profiled as text.
- What counts as a blank cell?
- A cell that is empty or contains only whitespace after trimming.
- What happens with rows that have fewer fields than the header?
- Missing fields are treated as blank for that row's column, so the column is still profiled correctly rather than being skipped.