Automatically Update airtable using generated data on xls format

Topic Labels: Automations
1338 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I have the following problem.

I use airtable daily to track the progress of specific “qc samples” and In the end we ran a test on the data using a toll Wich gives us results, we then manually update these results on airtable, I have been doing it manually and this takes so much time. I’m looking for a solution that can automatically compare the name on airtable vs the name on excel and update the “final” result using the data on the excel document any suggestions will highly be appreciated.

1 Reply 1

You could export your Excel file as a CSV file, and then use the CSV import extension to import the data. If you turn on the match feature, it will let you match which field you want to use for overwriting records.