Share via

Importing pictures into Excel

Anonymous
2012-04-16T23:10:29+00:00

I need to create an inventory from photographs. I have a file of 200-odd resized images (all 6K) that I want to import into a column in a spreadsheet to then add names, descriptions, value etc.

How to do this that does not involve inserting one by one, sizing, adjusting properties to embed the image and so on?

Thanks

Trevor

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2012-04-17T02:43:04+00:00

    Excel all by itself doesn't support what you are trying to accomplish. Pictures in Excel are in layers above the grid. There's no way to make the part of the grid itself, so they are floating above the grid and can be positioned and resized to appear as if they are in the cells.

    If I were doing this I would use Excel as the data source for a Word Mail Merge that uses the INCLUDEPICTURE Word field. In Word, pictures are able to be included in the grid of a table. I would use a column in an Excel workbook to store the complete file path to each picture that is to be displayed.

    4 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-11-04T15:44:48+00:00

    In other words they can't be bothered with such nit-pic details as creating a Version for Mac platform. 

    I have found another application or extension that is supposed to work the same for Mac

    **http://excel-image-assistant.com/** supposed to work with 2011. License Fee seems reasonable.

    _____

    NOTE: *Neither I nor Microsoft has any vested interest, in this product. I, nor MS (so far as I know),*own no stock in the company that author's this utility. I purchased (may purchase) a copy for my own use. And find (may find) it helpful and for me, it has (will) not done (do) any harm. As with all software, including software from Microsoft, there is always the slight, possibility of buggy or harmful behavior, but has not done so for me (on items I own) .

    _________

    Disclaimer:

    The opinions / replies / answers given here, are solely mine, and mine alone. It does not necessarily reflect upon my position as a Community Moderator. Nor, does it reflect any possible position held by Microsoft or their employees, or any other users.

    0 comments
  2. Anonymous
    2015-11-04T15:08:17+00:00

    Every application is built for a specific purpose. It's a bit like expecting a screwdriver to have a radio installed in its handle.

    0 comments
  3. Jim G 134K Reputation points MVP Volunteer Moderator
    2013-09-07T14:17:51+00:00

    It's a shame the developer of Picture Manager for Excel did not program for cross-platform compatbility.  It's obvious that sales of the product will be lost due to this oversight.

    0 comments
  4. Anonymous
    2013-09-06T22:51:25+00:00

    Trevor,

    While I realize that you're using a Mac and your post is over a year old, but if you're still interested in such tool there is a newly released addin software available for Microsoft Excel on Windows platform called Picture Manager For Excel from Doality which does exactly what you want and then some.  Check out the quick video of this add-in in action at their website at Doality.com and you’ll see what I mean.

    It allows quick insertion of bulk pictures into cells of choice, sized to fit cell I may add, as well as easy removal of all/any images either from a single Excel worksheet or multiple Excel workbooks in less time than you can say “The quick brown fox jumps over the lazy dog.  1234567890”.

    All the best,

    Artemy

    0 comments