Free tool · Charles Belton, BA/BI · Brunswick, ME
CSV profiler
Drop a CSV to see column types, null rates, unique counts, and common data-quality issues before you load it into Excel, SQL, or Power BI.
Your file stays in this browser. Nothing is uploaded.
or paste CSV
Summary
Issues
Columns
| Column | Type | Null % | Unique | Min / max or top values |
|---|
First 5 rows
How to use
- Export or save a spreadsheet as CSV (UTF-8 if you can).
- Drop the file here, or paste a few rows to spot-check a sample.
- Scan Issues first: blank headers, mixed types, and empty columns usually break a load.
- Use the column table to decide types before you write SQL or a Power Query step.
Built by Charles Belton, business analyst and BI consultant in Brunswick, ME.
FAQ
Does the file get uploaded?
No. Parsing runs in this tab. Close the tab and the file is gone.
What counts as an issue?
Blank headers, mixed types in one column, and columns that are all empty. Those are the ones that usually break a SQL load or a Power Query step.
How big a file can I drop?
About 15 MB. If you only need a sniff of the columns, paste a sample instead.
Can I drop an Excel workbook?
Save or export as CSV first. A workbook with several sheets needs one sheet exported at a time.
Need this as a recurring report?
If cleanup or a weekly refresh is eating the team, write me. I answer my own email.