← All text tools

CSV Column Statistics

Profile every column of a CSV: detected type, filled and empty cells, unique values, min, max, mean, median and the most common values.

  • Free
  • No sign-up
  • Works on any device

About CSV Column Statistics

Get a quick profile of a CSV before you load it anywhere. For each column the table shows the detected type (integer, decimal, ISO date, boolean or text), how many cells are filled and how many are empty, the number of unique values, the minimum and maximum, and for numbers the sum, mean and median. A Most common column lists repeated values with their counts, and the totals show duplicate rows. Cells that are blank or only spaces count as empty. The profile can be downloaded as a CSV of its own, which is handy for data quality notes.

How to use CSV Column Statistics

  1. Paste the CSV and tell the tool whether the first row holds the column names.
  2. Choose how many of the most common values to list for each column.
  3. Read the table, spot columns with many empty cells or the wrong type, and download the profile if you need it.

Why use this tool?

Also known as

Frequently asked questions

How does it decide that a column is a number?

Every filled cell must look like a number, such as 12, -3.5 or 1e3. A single stray word such as n/a makes the column text, which is itself a useful sign that the data needs cleaning.

Which date formats are recognised?

ISO dates written as YYYY-MM-DD, with an optional time after them. Other formats are shown as text so that day-first and month-first dates are never confused.

Is the median the same as the mean?

No. The mean is the sum divided by the count, while the median is the middle value after sorting. For an even number of values it is the average of the two middle ones.

Is CSV Column Statistics free?

Yes. CSV Column Statistics on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put CSV Column Statistics on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools