The purpose of this tool is to deduplicate records in the notion table where candidates are automatically selected and grouped by a `title` field.

Choose the records you want to merge and keep in the table. All other records are moved to a backup table (with prefix `dedup+`) so you will not lose them and will able to identify and restore them if needed.

# 

This app requires an internal integration token (in format: ntn\_\*\*\*\*\*\*\*\*\*\*) in order to link to your workspace, more in [**Install via internal integration token**](https://www.notion.com/en-gb/help/add-and-manage-connections-with-the-api#install-via-internal-integration-token)**.** 

1. Let’s start in the Notion database with table view:  
   ![][image2]  
2. To initiate deduplication. click: ![][image3]or the cat icon in a browser toolbar ![][image4]  
3. A new window will open  where you can choose how to process duplications (default is `Similar,` which assigns records with a difference of 1 character to the same group. `Exact` assigns identical records to the same group.)  
   ![][image5]  
4. In the window below you can see a list of duplications grouped by a `title`, which in this example is the `Name` column:  
   ![][image6]

   The list of duplication groups contains only records potentially duplicated. Unique records are not included in this list.

5. By clicking  ✖ you remove records from a group you wish to update so those records are ignored during update. E.g. in this example you can remove `Allison` from the `Alison` group,  assuming this is a unique record. This leaves two records:  
   ![][image8]

   which you wish to process. 

   * Select the record you wish to keep by clicking  ✔
   * You can choose the `age` field from the other record  
    
   ![][image10]

6. Clicking `Update group` button updates selected record ✔ with fields highlighted in `blue`.  
7. The group will be updated to single unique record:  
   ![][image12]

   The updated Notion table now looks like this:![][image13]

   with age changed to `34`. Other records (in the example record `Alison,UK,M,34`) will be moved to a backup table, named by adding `dedup+` prefix to a table name:

   ![][image14]

[image2]: img/image2.png {width=600px alt="Example Notion database with duplicate records and an 'Update Group' button."}

[image3]: img/image3.png {width=80px alt="Deduplicate button" .inline}

[image4]: img/image4.png {width=150px alt="Extension toolbar" .inline}

[image5]: img/image5.png {width=300px alt="Dropdown menu for selecting match type when grouping: options 'Exact' and 'Similar'."} 

[image6]: img/image6.png {width=200px alt="Group 'Allison'—table showing duplicate records with one record selected and an 'Update Group' button below"}

[image8]: img/image8.png {width=200px alt="Group 'Allison'—two duplicate records side by side with differences highlighted and a tick next to one record."}

[image10]: img/image10.png {width=200px alt="Group 'Allison'—two duplicate records side by side with differences highlighted and a tick next to one record."}

[image12]: img/image12.png {width=200px alt="Group 'Allison'—single remaining record after deduplication with a disabled 'Update Group' button."}

[image13]: img/image13.png {width=600px alt="Example database without duplicate records."}

[image14]: img/image14.png {width=600px alt="Deduplicated database containing a single record."}