Skip to main content

Importing CSV with Image References

  • February 19, 2017
  • 6 replies
  • 32 views

Forum|alt.badge.img+2

I am considering moving from the iOS application MyStuff to Airtable. My only struggle is with importing images linked to the records.

When exporting from MyStuff, the result is a CSV file and then folders with related images. Does Airtable have the ability to import images based on file location references in a file in the CSV? Do the images need to be in the same directory as the CSV?

Thanks for any insight.

Regards,
Rob

6 replies

Forum|alt.badge.img+14
  • Inspiring
  • July 28, 2017

I am looking for this as well.

I suppose using a local filepath to the images wont work, since the csv file gets uploaded for an import while the images will just remain local.

Maybe this is possible to do through the API and using a url to the images which are somewhere in the cloud?

@RobTX did you already find a solution for this?


Forum|alt.badge.img+3

Would love to see this as well!

Ramon


  • New Participant
  • August 26, 2018

Has anyone been able to find a way to get this done? I’m needing it as well


  • New Participant
  • September 15, 2019

Has anyone been able to find a way to get this done? I’m needing it as well


I need a fix for this ASAP. Needed to migrate a table from one base to another, can’t find a way to reattach images except one-by-one (unacceptable).


Forum|alt.badge.img+20
  • Inspiring
  • September 15, 2019

I need a fix for this ASAP. Needed to migrate a table from one base to another, can’t find a way to reattach images except one-by-one (unacceptable).


Hi @remerkle

There are a few ways to do this.

One is by reading suggestions from this thread:

The other way is by using Integromat, for both images and table.

I just created this scenario, a week or so ago, to update records from one table to another, but it can be reworked for creating new records. Instead of using the Update a record module, you would use Create a record module and you would need to change the filter (just before the last module) to: Id Does Not Exist. Integromat has a free plan that gives you 1,000 operations.

I also have a scenario that you could attach photos from either Google Sheets or GDrive. Let me know if this might be helpful.

Here is the post link. The scenario is post #21:

Hope these suggestions help.

Mary K


Forum|alt.badge.img+15
  • Inspiring
  • March 24, 2020

I am looking for this as well.

I suppose using a local filepath to the images wont work, since the csv file gets uploaded for an import while the images will just remain local.

Maybe this is possible to do through the API and using a url to the images which are somewhere in the cloud?

@RobTX did you already find a solution for this?


We built a tool that converts file URLs to attachments: