Count values

Count how often each value occurs in a list without opening a spreadsheet. Enter one item per line to get the frequency of repeated values and see which ones appear most often. Settings let you ignore differences in letter case and stray spaces.

The tool goes through the lines and groups those that match according to the chosen options. By default, the comparison ignores upper and lower case and trims spaces at the start and end of each line. So “Paris”, “paris” and “Paris” followed by a space all add to the same total, shown under the first spelling met. Switch these options off if the variants mean something in your data. Results run from the most to the least frequent value, then alphabetically when counts are equal. A frequency is a number of occurrences, not a percentage. Empty lines are ignored. Counting does not fix typos or differences in wording: “bike” and “bicycle” stay separate values. To read the results correctly, keep the original list and check the normalisation rules. A frequency table answers a different question from a deduplicated list: it tells you not only which values exist but also how many times each one appears. That matters whenever repetition carries meaning, for example when summarising survey answers or spotting the most common categories in an inventory. Before reading the figures, check that the labels are consistent: a spelling mistake creates a separate category. Do not confuse the number of occurrences with the number of unique people or objects: several lines may come from the same source. To get a percentage, divide a value’s frequency by the total of relevant occurrences and multiply by one hundred. If you are writing a report, state the normalisation rules and the scope of the data clearly.