+1 I’m also voting for this feature request. Another idea on how to implement this is by introducing a new IMAGE function. Something like Google Sheet’s IMAGE function. You pass the URL on this function and then it displays the image on the cell of Google Sheet.
+1 for this feature. Not being able to (automatically) display images from URLs is obviously a huge pain for everyone here!
+1 for this. AirTable is great but it has incredibly limited support for sheets with pictures or images. I had to learn how to be an Excel VBS Rocket Scientist just to export images in a logical way that I could import into AirTable since CSV doesn’t support images.
hi David, how did you do it? i want to do the same thing too!
Unfortunately the process didn’t quite work like I had anticipated. It was an incredibly obnoxious process, and it may work better for you. Given the complexity of my situation it did not work. These are the steps I had to go through since AirTable doesn’t inherently support image upload with XSLX files.
Run script that saves all Excel images and names the file based on the row it’s in (example 1.png, 12.png, 55.png etc). The script is on Stack overflow, I’ll paste it in here when I can. I’m having trouble logging in to my account right now.
Save original Excel file as CSV
Upload original Excel file.
Manually upload images 1 by 1 into the column they are named after.
OR, if you are ok with linked images rather than having the image thumbnail appear on your sheet, you can bulk upload all the images into a new gallery view and use a linked column to manually link each image to their associated row. It’s mostly all manual.
David did you have the script for this?
Image upload is such a pain in air table, I have a ton of image URL assets that I’d like to port in but can’t…
I would really like the image URL preview link so I can just use my own file attachments instead
The only thing I could possibly think of for uploading images into Airtable is the following workflow:
- Open up Airtable spreadsheet
- Open up Regular spreadsheet with URL images to port in
- Run a Mouse / Keyboard automation macro that grabs each item one by one, puts it over to the airtable link, checks PIXELS for upload successes, and then does each image one by one.
This would assume my airtable spreadsheet and regularspreadsheet have a 1:1 relationship, or that I could use a CTRL+F search for the same primary keys each one shares to grab the image URL
I can’t think of a better way to do this. Not even sure if this would even work correctly either
I would like to see what your script looks like though on SO
for anyone reading this I ended up making a autohotkey macro on this thread:
+1 for this feature! I’m so used to =IMAGE(“URL”) on regular spreadsheets.
+1 I understand that this might be contrary to the AirTable pricing model to allow us to store our images in other clouds rather than uploading them, but there are so many other services that do this (google sheets etc.), I can’t imagine storage is the only way for AirTable to ensure that people purchase plans. In fact, I would pay for the ability to link directly to images stored on BOX or Dropbox, or a simple URL link.
There seem to be many people who want this. Can we get an official reply on why it is not implemented?
+1 This would be incredibly useful in automating our marketing reports
You can use a multi-step zap to copy an image URL created via formula to a true URL/link field, and then also an attachment field. When the attachment field contains a URL to an image, it will display it in-line. We use this to generate and display barcodes.
This is a great solution and thank you for sharing. I will definitely be using it.
It does annoy me that it works with zaps but not when importing a csv or pasting the URL in the attachment field. I have a list of 9000+ products that I’d have to run nicely timed zaps to get those images there and still would be a time saver–I already have ways to use Zapier to populate images for these existing products but it would be great not to use the 9000 tasks and simply paste, in a way that makes it more consistent with the Zapier action (which to ignorant me is like pasting the value in the field)
@polen Agreed, for manual “copy and pastes” I’d argue the Attachment field should accept an Image URL. That said, for automation, you’d likely still need Zapier. In our case, we have a formula that generates a unique Image URL (barcode), which we then need to auto-populate within an Attachment field. Thus Zapier is truly required for us… At least until Airtable adds some sort of scripting.
Yes please! I use air-table to process data that is exported from another software as a CSV, containing many many urls to photos.
Another option might be auto-import of images from a trusted partner, say Dropbox, based on a formula that matches image names. I know manual image import from Dropbox is already possible via Filestack, it’s just not usable via formula/script.
I was searching for a solution to Upload files through URL, and I found for myself an automation software called Integromat. It’s like Zapier, but as for me much flexible and easier to use. Also there is no limitation for steps, just for operations/month (in the free version).
I created a little video of how to use it. Hope this will be helpful.
Video - https://youtu.be/ucoXsRejUT0
This would be insanely useful in tracking my digital art pieces and prints. I’d appreciate being able to link to my works and sort who bought what based on that image without being limited by the file size.
Hi - would you have you a solution to doing this with a localhost address on my Mac? Like pulling the image from a location address like this into Airtable …
I am having a similar situation, although it might be the other way, sort of… I have an Airtable base for my postage stamp collection. I am now entering into the phase of deciding what is the best way to automatically insert URL’s (I am not really looking forward to doing this manually), since I have about 2,000 records to enter URL’s into the field, for website addresses, in my base. I should mention that I am using the free version on my iPads iOS 10 &11 and MacBook High Seirra 10.13.
The website is:
Then, from there the Integration/Zapier app would need to select a year the stamp was issued, in this case, there are some years that it’s just some of the stamps, but over the past 3 or 4 years, it will be pretty much all of them, i.e.:
Then the integration app would need to match up to the actual stamp that I need, which in this case is the link below, and it’s this page that I want the URL copied into the Airtable base (Website field):
It appears that the 5 digit number (in the above link: 15568 is a unique number, in sequence, although there might be some missing numbers, but it’s still in numerical sequence, assigned to each stamp. The next stamp in order is: 15569, but the next one jumps to 15571. I don’t know if this helps, but I thought I should mention it.
If an integration app (Integromat or Zapier) will not be able to do this directly, then perhaps I could do this indirectly, by using Excel or Google Sheets to populate Airtable, Either, directly into my original base or in a separate base, preferably with an image, so than I can easily copy and paste the URL into the main stamp collection base, using the images as a guide to match to the record, or if any of the above processes used, it can match it directly to the record in the original base, that would be even better. I don’t need to copy the images, since I have a separate field for that purpose. The images (for matching only) would be in its own field in a temporary base or new table within the original base, and a second field would be created (next to the temporary images field) so all the URL’s will be copied or uploaded automatically into each record.
Or maybe I am asking for the moon. ️
I only need the the temporary images that are connected with the URL’s for a visual guide, so I can match them correctly with the record in the main stamp collection base.
Also, please keep in mind that this process would be very new for me, so there might be a learning curve involved, but I like to learn new things.
I hope this makes sense.
I don’t think you can do it directly, because, as I know, airtable API doesn’t support URL uploads from a localhost.
The solution would be to upload all your images to a webhosting keeping all the names.
Then just add the web-hosting url to your image file names (for example for image_1.jpg it would be
https://webhostingexample.com/airtable-uploads/image_1.jpg). Or if you have the adress database of your images (like file://localhost/airtable-uploads/image_1.jpg), replace the file://localhost/ to https://webhostingexample.com/ . The replacement you can do easily with airtable formulas or google sheet.
After doing that, you can use the solution I showed in the video.
For webhosting you can use your own website hosting(if you have one), just create a new folder in it and upload all your images via ftp.
Basicly, this hosting will be just a temporary storage for your images, as airtable will upload them to it’s own server.