Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

CSV Import - Merge Only

Topic Labels: Extensions
Solved
Jump to Solution
12118 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Darryl_Oliver
6 - Interface Innovator
6 - Interface Innovator

The CSV Import app will merge records from a CSV file with existing matching records and create new records in the target table. As far as I know, it’s not possible to merge/update only without adding new records. Am I missing something?

Thanks.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

As far as I know, there is no native way to do what you want to do.

A quick way of handling this might be to simply delete the extra records after you have imported them.

However, for the best way of automating this process, I would highly recommend using Make's CSV integrations and Make's Airtable integrations to handle this for you.

You would setup an automation that would enable you to drop your CSV file into a cloud drive of your choice, and then Make would process each row of your CSV file for you.

You can then use routers & filters to create conditional paths in Make. This would tell Make to update any matching records in Airtable, while skipping any non-existing records in Airtable.

In this Airtable podcast episode, I show how to do a more generic CSV import into Make. It doesn't specifically solve your problem, but it gives you a general overview of how you can work with CSV files in Make & Airtable.

For a little bit more advanced training on Make, I’ve assembled a bunch of Make training resources in this thread.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

See Solution in Thread

1 Reply 1
ScottWorld
18 - Pluto
18 - Pluto

As far as I know, there is no native way to do what you want to do.

A quick way of handling this might be to simply delete the extra records after you have imported them.

However, for the best way of automating this process, I would highly recommend using Make's CSV integrations and Make's Airtable integrations to handle this for you.

You would setup an automation that would enable you to drop your CSV file into a cloud drive of your choice, and then Make would process each row of your CSV file for you.

You can then use routers & filters to create conditional paths in Make. This would tell Make to update any matching records in Airtable, while skipping any non-existing records in Airtable.

In this Airtable podcast episode, I show how to do a more generic CSV import into Make. It doesn't specifically solve your problem, but it gives you a general overview of how you can work with CSV files in Make & Airtable.

For a little bit more advanced training on Make, I’ve assembled a bunch of Make training resources in this thread.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld