Is there a way to export form results to a excel spreadsheet?

  • Profile Image
    SimeBuilding
    Asked on June 04, 2018 at 12:05 AM

    Hi,

    I am wondering if there is a way of automatically exporting form results to an excel spreadsheet in either a Sharepoint location or One Drive location? (Like what happens with the Google Drive / Google Spreadsheets 3rd party integration?)

    Thanks,

    Danielle  

  • Profile Image
    eugene
    Answered on June 04, 2018 at 03:41 AM

    Unfortunately, we don't have a direct integration of SharePoint and OneDrive. 

    But there are few things you can do.

    1) By using Zapier, you can connect your form to excel. That way your submissions data will automatically update the excel file you choose. You just need to have your Excel files on a Microsoft OneDrive for Business account. I kindly suggest you to check the blog post below.

    Connect Your Forms to Excel with Zapier

    2) While you can't integrate your submission data directly to the SharePoint server. You can use MS SQL Server Export to export your data as SQL file. Then you can import it in your Database.

    Hope it helps! Feel free to contact us again if you have any further questions.