Skip to content
atifo

Browse tools

Remove duplicate lines

Clean up lists of emails, numbers and keywords.

Processed in your browser. Nothing is uploaded.

How to remove duplicate lines

  1. 1

    Paste your list with one item per line.

  2. 2

    Choose whether capitals and extra spaces should be ignored.

  3. 3

    Copy or download the list of unique lines.

Clean lists in seconds

Mailing lists, phone numbers, product codes, keyword research and attendance sheets collect duplicates as they’re merged from different sources. Paste the list here and every repeated line is removed, leaving one copy of each item in the order it first appeared.

Delete duplicate lines and remove duplicates from a list: dedupe a list of emails, names or numbers.

Choose what counts as a duplicate

  • Ignore capitals treats “Priya@Example.com” and “priya@example.com” as the same, which is what you want for email addresses.
  • Ignore spaces at ends trims stray spaces, a common cause of “duplicates” that don’t match.
  • Remove empty lines drops blank lines at the same time.

The counter shows how many lines were removed and how many are left, so you can confirm the result before using it.

From spreadsheets and back

Copy a column from Excel or Google Sheets, paste it here, then copy the cleaned list back into your sheet. Each cell becomes a line and comes back as a cell. For a sorted list, run the result through Sort lines, which can also remove duplicates while sorting.

Big lists, private data

Lists of customer emails and phone numbers are personal data. Atifo processes them entirely in your browser, so they’re never uploaded or stored, and even lists with hundreds of thousands of lines are cleaned almost instantly.

Frequently asked questions

Is the original order kept?

Yes. The first time each line appears is kept in its place, and later repeats are removed. To sort the list as well, use Sort lines.

Can it treat “Apple” and “apple” as the same?

Yes. Switch on “Ignore capitals”. The first spelling in your list is the one that is kept.

How many lines can it handle?

Hundreds of thousands. A list of 100,000 email addresses is cleaned almost instantly, and nothing is uploaded.

Can I remove duplicates from Excel or Google Sheets?

Copy the column, paste it here, then copy the result back. Each cell becomes one line.