ETL app for Airtable?

[Jeb_Dasteel]

Is there an ETL app for Airtable? I need to do basic clean up, such as changing ; delimiters to , delimiters. Thanks.

[Bill.French]

Hi Jeb and welcome to the community!

@Jeb_Dasteel

Is there an ETL app for Airtable?

Nope. But you can build one in a script block. This one might get you much of the way.

Field Tweaker - Script Block for In-place Transformations

After importing data, it’s not uncommon to want to clean up and normalize data values, especially text fields that may have all types of inconsistencies. Unfortunately, Airtable doesn’t support in-place transformations where formulas can be applied to modify the field contents of all cells. This is where the Field Tweaker script block can help. It supports in-place text transformations including upper case, lower case, and title case modifications across all records for select fields. The scrip…

[Jeb_Dasteel]

Bill, this is fantastic! Thanks very much. I’ll give it a shot.

Jeb