Oct 11, 2018 01:24 PM
I have a records with attachments that I have filtered down to just what I want to download. Is there a way to download all the attachments of the filtered records? Or do I have to walk through each record downloading each individually?
Oct 11, 2018 01:33 PM
Just through the airtable website, no I don’t think there’s any mass download option.
If you are going to do it often, or if you have a huge number of downloads, you can write a script using the airtable API. The API lets you specify a particular view to list, and contains attachment URLs that you can fetch from your script
Jan 09, 2020 02:41 PM
For those who are not technical, we built a tool that allows anyone to Bulk Download Attachments from Airtable instead of downloading each record individually. You can also limit it to only export attachments from a specific Airtable view.
Mar 25, 2020 07:58 AM
Please just integrate a function to allow bulk downloading… it’s been YEARS without any such function. Second-rate.
Mar 11, 2022 12:33 PM
^ bump. this would be really great and save tons of time.
Jun 22, 2022 03:45 AM
This should be a priority in Airtable roadmap…
Jul 20, 2022 01:51 AM
Yes this would be really helpful in my current project
Jul 20, 2022 09:05 PM
Hi,
insert new field with formula (set your field name)
IF({Attachments},
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(
'curl -o "' &{Attachments},
'(https:','" https:'
),')',''),
',',' & curl -o "')
)
copy whole column. paste it to cmd window
may be a bit bugged if filename contains round brackets or comma
Jul 27, 2022 02:49 PM
Here’s a cleaner formula.
(limitation: it only gets the first attachment).
IF(
{Attachment},
'curl -o "' &
SUBSTITUTE(
SUBSTITUTE(
REGEX_REPLACE(
SUBSTITUTE({Attachment}, '"', ''),
'(.*?) \\(https(.*?)\\)',
'$1" "https$2"'
),
'(',
''
),
')',
''
)
)
Copy then the content of the formula column, paste it on a file batch_dl.sh
and then run it sh ./batch_dl.sh
.
Jul 27, 2022 02:53 PM
You can do this with our On2Air Backups extension. It exports all table data and attachments to Google Drive, Dropbox, or Box.