Free tool · CSV in · profile CSV out
CSV column profiler: blanks and numeric summary
Check a table before importing or analyzing it. Each output row describes one input column: row count, empty cells, distinct non-empty values, and numeric statistics.
Paste the data instead
Choose a file, paste data, or try the example to preview the result.
Preview
How it works
- ChooseCheck a table before importing or analyzing it. Each output row describes one input column: row count, empty cells, distinct non-empty values, and numeric statistics.
- PreviewCheck the result in the preview before downloading. Input files stay on your device.
- DownloadNumbers must use a decimal point with no currency symbol or thousands separator. The mean covers recognized numeric cells only. Distinct counts exclude empty fields.
Questions
Are IDs included in numeric statistics?
Leading-zero strings and values longer than 15 significant digits are excluded from numeric statistics. Empty means an empty field, not a field containing spaces.
Is my file uploaded?
No. The file is read and processed by JavaScript in your browser. No account is needed.
What are the limits?
Numbers must use a decimal point with no currency symbol or thousands separator. The mean covers recognized numeric cells only. Distinct counts exclude empty fields. Text input is limited to 25 MB and tables to 200,000 cells.
Keep going
Related tools, and the longer explanations behind them.