How do I import multiple images into single individual cells?

Question

Level 1

0 points

How do I import multiple images into single individual cells?

Hi folks,

I'm new to the Mac (yeah!) and imagine there just has to be a way to import a bunch of images into separate cells in Mac "Numbers" ... am I right?

Essentially what I'd like to do is a file folder with 600 images in it, and import those directly into Mac Numbers with one picture being assigned to it's own cell. So if below were a spreadsheet it would look like this:

Actual Picture - Picture Name - Item Description ... and so on.

I'm trying to work with inventory items, and this is the only way I can think of doing it. Suggestions!?!?

Here is a link to creating a macro in Excel to do a similar thing:

http://en.kioskea.net/forum/affich-269046-adding-a-loop-to-macro-to-insert-pictu res

Thanks for your help.
D

MacBookPro, Mac OS X (10.6.2)

Posted on Mar 3, 2010 6:13 AM

Reply

Answer 1

Mar 3, 2010 6:20 AM in response to dockane

D,

I guess you're taking another shot at getting a response. You risk getting parallel discussions going with the same content.

What you are contemplating seems logical enough, but I think you will find that it is impractical in Numbers. Given the size of photograph files these days, you will choke Numbers in short order. You will have to be careful that you embed only photos large enough to be of use/viewable, and keep your full-sized copies elsewhere. You might find that an Apple Script can do the import for you, but otherwise it's drag and drop from the Media Browser.

Jerry

Reply

Answer 2

dockane Author

Level 1

0 points

Mar 3, 2010 6:50 AM in response to Jerrold Green1

Hi Jerrold,

I realized I had posted it in '08 as well, so I thought it might be better to list it here in case more folks were checking the more "recent" forum. I looked for a way to close out the question, but didn't see it ... should I just mark it as "answered?"

Weird that this seems so hard, you're right it shouldn't be. I would imagine there would be something that could automatically create thumbnails of images, and then import them ... does that sound like a familiar option?

Cheers,
D

Reply

Answer 3

Mar 3, 2010 7:17 AM in response to dockane

D,

Have you explored using iPhoto and using key words to describe your inventory?

Jerry

Reply

Answer 4

dockane Author

Level 1

0 points

Mar 3, 2010 7:32 AM in response to Jerrold Green1

Hi Jerry,

I've used iPhoto to reduce the sizes of images in batches, but what I need to do is populate a spreadsheet either in Excel or Numbers, with the descriptions, etc. so I can then upload them to the ecommerce side of my business. So the pictures won't rest in iPhoto, they need to be uploaded to allow me to use them in another format. Make sense? 😉

Cheers,
D

Reply

Answer 5

Mar 3, 2010 7:40 AM in response to dockane

I don't know enough specifics about your format requirements to make a suggestion.

Jerry

Reply

Answer 6

dockane Author

Level 1

0 points

Mar 3, 2010 7:43 AM in response to Jerrold Green1

Okay, thanks for your help Jerry. If it simplifies things at all, I'm just needing to have a spreadsheet that for each row has a title, a description and a picture at the end. That's it really ... pretty simple stuff. One other way to look at it is to ask: "How do I import 100 pictures into Numbers so each picture is in it's own row?" Everything else I can copy and paste in there. The real "buster" is the image import.

Reply

Answer 7

Mar 3, 2010 7:49 AM in response to dockane

You have your thumbnails/small versions that you created in iPhoto. One-by-one, drag them out of the Media Browser to their respective cell locations in Numbers. You should be able to do three or four per minute, at least. Then you're done with that part. Figuring out how to automate that for a few hundred items is probably not cost-effective.

Jerry

Reply

Answer 8

dockane Author

Level 1

0 points

Mar 3, 2010 7:51 AM in response to Jerrold Green1

Thanks again, Jerry. Looks like there might be a solution in Bento. Much appreciated. Cheers, D

Reply