Remove duplicate lines

Paste your list, one item per line, and the tool keeps one copy of every line and drops the repeats. Choose whether case and extra spaces count, then copy the result or see how many times each line appeared.

Everything runs in your browser. Your text and files stay on your device and are never uploaded.

Paste a list to see the result.

How to use it

  1. Paste your list into the box, or open a .txt or .csv file. A column copied from Google Sheets works as is.
  2. Pick what counts as a repeat: ignore upper and lower case, extra spaces, or both.
  3. Choose what to keep: one copy of every line, only lines that appear once, or only the lines that repeat.
  4. Optionally sort the result A to Z, Z to A, or by how often each line appeared.
  5. Copy the result or download it as a text file, then paste it back into your sheet or document.

Questions

How do I remove duplicate lines from a list?

Paste the list into the box. The result below shows each line once, in the order it first appeared. Copy it or download it as a .txt file.

Which copy of a repeated line is kept?

The first one. If Apple appears on line 2 and apple on line 9 with case ignored, the result keeps the line 2 spelling.

Can I find only the lines that repeat?

Yes. Set What to keep to Only lines that repeat to list every line that shows up more than once. Choose Only lines that appear once for the opposite.

How do I see how many times each line appears?

Press Show counts for a table of every distinct line with its count, most repeated first. Copy it as tab separated text to paste into a sheet.

Why are lines that look identical not removed?

Usually a trailing space or a different capital letter. Keep Ignore extra spaces and Ignore upper and lower case ticked to treat them as the same line.

Is my list uploaded anywhere?

No. The work happens in your browser, and a file you open is read on your device only. Lists up to 500,000 lines are checked.

More free tools

All free tools