Import/Export/Archive

  • Profile Image
    Seasons55
    Asked on July 30, 2021 at 01:36 PM

    Now that I have my forms setup with your help, and the old data imported,

    I want to clean it up. I saw that I can archive records, but cannot tell where they go

    nor if I could retreive them if needed. I also see how to delete records, but I want to know if I could "import" those same records back into the database if I trim too much and someone wants the old data reloaded, is that possible, and if so, how?

  • Profile Image
    VincentJay
    Answered on July 30, 2021 at 08:43 PM

    You can archive the submissions and you can find them on the submission page. Here's a screenshot how to open the Archives page:

    1627692060_61049c1c9382b_vad3235ss.png

    You can also check these guides on how to delete and download the submissions data:

    https://www.jotform.com/help/377-how-to-delete-form-submission-data

    https://www.jotform.com/help/73-how-to-download-form-submissions-as-excel-csv-pdf

    We recommend downloading the data before deleting it because we cannot restore deleted submissions.

  • Profile Image
    Seasons55
    Answered on July 30, 2021 at 11:03 PM

    Ok, what about part 2, I see you cannot restore deleted records, but is there a way to take a downloaded dataset and import or upload them, i.e. from an Excel file that was previously downloaded from Jotforms?

  • Profile Image
    Mike_G
    Answered on July 31, 2021 at 07:19 AM

    You can restore deleted form submission data that were deleted not more than 30 days ago or not completely deleted yet.

    Reference Guide: How-to-restore-deleted-submissions-in-JotForm-Tables

    However, if you want to import form submissions from an Excel or CSV file to your existing form, you can follow the instructions in this guide — Import-App-Easily-import-your-Excel-or-CSV-data-into-JotForm

    Feel free to let us know if you need any further assistance.