Skip to main content

Is it possible to do this?

I’d like have an Airtable form with an attachment field, requiring someone to submit a CSV file (with info already filled out).

The contents are then imported into an existing table with the contents mapped out accordingly?

I’d have them fill out the contents with a form, but sometimes entries could be as much as 20+ …

I checked MiniExtensions but didn’t find anything that would work for this use case.

Help is appreciated.

Welcome to the Airtable community!

Yes, this is possible with scripting. You can run an automation script when the form is submitted. I have written scripts that do this. However, this is not a script for a beginner to write. Here are some reasons why:

  • The script will need to get and parse the CSV file. There are multiple flavors of CSV, and parsing particular versions can be very tricky, especially if there are field values that can contain commas, quotes, or multiple lines. Scripting does not allow the use of libraries, so you cannot use a library to parse the CSV.
  • There is usually a slight delay before an attachment is fully uploaded, the automation script may need a slight delay before it does a fresh read of the record to get the attachment url.
  • Obtaining attachment urls is going to change in November. Full details on how the changes impact scripting have not yet been released. Depending on the changes, you may need to update the script then.
  • You may need to do data type conversions from the text in the CSV to the field write format.

This may also be possible without scripting using 3rd party integration tools. Perhaps one of the experts in those tools will chime in.

Welcome to the Airtable community!

Yes, this is possible with scripting. You can run an automation script when the form is submitted. I have written scripts that do this. However, this is not a script for a beginner to write. Here are some reasons why:

  • The script will need to get and parse the CSV file. There are multiple flavors of CSV, and parsing particular versions can be very tricky, especially if there are field values that can contain commas, quotes, or multiple lines. Scripting does not allow the use of libraries, so you cannot use a library to parse the CSV.
  • There is usually a slight delay before an attachment is fully uploaded, the automation script may need a slight delay before it does a fresh read of the record to get the attachment url.
  • Obtaining attachment urls is going to change in November. Full details on how the changes impact scripting have not yet been released. Depending on the changes, you may need to update the script then.
  • You may need to do data type conversions from the text in the CSV to the field write format.

This may also be possible without scripting using 3rd party integration tools. Perhaps one of the experts in those tools will chime in.


Do you have a script you sell?

Do you have a script you sell?


Scripts like these need to be customized to the base and CSV files that they need to work with. I no longer offer custom scripting services, although that might change in the future.

You can post in the Hire a consultant section of this community.

Your #1 best bet for doing all of this would be to use Make’s CSV integrations in conjunction with Make’s Airtable integrations.

I demonstrate how to do this on this episode of the BuiltOnAir podcast:

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps!

If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Terms & Conditions