CSV Column Statistics
Profile every column: type, fill rate, distinct values, and min, max and mean for numbers.
Your result will appear here as soon as you add some input.
How to use it
- 1Paste your CSV, or open the file in a text editor and copy it in.
- 2Adjust the delimiter and header options if the preview looks wrong.
- 3Adjust the options if you need something other than the defaults.
- 4Download the result, or copy it straight back into your spreadsheet.
About the CSV Column Statistics
This is the first thing to run on a dataset you did not create. The fill rate finds columns that are mostly empty, the distinct count finds the ones that are constant, and the detected type finds the numeric column that is secretly text.
A numeric column reported as text almost always has one bad value in it: a thousands separator, a currency symbol, a footnote marker or "N/A" in place of a blank.
Questions people ask
Is your data uploaded to a server?
No. This tool runs entirely in your browser using standard web APIs, so your data never leaves your device. You can confirm it by opening your browser's network panel while the tool runs, or by disconnecting from the internet after the page has loaded.
Is it free, and do I need an account?
Yes, it is free, and there is no account, no sign-up and no watermark on the result. The project is funded by optional donations.