CSV column profiler
Profile CSV columns for empty cells, distinct values, repeated entries and whitespace differences. Download column statistics, value frequencies and JSON.
Your results
CSV column profiler
Inspect spreadsheet exports before importing them into another system. Compare empty cells, distinct values and repeated occurrences per column. Whitespace variants count additional exact values that become identical only after trimming. Matching is case-sensitive; NA and -1 remain ordinary values. Original data is unchanged.
How to use this tool
- Upload CSV or TSV, import a direct public file URL, or paste text after the upload options.
- Choose the actual delimiter and how many frequent values to include per column, from 1 to 20.
- Review the first 20 columns in the table. Download complete column statistics, value frequencies and the JSON profile.
Supported input formats
CSVTSVTXT
Available settings
- Delimiter
- Frequent values per column
Output and limitations
Profile CSV columns for empty cells, distinct values, repeated entries and whitespace differences. Download column statistics, value frequencies and JSON.
One UTF-8 CSV or TSV up to 5 MB, 10,000 data rows and 100 columns with unique headers. Select the delimiter. Empty cells and whitespace-only cells are separate. No number or date inference, automatic cleaning or custom missing-value rules. Export Excel sheets as CSV first.
Will profiling change IDs or spreadsheet formulas?
Values stay text; IDs, long integers and dates are not converted. JSON keeps exact strings. CSV reports prefix formula-like text with an apostrophe. Import CSV columns as text in Excel to preserve leading zeroes. Truly empty physical lines are ignored; quoted blanks and whitespace-only records are retained.
What do distinct values and repeated occurrences mean?
Distinct values count different nonblank strings. Repeated occurrences count filled cells beyond their first exact occurrence. Empty and whitespace-only cells are excluded from frequencies. Ties keep their first source order. Exact duplicate-row counts are in JSON.
What if processing fails?
Check the supported formats and file limits, then try a smaller file. Keep an original copy. A clear error message will explain an unsupported input or an unavailable processing service.