CSV Column Statistics

CSV Column Statistics

Local Processing

Sum, average, median, min, max, standard deviation, variance, missing values, unique values and frequencies for a CSV column.

How It Works & Processing Standards

Sum, average, median, min, max, standard deviation, variance, missing values, unique values and frequencies for a CSV column.

Tool processing runs in your browser. If you create a calculator or conversion share link, its values are included in the URL. See the privacy policy for account, analytics and advertising data.

Current Limits

  • Desktop max file size: 50MB
  • Mobile max file size: 20MB

Choose a statistic under "Task" and name a column. Summarise sales, scores or survey results without spreadsheet formulas.

What You Can Do

Basic statistics
Sum, mean, median, min, max, standard deviation, variance.
Missing and distinct
Counts blank cells and distinct values.
Frequency table
How many times each value appears.

How to Use CSV Column Statistics

  1. 1
    Choose a taskPick the statistic.
  2. 2
    Enter CSV and columnPaste CSV and name the column.
  3. 3
    Read the resultSee the value or table.

Examples

Mean score
Input: 이름,부서,점수 민수,영업,82 지영,개발,95 철수,영업,77 영희,개발,88 column: 점수
Result: 85.5
Median score
Input: 이름,부서,점수 민수,영업,82 지영,개발,95 철수,영업,77 영희,개발,88 column: 점수
Result: 85
Department frequency
Input: 이름,부서,점수 민수,영업,82 지영,개발,95 철수,영업,77 영희,개발,88 column: 부서
Result: 값,빈도 영업,2 개발,2

Common Use Cases

  • Quickly summarising sales or score data
  • Seeing the distribution of survey answers

Frequently Asked Questions (FAQ)

What about non-numeric cells?

Blank cells are skipped, but a cell containing text raises an error rather than producing a wrong result. Check blanks with "missing value count".

Have feedback or ideas for this tool? Suggest & Inquire →