How can I export excel with multiple sheets?

  • Profile Image
    Aceskhobar
    Asked on September 07, 2019 at 05:11 AM
  • Profile Image
    jonathan
    Answered on September 07, 2019 at 08:49 AM

    Unfortunately this is not possible on the export data to Excel feature at this time.


    You can export the form submission data to Excel but it will not use multiple sheets. The data will only use one workbook with one sheet on it.

    Guide : How to Export Form Data to Excel

    But can you also provide us more details on what you need the option to export to excel using multiple sheets. Perhaps we can suggest a workaround that can work also. We just need to understand more what you need.

    We will wait for your updated response.


  • Profile Image
    Aceskhobar
    Answered on September 08, 2019 at 01:38 AM

    Thank you for your swift response. The excel file will be imported into a program which will only read the excel using multiple sheets with each having specific data. If I put all the information on one sheet, the program will not be able to import the data. Hope I answered your question.

  • Profile Image
    Victoria_K
    Answered on September 08, 2019 at 05:24 AM

    Hello,

    For what you have shared, I can suggest to try our google sheets integration: How-to-Integrate-Forms-with-Google-Sheets

    Please note that we do not recommend to modify integrated sheet since this may cause integration to fail. But, you can use IMPORTRANGE function to copy the data to multiple different sheets. This way you can download form data displayed on multiple sheets. 

    Hope this helps.