Duplicates
Remove duplicate rows from a CSV
Lists merged by hand often hold the same row twice. Remove duplicates keeps the first of each and says how many it removed.
Open workspaceWhen this helps
Use this for mailing lists, exports joined from several files, or any list where each row should appear once.
For example
A task you can finish here
A sign-up list where some people registered twice: choose the email column, Only by the chosen column, and Remove duplicates keeps each address’s first row.
The workflow
Three clear steps
- 01
Open the list
Edit says how many rows repeat before you remove them.
- 02
Remove duplicates
Compare every column, or choose columns and compare only them. Trim spaces first to also catch rows that differ only by spaces.
- 03
Save a copy
Undo brings the rows back if the count is not what you expected.
Your files and the public site
Open files only in the separate Table workspace. Its processing runs in your browser; this public site does not receive your files, their names, what they contain or any setting.Read the privacy information.
Questions
Does it compare similar rows, such as “Jon” and “John”?
No. Only exact repeats, after trimming if you choose Trim spaces.
Ready to make the copy?
Your files stay unchanged.
Open workspace