Is there a way to import submission info from a csv or xls to the report/data/submission area in Jotform?

  • Profile Image
    Asked on August 28, 2019 at 05:21 PM

    I have some submissions that were created from a different form and would love to combine them with the Jotform submissions in the Jotform platform. Currently it seems to allow me to add data but I would have to cut and paste every single column manually.

    I also tried the "Import Data" app/integration but after multiple attempts, it is clear that it is no longer functioning.

    Any recommendations?

  • Profile Image
    Answered on August 28, 2019 at 06:09 PM

    We apologize for any inconvenience caused. 

    The Import Data app can be a bit tricky to use. So its a given that it might not work properly on first attempt.

    The source data file (CSV, Excel) must have a fixed format that will match the field mapping on the target form.

    You may review the user guide also : Easily Import Your Excel or CSV Data into Jotform

    I just checked using the Import App on a very basic form, and so far I was able to make it work and import CSV data into the form.

    An alternative option you may want to check also is using the Spreadsheet to Form widget.

    Guide : How to Use the Spreadsheet to Form Widget

    I hope this help. Let us know if you need further assistance.