Export Images to Excel

HELLO, IM USING A FORM WITH IMAGES CAPTURED BY USER. THEN I EXPORT TO EXCEL AND GOT THIS LINK IN CELLS.

IM TRYNG TO SHOW IMAGES IN EXCEL IN ANOTHER CELL BUT I CANT DO IT. IM USING THE IMAGE FORMULA BUT THE LINK DOEST SEEMS TO WORK.

THEN I OPEN THE IMAGE LINK AND REDIRECT ME TO THIS OTHER LINK WHERE THE IMAGE IS HOSTED.

I MADE A TRY USING THIS LINK WITH THE IMAGE FORMULA IN EXCEL AND SEEMS TO WORK. SO HOW CAN I GET DIRECTLY THIS LINK TO BE USED IN EXCEL.

OR THERE IS ANOTHER WAY TO SHOW IMAGES IN EXCEL VIA JOTFORM FORMS.

Hi RPA,

Thanks for reaching out to Jotform Support. Unfortunately, the uploaded image files cannot be immediately imported into the Excel sheet and will instead display as a downloadable link when the form submissions are exported as Excel. 

A possible workaround is to use Excel's IMAGE function. The IMAGE function inserts images into cells from a source location, along with alternative text. All you need to do is type the following into a cell:

=IMAGE(source, [alt_text], [sizing], [height], [width])

Add the IMAGE function to the other column in your Excel file. Then, utilize the Jotform link as the source location for the IMAGE function. Let me show you how:

1. In your downloaded Excel file, use the IMAGE function from Excel to show images in the cell.
2. Specify the source location by selecting the download links as cell references.

Let us know if there’s anything else we can help you with.