All Articles

How to delete duplicates in a Notion database

I know of 2 ways to delete duplicates from a Notion database.

1. Use a secondary database with a forumula

This option is very flexible. You can set granular rules for how to identify duplicates. However it requires editing your database and manually setting up the duplicate detection.

Here is a tutorial of this approach, by @NotionWorkflow:

2. Use the free Delete Duplicates tool I created on Exnota Tools

This uses the official Notion API. You don’t need to modify your database to use this, or setup a second database with formulas. It requires far fewer steps.

The disadvantages are that: 1. It take some time, because it must do the deletions one at a time (Notion’s API doesn’t support bulk actions yet), 2. It currently only matches on title.

Try it out: Delete Duplicates

Screenshot of the Delete Duplicates in Notion databases tool"

Published Dec 7, 2024

Happy to hear from you at matt@matt.fyi or @mattjustfyi on X.