Show Posts
1
Site Feedback / Re: Export collection with pictures?
« on: February 14, 2021, 05:23:23 pm »
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.
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.