# Best tips to dedupe

**URL:** <https://air.tableforums.com/t/best-tips-to-dedupe/271>\
**Category:** Airtable Questions\
**Created:** [February 17, 2023, 1:44pm UTC](https://air.tableforums.com/t/best-tips-to-dedupe/271 "2023-02-17T13:44:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![CelineFromFrance](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/celinefromfrance/32/216_2.png) [@CelineFromFrance](https://air.tableforums.com/u/CelineFromFrance)\
**Post date:** [February 17, 2023, 1:44pm UTC](https://air.tableforums.com/t/best-tips-to-dedupe/271/1 "2023-02-17T13:44:29Z")

</div>

Hello les amis !  
What is your best tip to dedupe (without using the extension of course) 😃 ?

---

<div class="post-metadata">

**Author:** ![Kuovonne](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/kuovonne/32/17_2.png) [@Kuovonne](https://air.tableforums.com/u/Kuovonne)\
**Post date:** [February 17, 2023, 2:11pm UTC](https://air.tableforums.com/t/best-tips-to-dedupe/271/2 "2023-02-17T14:11:32Z")

</div>

I’ve used custom scripts to tag potential duplicates. I usually prefer to have a human resolve the duplicates versus automatic deducing.

Why don’t you want to use the Dedupe extension? It works well and is available in all plans (except legacy free plans).

---

<div class="post-metadata">

**Author:** ![ScottWorld](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/scottworld/32/5_2.png) [@ScottWorld](https://air.tableforums.com/u/ScottWorld)\
**Post date:** [February 17, 2023, 2:32pm UTC](https://air.tableforums.com/t/best-tips-to-dedupe/271/3 "2023-02-17T14:32:15Z")

</div>

Welcome to the community, @CelineFromFrance!

Hmmm… deduping without the extension is definitely a tricky one! 😛

As @Kuovonne mentioned, scripting can be used for this.

Outside of scripting, I’ve created duplicate-checking & deduping automations for my clients using [Make](https://www.make.com/en?pc=scottworld).

Also, if you just wanted to look for duplicates within a small number of records that are linked to a unifying record in another table— such as duplicate students on a field trip, or duplicate line items on an order — you can “sort of” check for duplicates. You could use a rollup field & formula field to alert the user to the presence of a duplicate somewhere within the set of linked records, but it wouldn’t let them know exactly which record is the duplicate.

---

<div class="post-metadata">

**Author:** ![CelineFromFrance](https://yyz1.discourse-cdn.com/flex029/user_avatar/air.tableforums.com/celinefromfrance/32/216_2.png) [@CelineFromFrance](https://air.tableforums.com/u/CelineFromFrance)\
**Post date:** [February 21, 2023, 6:41pm UTC](https://air.tableforums.com/t/best-tips-to-dedupe/271/4 "2023-02-21T18:41:25Z")

</div>

Thank you so much for your responses. I had to dedupe 3000 records, but that is true @Kuovonne, no automation could do that for me because there were human decisions to make 😰 I use the extension, could have been worst on excel 🤣