What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.

  • Profile Image

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

    Asked by carolinaruggerfest on March 03, 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.

  • Profile Image
    JotForm Support

    Answered by Mike_G on March 03, 2017 at 01: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).

    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.

    As for the result:

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

    Thank you.