Getting errors when exporting data from an excel file using the import tool

  • carolinaruggerfest
    Asked on March 3, 2017 at 12:20 PM

    This didn't work for me. Cloned the form, downloaded the data from the original form, tried to import it into the new cloned form and I got errors. How is this possible. The cloned form should have the identical column headers as the original. The data should go seamlessly from one to the other.

    See picture below.

    Getting errors when exporting data from an excel file using the import tool Image 1 Screenshot 20

  • Mike_G JotForm Support
    Replied on March 3, 2017 at 1:05 PM

    The errors in the screenshot you provided means that the fields are not set to match as indicated in Steps 5 to 8 of this guide: Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

    For example, since the import tool gave me column headers as seen in the image below according to the fields of my Form 2 (receiver of the data).

    Getting errors when exporting data from an excel file using the import tool Image 1 Screenshot 40

    I should copy the column headers to the excel file that contains the data that I need to import to Form 2 then save it before performing the import.

    Getting errors when exporting data from an excel file using the import tool Image 2 Screenshot 51

    As for the result:

    Getting errors when exporting data from an excel file using the import tool Image 3 Screenshot 62

    I hope this helps. If you have any further questions regarding this, please feel free to contact us again anytime.

    Thank you.