Need urgent help- Uploading CSV file every week keep adding data from week before- how to prevent duplication

Hey ​@Malak Marzouk!

Forward looking ​@TheTimeSavingCo’s answer is spot on!
For merging already created duplicates on your base, you might want to check out Airtable’s Dedupe extension.

Hope this helps.

Mike, Consultant @ Automatic Nation  

Hi Malak, in this case since your data is received via a Google Form, and it creates new lines in Google Sheets, I would recommend to use an Airtable Automation that triggers for every new line in Google Sheets, and adds the new submission to your table checking if the submitter already exists in your table, maybe by their email, to avoid duplicates.

This will streamline the process to work with no manual effort.

​@Mike_AutomaticN ​@TheTimeSavingCo  ​@mtrebinonixon Thank you so much for your help.. I toggled merge with existing files and chose the startup name as the benchmark and it worked. Only got the additional 17 records added to my base, the 10 old ones remained unchanged (although it did tell me 1 of the 10, was updated not sure why because applicants cannot adjust their application, but anyway).

By the way, ​@Malak Marzouk, I wanted to let you know that if you’re looking for a completely automated way of importing your CSV files and having duplicates automatically merged on your behalf (without you manually needing to import nor manually needing to check for duplicates), you can do that with Make’s CSV automations. I demonstrate how to do that on this Airtable podcast episode.

Hope this helps!

- ScottWorld, Expert Airtable Consultant