Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

How to Remove Duplicates in Clay Like Google Sheets | Clay

How to Remove Duplicates in Clay Like Google Sheets

·Dec 04, 2025 10:05 AM·

Hi guys, anybody know how to remove duplicates in Clay like in Google Spreadsheet. For example if the same value exist collumn "Name" in both row 1 and 2, Clay will delete row 1?

7 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! Clay has two ways to remove duplicates:
Manual dedupe:
1.
Click the column header you want to dedupe
2.
Select "Dedupe" from the dropdown
3.
Confirm which duplicate values to remove and click "Delete" [1]
Auto-dedupe (recommended):
1.
Click the "Auto-dedupe" icon at the bottom-right of your table
2.
Toggle on "Enable automatic deduplication"
3.
Select your column (like "Name")
4.
Click "Save Changes"
Auto-dedupe keeps the oldest row and deletes newer duplicates automatically. [2] Note that deduplication is case-sensitive and considers whitespace.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with removing duplicates or have other questions about using Clay, I’m here to assist. Would you like to share more about what you’re trying to achieve or any specific issues you’re facing?
Taimoor A.
·
·
Use dedupe
Clay Support
APP
·
·
Perfect! Here's how to use the manual dedupe:
1.
Click your column header (like "Name")
2.
Select "Dedupe" from the dropdown
3.
Review duplicate values and click "Delete" [1]
Important: Deleted rows can't be recovered, and deduplication is case-sensitive ("Clay" ≠ "clay").
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you still need help with using dedupe or have any other questions about managing your data, I’m here to assist. Would you like to provide more details about what you’re trying to resolve or understand?