Skip to main content
Solved

Bulk import images into an existing table

  • April 13, 2020
  • 3 replies
  • 326 views

Forum|alt.badge.img+2

I have an existing table with 800+ records (imported from a CSV). Now, I’d like to add an image for each record (import from a folder of PNGs–with matching file names). Is there a way to do this in bulk?

Example Records:
Name, Type1, Type2, Image
Abomasnow, Grass, Ice, [to add: abomasnow.png]
Aerodactyl, Rock, Flying, [to add: aerodactyl.png]
Aggron, Steel, Rock, [to add: aggron.png]
etc.

Best answer by Donnie_Wang

Figured out a workaround. This assumes you have one file/image for every Record AND filenames that match a Name field:

  1. Create an empty table
  2. Change to Gallery View
  3. Batch drag the files you want to upload to the “+” icon in the bottom-right corner (this was the key step I kept missing)
  4. You’ll be asked whether to “Create X records” or “Create one record (with X attachments)”. Choose the first one.
  5. Sort records by Name, then copy the column they’re in
  6. In the original table, sort by Name and create a new Attachments column
  7. Paste the image attachments into the new column

3 replies

Forum|alt.badge.img+2
  • Author
  • New Participant
  • 1 reply
  • Answer
  • April 14, 2020

Figured out a workaround. This assumes you have one file/image for every Record AND filenames that match a Name field:

  1. Create an empty table
  2. Change to Gallery View
  3. Batch drag the files you want to upload to the “+” icon in the bottom-right corner (this was the key step I kept missing)
  4. You’ll be asked whether to “Create X records” or “Create one record (with X attachments)”. Choose the first one.
  5. Sort records by Name, then copy the column they’re in
  6. In the original table, sort by Name and create a new Attachments column
  7. Paste the image attachments into the new column

Forum|alt.badge.img+4
  • New Participant
  • 4 replies
  • January 2, 2023

Figured out a workaround. This assumes you have one file/image for every Record AND filenames that match a Name field:

  1. Create an empty table
  2. Change to Gallery View
  3. Batch drag the files you want to upload to the “+” icon in the bottom-right corner (this was the key step I kept missing)
  4. You’ll be asked whether to “Create X records” or “Create one record (with X attachments)”. Choose the first one.
  5. Sort records by Name, then copy the column they’re in
  6. In the original table, sort by Name and create a new Attachments column
  7. Paste the image attachments into the new column

Dear Donny,

I used to use this feature a lot before, but I see that it is not possible anymore. Have you found a way to import series of images again?

Thanks


Jen_Brett
Forum|alt.badge.img+3
  • New Participant
  • 2 replies
  • April 16, 2025

Not sure if this solves the issue but just discovered you can copy + paste into the fully highlighted attachment column and it will distribute the images into the individual records.