Which row is kept when there are repeats?

The first one. Later repeats are removed, and the original order is kept.

Do extra spaces get in the way?

No. The trim spaces step runs first, so "Ana " and "Ana" count as the same.

Remove duplicates in CSV

Clean up customer, contact and product lists by removing repeated rows. Compare the whole row or only the columns that identify a record, like email or ID.

1.Open the CSV file.
2.In the "Remove duplicates" step, choose the columns that identify a repeated row.
3.Download the CSV without duplicates.

Tool

Everything is processed in your browser. Your text and files are never sent to a server.Questions about this tool?

Learn more about Remove duplicates in CSV

Remove repeated rows from CSV files, comparing the whole row or just some columns, like email or ID. Free and with no data uploads.

Which row is kept when there are repeats?: The first one. Later repeats are removed, and the original order is kept.
Do extra spaces get in the way?: No. The trim spaces step runs first, so "Ana " and "Ana" count as the same.