Export Encrypted Data to Excel

  • canvastv
    Asked on August 31, 2015 at 9:31 AM
    Since Jotform doesn't have any Excel functionalities, how can you not make the decrypted data available outsite Jotform? Every other protected service I use does, so this is counterintuitive. And now I have the same problem other users reported: I urgently need my data ... in Excel.
  • Sammy
    Replied on August 31, 2015 at 11:56 AM

    When you access your submissions, you will be prompted to upload your private key for the data to be decrypted.

    After this the data will be view-able in plaintext which can then be exported to Excel/CSV.

    Kindly refer to this guide for more information

  • canvastv
    Replied on August 31, 2015 at 1:40 PM

    There is no export option, as far as I can see. 

  • Sammy
    Replied on August 31, 2015 at 2:14 PM

    To access the export option do the follwing

    1. Go to the My Forms page

    2. Select the form whose submissions you want to view then click on submissions

    Export Encrypted Data to Excel Image 1 Screenshot 30

    3. Scroll down to the datagrid at the bottom of page, on the top left you will see the options to export the data in Excel, CSV or PDF format

    Export Encrypted Data to Excel Image 2 Screenshot 41

     

  • canvastv
    Replied on September 1, 2015 at 6:53 AM

    That I know. But the issue is: my exported data are encrypted, and I don't see a way to export them in a useable way.

  • BJoanna
    Replied on September 1, 2015 at 11:15 AM

    Unfortunately as my colleague mentioned on this thread https://www.jotform.com/answers/633792  and like is mentioned in this guide What are Encrypted Forms and how to use them as expert, it is not possible to export encrypted data in Excel and CSV files from within Submission Panel. 

    On mentioned thread my colleague raised this issue to our developer, but we can can not give exact time when and if this feature will be implemented. 

     

  • ULHS
    Replied on March 4, 2016 at 9:23 AM

    Did this get sorted out? 

  • mert JotForm UI Developer
    Replied on March 4, 2016 at 10:32 AM

    Unfortunately, it has not sorted out yet. The ticket's status is still open on the other thread, so it is still waiting for solution. However, you can follow other thread to see the updates about this issue.

    If you need assistance for any other subjects, please always feel free to contact us.


    Thanks.

  • aussieadultstream
    Replied on June 27, 2017 at 1:24 AM

    Are there any updates?

  • John_Benson
    Replied on June 27, 2017 at 2:41 AM

    @aussieadultstream

    Unfortunately, there's no update.

    According to this guide, Excel or PDF download are all not available in Encrypted Form. You can only view the Encrypted Data using the Key on the Submissions page. 

    Hope that helps.