When importing data from excel, existing submissions are note replaced.

  • lakeviewrock
    Asked on July 28, 2019 at 4:57 PM

    I followed the instructions to import a new excel file to the form https://form.jotform.com/91156480867163. The new Excel is not replacing the old Excel data.

    Please help

    craig@lakeviewrock.com

  • Ashwin JotForm Support
    Replied on July 28, 2019 at 10:10 PM

    I am not sure if I have understood your question correctly. Do you mean to say that when you import data from excel file in form, the previous submission data is still there in form?

    Please note that when you import data in form, it only imports the new data but will not delete or replace the existing submission data. I would suggest you to manually delete the previous submission data. The following guide should help you how to delete submission data: https://www.jotform.com/help/377-How-to-Delete-Form-Submission-Data 

    Hope this helps.

    Do get back to us if you have any questions.

  • lakeviewrock
    Replied on July 28, 2019 at 11:43 PM
    The new data has 163 lines in Excel. The existing data has 153 lines in Excel. As per you information I understand the existing data of 153 lines should remain and the additional 10 lines to equal 163 lines should be in place. This is not happening?
    ...
  • BJoanna
    Replied on July 29, 2019 at 4:36 AM

    If you form has 153 submission and your Excel file has 163 lines when you import the data the form will have 316 submissions, even if some data already exists on the submissions page. If you want to import only 10 submissions that are missing, you should create a new Excel file with only those 10 submissions and import it. 

    If the data in your Excel file with 163 lines is different than the data on submissions page and you do not need old submissions, you should first delete the old submission and then import the new 163 submissions.