Duplicate Line Counter
Paste a list and see each distinct line with the number of times it occurs and its share of the total, sorted by count, alphabetically or by first appearance.
Use the tool
Why this tool exists
Logs, exports and keyword lists often hide repeats that are the real story: the same error appearing 400 times, a customer listed twice, the most common value in a column. Sorting a list and removing duplicates tells you what is there, but not how often.
This counter gives a frequency table. You can ignore case and trim spaces so that apple and Apple count together, show only lines that occur more than once, and sort by count, alphabet or first appearance. The header line reports total lines, distinct lines and how many duplicates there are. The first spelling of each line is shown. Blank lines are not counted. It handles plain lines, not CSV columns, so extract the column first.
How to use it
- Paste your lines, one value per line.
- Choose whether to ignore case, trim spaces and show only duplicates.
- Pick a sort order and read the counts and percentages.
Frequently asked questions
Which spelling is displayed when case differs?
The first spelling found in your text. If Apple appears before apple, the combined line is shown as Apple with the total count.
Are empty lines counted?
No. Blank lines are skipped, and the totals only include lines with content after trimming when trim is on.
How do I only remove duplicates?
Use a dedupe tool for that. This one is meant to show the counts, so you can decide which repeats matter.
Can I analyse a CSV column?
Extract the column first with the column splitter, then paste the values here. Each line is treated as one value.