How can I export my submissions to Excel and keep the hyperlinks?

  • NCBFAdmin
    Asked on February 23, 2016 at 3:24 PM

    I have tried to export my submissions and within the submission there were places to upload four PDF files.  I did an Excel report, but the hyperlink for the PDF files are not there, just a file name.  Is there a way to keep the hyperlink intact?

     

    Thanks,

    Lori

  • Mike_G JotForm Support
    Replied on February 23, 2016 at 6:17 PM

    I have made a clone version of your form and made a test submission. I have uploaded PDF files to that form and submitted it. On the submission page, I downloaded an excel file of the submission. I verified that the data on the cell for the uploaded files are links in text and not clickable as a hyperlink, is that what you're getting also?

    How can I export my submissions to Excel and keep the hyperlinks? Image 1 Screenshot 30

    You can make that data a hyperlink by: 

    How can I export my submissions to Excel and keep the hyperlinks? Image 2 Screenshot 41

  • NCBFAdmin
    Replied on February 23, 2016 at 6:45 PM
    Yes, that is what I am getting.
    Lori
    ...
  • mert JotForm UI Developer
    Replied on February 24, 2016 at 4:15 AM

    As my colleague has already shown, you can make those data a hyperlink by using your current XLSX editor.

     

    On Google Sheets,

    How can I export my submissions to Excel and keep the hyperlinks? Image 1 Screenshot 20

     

    If you need any further help, please do let us know.

    Thanks.