Is it possible to convert the form from Excel and have the submissions populate the Excel sheet?

  • Profile Image
    chris 
    Asked on August 29, 2017 at 11:38 AM

    I need to a) import an existing excel sheet b) convert to form c) email form link to list of people d) have people fill in some "cells" e) download populated data to local excel worksheet. Need to know if this can be done using Jotform API with VB scripting in excel worksheet.

  • Profile Image
    Nik_C
    Answered on August 29, 2017 at 12:31 PM

    Unfortunately, there is no way to import excel sheet and create a form of it. The only way is to create a form from scratch and mimic the fields from the sheet. 

    You can share the form link easily by following this guide: https://www.jotform.com/help/303-How-to-Send-a-Form-via-Email

    You can easily integrate the existing form with Spreadsheet by following this guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

    Then, every time the form is submitted the data will go to that sheet.

    Could that work for you?