How can I export excel with multiple sheets?

  • Aceskhobar
    Asked on September 7, 2019 at 5:11 AM
  • jonathan
    Replied on September 7, 2019 at 8: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.


  • Aceskhobar
    Replied on September 8, 2019 at 1: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.

  • Victoria_K
    Replied on September 8, 2019 at 5: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.