CSV Value Counter
Pick a column and get every different value with its count, its share and the running share. Split cells that hold several values, or group numbers into ranges.
Drag a file here or choose one
Worked examples
Counting teams
Team Blue Red Blue Blue Red
Blue,3,60.0%,60.0% Red,2,40.0%,100.0%
3 of 5 is 60 percent. The running share reaches 100 percent at the last value.
Scores in tens
Score 42 37 42 9 100
0 up to 50: 4 100 up to 150: 1
With a group size of 50, four scores fall between 0 and 50.
About CSV Value Counter
Pick a column such as status, team or country and see every different value with the number of times it appears, its share of the total and the running share down the list. The running share shows where the first few values add up to most of the data, which is how you find the handful of customers, products or errors that account for 80 percent. It is a frequency table in one step.
Some columns hold several values in one cell, such as tags or a list of skills separated by commas. Tell the tool the separator and each part is counted on its own, so a cell with two tags adds one to each. For a column of numbers, group them in steps, say 10, and the counts become a histogram: 0 up to 10, 10 up to 20 and so on, where the top of each range is not included. You can ignore capital letters, count blank cells and show only the top few values.
How to use CSV Value Counter
- Paste your CSV or open a file.
- Choose the column to count and how to order the results.
- If cells hold several values, type the separator. For numbers, enter a group size.
- Download the counts or copy them.
Common uses
- Finding the most common reasons, products or countries
- Counting tags or categories stored in one cell
- Making a histogram of ages, scores or order values
- Checking a column for spelling variants
Frequently asked questions
What is the running share?
The share of all values accounted for by this value and every value above it. If the top three values have running share 82 percent, they make up 82 percent of the column.
How do ranges work?
With a size of 10, the range 20 up to 30 holds values from 20 up to but not including 30. A value of exactly 30 goes in the next range.
How are cells with several values counted?
Each part counts separately. With the separator set to a comma, the cell a,b adds one to a and one to b, and the total counts both.
Are capital letters counted as different values?
Only if you untick the box. With it ticked, Leeds and leeds are counted together and shown in lower case.
What about blank cells?
They are ignored unless you tick Count blank cells, in which case they appear as (blank).