Export collection with pictures?

[exile911]

Hi guys,

I was wondering if we could make an export including pictures of at least the front box?
I know about the csv export which is a great feature. It would be nice if the pictures of the games could be exported too.

Keep up the good work and keep on gaming & collecting!

[segabias]

I can get you half the way there using excel formulas.

You can concatenate the URL for the image.

The value in column A "VGC id" from the csv export, is a unique identifier, used in the URL.

Formula:                      =CONCATENATE("https://vgcollect.com/images/front-box-art/",A2,".jpg")
Displayed Cell Value:     https://vgcollect.com/images/front-box-art/89249.jpg

Taking this one step further it can be wrapped in the with the hyperlink function to make a clickable link that will open in your web browser.

Formula:                      =HYPERLINK(CONCATENATE("https://vgcollect.com/images/front-box-art/",A2,".jpg"),"Front Box Art")
Displayed Cell Value:     Front Box Art

Apparently you'd need to write some VBA code to actually pull the image into a excel spreadsheet.

[exile911]

Tnx for this.
Will try this out later.