Home › Text Tools › Count Duplicate Lines
Count Duplicate Lines
Paste a list and see how many times every line appears, most frequent first. Show only the repeated lines or only the unique ones, ignore case or extra spaces, and export the counts as text or CSV.
Last updated:
Show
e.g. 3 = only lines that appear 3 or more times.
Enter your values to see the result.
Advertisement
Advertisement
How to use the Count Duplicate Lines
- Paste your list with one item per line.
- Choose what to show: all lines with counts, only duplicates or only unique lines.
- Set matching options such as ignore case and trim spaces.
- Pick a sort order and output format, for example CSV for a spreadsheet.
- Copy or download the counts, or download the full frequency table.
Example
For the list apple, banana, Apple, cherry, banana, kiwi, apple, banana (one per line) with Ignore case on:
| Line | Count | Share |
|---|---|---|
| apple | 3 | 37.5% |
| banana | 3 | 37.5% |
| cherry | 1 | 12.5% |
| kiwi | 1 | 12.5% |
8 lines, 4 distinct, 2 repeated lines, 4 extra copies, duplicate rate 4 ÷ 8 = 50%.
Useful ways to use a line counter
- Tally survey or form answers exported one per line.
- Find repeated email addresses, SKUs or IDs before an import, using Only duplicates.
- Spot the noisiest log messages: paste log lines (with timestamps removed) and sort by count.
- Check a word list or keyword list for accidental repeats.
- Count votes or picks where each line is one vote.
Matching options explained
- Ignore case: Apple, APPLE and apple are one line.
- Trim spaces: “apple ” with a trailing space matches “apple”. Invisible trailing spaces are the most common reason two lines that look identical are counted separately.
- Treat multiple spaces as one: “New York” matches “New York”.
- Ignore accents: “café” matches “cafe”.
Frequently asked questions
How do I count how many times each line appears?
Paste the text into the box. Every distinct line is listed with its count, highest first. The summary also shows how many lines are repeated, how many appear only once and the most frequent line.
What is the difference between this and removing duplicate lines?
Removing duplicates gives you a clean list with each line once. Counting duplicates tells you how often each line occurred, which is what you need for tallies such as survey answers, log entries, votes or repeated orders.
Is “Apple” the same as “apple”?
With Ignore case on (the default) yes, they are counted together and the first spelling seen is displayed. Turn it off for a case-sensitive count.
What does “extra copies” mean?
It is the total number of lines minus the number of distinct lines: the number of lines a duplicate remover would delete. For example 12 lines with 6 distinct values have 6 extra copies.
Can I get the same output as the Unix command sort | uniq -c | sort -rn?
Yes. Choose the count ⇥ line format and sort by count, highest first. Unlike uniq, the lines do not need to be sorted first, because counting here is done on the whole list.
How do I open the counts in Excel or Google Sheets?
Choose CSV as the output format and download the .txt (rename to .csv), or press Download CSV above the frequency table, which also includes the share and line numbers.
Is my data sent anywhere?
No. All counting happens in your browser, so the list never leaves your device.
Are all the tools on FreeToolCabin tested for quality and accuracy?
Yes! Every tool on our site undergoes automated Q/A testing in real browser environments to ensure high precision, correct output, and zero errors. If you happen to spot a bug or have a suggestion, please contact us at [email protected] and our team will review it right away.
Related tools
Remove Duplicate LinesDelete duplicate lines from any list, ignoring case or spaces, keep first or last, and sort.Word Frequency CounterFind the most used words and phrases in any text and turn them into a word cloud.Sort Lines AlphabeticallySort a list A-Z, Z-A, numerically, naturally or by length, or shuffle it.Line CounterCount total, non-empty, blank and unique lines in text or a .txt file, with line length stats.Online Word ProcessorFree browser word processor with headings, lists, tables and images. Autosaves; export DOCX or PDF.Remove Line BreaksStrip line breaks and extra spaces, keep paragraphs if you want.Case ConverterConvert text to UPPERCASE, lowercase, Title Case, camelCase and more.MLA Format GeneratorBuild an MLA 9 heading, title page layout and Works Cited entries.Lorem Ipsum GeneratorGenerate placeholder text as paragraphs, words or lists, with HTML.Text RepeaterRepeat any text or emoji up to 100,000 times with custom separators.Find and Replace TextFind and replace words or regex patterns in any text, with match highlighting and undo.Add Line NumbersNumber every line of your text with custom start, step, padding and separator, or remove numbers.Add Prefix and Suffix to LinesAdd text to the start and end of every line: quotes, commas, bullets or SQL lists.Comma SeparatorTurn a column of lines into a comma separated list and back, with any delimiter.Text to Handwriting ConverterTurn typed text into realistic handwriting on notebook paper and save it as PNG or PDF.Japanese Kana ConverterConvert romaji to hiragana or katakana, kana to romaji, and hiragana to katakana instantly.Pinyin Tone ConverterTurn pinyin tone numbers (ni3 hao3) into tone marks (nǐ hǎo), or tone marks back into numbers.Remove Extra SpacesClean up double spaces, tabs, blank lines, non-breaking and invisible spaces in one click.Random Word GeneratorGenerate random English words by type, length, first letter and syllables, then copy them.List RandomizerShuffle a list into random order, pick random items or split it into fair teams.Email ExtractorPull every unique email address out of text or files, sort, filter by domain and export CSV.URL ExtractorExtract every link from text or HTML, remove duplicates, filter by domain or protocol.Strip HTML TagsRemove HTML tags and get clean plain text with line breaks and decoded entities.Online NotepadPrivate notepad that autosaves notes in your browser, with find, word count and .txt download.Remove PunctuationStrip all or only selected punctuation from text, with smart options for apostrophes and numbers.Text SplitterSplit long text into chunks by characters, words, lines or a delimiter, with numbering and copy.Remove AccentsStrip accents and diacritics from text (é→e, ñ→n, ß→ss, ø→o) instantly, live as you type.Sort NumbersPull numbers out of any text and sort them ascending or descending, with sum, average and median.Thread SplitterSplit long text into numbered X, Threads, Bluesky or Mastodon posts at sentence boundaries.Duplicate Word FinderFind repeated words in your text: doubled words like "the the" and overused words, highlighted.Alternating Caps GeneratorTurn text into aLtErNaTiNg caps, random caps or alternating words, then copy it.Random Paragraph GeneratorGenerate readable random English paragraphs by topic and length for writing and design.Random Sentence GeneratorGenerate random grammatical sentences: simple, compound, complex and questions.Markdown to Plain TextStrip Markdown syntax and keep clean plain text with lists, line breaks and link URLs.SRT to TextTurn SRT or VTT subtitles into a clean transcript with paragraphs, with or without timestamps.Transcript CleanerRemove timestamps, speaker labels and filler words like um and uh, and fix broken line breaks.Extract Numbers from TextPull every number out of text: decimals, negatives and percentages, with sum, average and CSV.Extract Phone NumbersFind phone numbers in any text, normalize them to E.164, remove duplicates and export CSV.Word Wrap ToolWrap text at any column width with hard line breaks, indents and prefixes, or unwrap it again.Daily Affirmation GeneratorGet random positive affirmations by theme; save favorites, copy them or make an image card.Business Plan GeneratorFill in a guided form and get a formatted business plan with financial tables, as Word or PDF.Keyword Match Type ConverterTurn a keyword list into broad, "phrase", [exact] and negative match types for PPC ads.Discord Text FormatterFormat Discord messages with bold, spoilers, headers, quotes, lists and code blocks, with live preview.DNA Reverse ComplementGet the reverse, complement or reverse complement of DNA/RNA, FASTA and IUPAC codes supported.Filter Lines Containing TextKeep or remove lines that contain words or match a pattern, with match counts and regex.Focus Reading ConverterBold the first letters of every word for faster, focused reading. Copy as rich text or HTML.Memo GeneratorWrite a business memo in standard To/From/Date/Subject format, then print, copy or save as .docx.PDF Text CleanerFix text copied from a PDF: join broken lines, undo hyphen splits, drop page numbers and headers.Pros and Cons List MakerWeigh a decision with a weighted pros and cons list, a score, a verdict and easy export.Remove Numbers from TextStrip all numbers and digits from text, keep MP3-style words or ordinals, and tidy the spaces.Return Policy GeneratorCreate a return and refund policy for your store as text or HTML, with a refund example.Screenplay FormatterType a script in plain text (Fountain) and get a properly formatted screenplay, page count and PDF.Word ChangerSwap words for synonyms in your text, then click any word to cycle through alternatives.Words That End WithFind English words ending in any letters or suffix, filtered by length and sorted by score.Annotated Bibliography GeneratorBuild an APA or MLA annotated bibliography with hanging indents and download it as DOCX.EPUB to Text ConverterExtract plain text from EPUB e-books, pick chapters, count words and download a TXT file.Extract Dates from TextFind every date in text, in any common format, and convert them all to one format you choose.Extract Text Between DelimitersPull out every piece of text between brackets, quotes, HTML tags or your own start and end markers.Recipe Shopping List GeneratorPaste several recipes and get one combined grocery list with merged amounts, by store section.One Word Per LineSplit any text into a list with one word per line; strip punctuation, dedupe, lowercase and sort.Recipe FormatterPaste a messy recipe and get clean ingredients, numbered steps, scaling and a printable card.Remove Words from TextDelete a list of words or phrases from any text and see how many times each one was removed.Reverse Line OrderFlip the order of lines, list items or paragraphs so the last becomes first.Pairwise Sequence Alignment ToolAlign two DNA or protein sequences, global (Needleman-Wunsch) or local (Smith-Waterman), with identity %.Sort Lines by LengthSort lines from shortest to longest or the reverse, with ties sorted A-Z and lengths shown.Sort Words AlphabeticallyPut the words in any text in A-Z or Z-A order, remove duplicates and pick a separator.Sentence SplitterSplit text into one sentence per line, smart about abbreviations, decimals and quotes.Text to Table ConverterTurn tab, comma, pipe or space separated text into a table to copy as rich text, Markdown or plain text.