How to Export SharePoint 2013 list images to Excel as Image?

Question

I made a list in SharePoint 2013 which contains a picture/hyper link column. The Users need to export the excels but when they do they do not have pictures any more but they have links. I looked after the way to not replace the photos manually because it is about 100 items! I saw one coding through internet but I didn't know how does it works. I had an assets library as my images source so I tried to export the assets library maybe it works! but it didn't and I had links. I decided to ask you professional guys to tell me your experience regarding export images to excels. Regrds

Answer 1

The image store in a list, but Hyperlink or Picture column doesn’t store the image objects itself, so you are not able to export it to a excel document easily.

Here are some posts for your reference:

http://social.technet.microsoft.com/Forums/en-US/95527bfd-c6c0-4b26-8767-f3fba6da2013/how-to-embed-or-unlink-image-while-exporting-sharepoint-list-data-to-ms-word-20072010

http://cybertext.wordpress.com/2008/03/18/word-2003-unlinking-linked-images/

http://social.msdn.microsoft.com/Forums/en-US/88e1b117-9ff2-4868-b490-4700d9cd6cc6/embed-images-in-word-document

Below are two similar posts:

http://social.technet.microsoft.com/Forums/en-US/aed120f7-0f48-4b39-8063-416ed3858e35/how-to-export-sharepoint-list-data-with-images-to-powerpoint

http://social.technet.microsoft.com/Forums/en-US/11007c12-ab4b-407d-bc1f-9a90699f3a18/image-conversions-from-sharepoint-to-excel

I hope this helps.

Thanks, Gowtham