Remove Duplicates by Column

Remove duplicate rows from a table based on one or more key columns. Keep the first or last row, ignore case and spaces, and review exactly which rows were dropped.

  • Free, no sign-up
  • Runs in your browser
  • Your data stays private

How to use the Remove Duplicates by Column

  1. Paste your table and set the key column or columns, such as Email.
  2. Choose whether to keep the first or last row.
  3. Copy the unique rows, or switch to the removed rows only.

Why use this Remove Duplicates by Column

  • Multi-column keysCompare 1,3 or Email,Country together.
  • First or lastKeep the earliest or the most recent row.
  • Removed rows reportLists every dropped row and which row it duplicated.
  • Forgiving matchIgnore case and spaces so "[email protected]" equals "[email protected]".

Frequently asked questions

How do I remove duplicates based on one column?

Enter that column in "Compare these columns". Rows with the same value are treated as duplicates.

Which row is kept?

The first by default. Choose "Last row" to keep the latest one.

Can I see what was removed?

Yes. The "Removed" tab lists every dropped row with its row number.

Related tools

More Spreadsheet & CSV tools

User Reviews

–
No ratings yet
Write a review
Your rating *

Your email is never published. Reviews are moderated, and links aren't allowed.

What users are saying

No reviews yet

Be the first to share your experience with this tool — your feedback helps others.