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

    How to append data to existing submissions?

    Asked by sjck on July 20, 2016 at 02:29 AM

    I have more than 140+ offline submissions that I wish to append into JotForm inbox. Is there a way to do that and at the same time merge or amend duplicate IDs?

    Page URL:

  • Profile Image
    JotForm Support

    Answered by ashwin_d on July 20, 2016 at 06:06 AM

    Hello sjck,

    If I understand your question correctly, you want to import existing offline data in your form's submission page. Is that correct?

    Yes is it possible to achieve your requirement by taking advantage of our "Import Data" app. This app will allow you to import data in form's submission page if your offline submission data is in excel or csv file.

    You may also like to take a look at the following guide which should help you:  https://www.jotform.com/help/308-Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm 

    Hope this helps.

    Do try it out and get back to us if you have any trouble.

    Thank you!

  • Profile Image

    Answered by sjck on July 20, 2016 at 10:25 PM

    will it overwrite existing submissions? will there be duplicate submissions? I don't seem to be able to specify the unique ID to upload, i'm afraid that it will mess up all the data.

  • Profile Image
    JotForm Support

    Answered by Welvin on July 20, 2016 at 11:30 PM

    The app won't overwrite existing submissions as far as I know and yes, possible duplicates will be created as well. 

    You may also consider duplicating your current form and import the offline data into the duplicate so the original will stay as it is

  • Profile Image

    Answered by sjck on July 22, 2016 at 12:14 AM

    Hi ashwin_d I'm still not able to append the unique ID which are all assigned to the offline data using your method. I do see a {unassigned} column but seems like a redundant field.

    After I tried appending a sample line of data, the system created 9 blank entries and my entry date was reset to -0001-11-30 00:00:00 which is totally weird.

    Seems like there's a bug with the plugin.

  • Profile Image
    JotForm Support

    Answered by Welvin on July 22, 2016 at 01:39 AM

    Would it be possible for you to  send us the file that you are importing? We need to test the import tool again using the actual file if possible. That would help us gather more info before submitting a bug ticket to our developers. 

  • Profile Image
    JotForm Support

    Answered by Welvin on July 22, 2016 at 01:41 AM

    I'm sorry, please send the file to support@jotform.com