Help

Pull CSV/Excel from URL, Process Thoroughly, Populate Selected Airtable Fields

Topic Labels: ImportingExporting
812 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tiberius
6 - Interface Innovator
6 - Interface Innovator

Hi,

we are doing a lot of local Excel work where report files are downloaded, stored in a certain location and then processed using VBA macros.
Now, I’m looking to automate that process in the cloud and move it a little further by bringing the resulting values into Airtable.

What are ways to properly process these CSVs/Excel spreadsheets based on a specified rule set and then send the results to Airtable where rows will be updated based on a set of rules again? What allows for similar changes as the VBA macros when it comes to processing the original reports?

Thanks,
Jan

0 Replies 0