Import App: Easily Import Your Excel or CSV Data into Jotform

April 30, 2022

Note
Imported entries via the Import App count as real submissions.
Be mindful of the fact that your account submission count would get impacted, which may result in reaching your account monthly and total Submission limit.

Importing your data in Excel or CSV format to your Jotform it’s never been so easy. Here is how:

  1. Go to https://import.jotform.io/.
  2. Click the Import Submissions Now button.
import-submission-data-button-min.png
  1. Authorize the app to access your forms by clicking the Allow button.
import-submission-data-allow-button-min.png
  1. Select the form you want to import the data to then click Continue.
jotform-apps-form-picker-min.png
  1. Apply the template format from the import tool to your Excel or CSV file.
import-submission-data-format-min.png

For more information, check out the “CSV and XLS Template Format” section of this guide. Once the source file is ready…

  1. Click the Select Source File button and select the XLS or CSV file that you want to import.
  2. Finally, click the Import button.
import-submission-select-source-file-min.png

Wait for the import to finish and if all goes well, you should see the Results at the bottom of the page.

import-submission-results-min.png

The imported entries should now appear in your Jotform Tables.

CSV and XLS Template Format

The template produced by the import tool will tell you what the Excel or CSV file’s format should be so that the imported data is handled properly for you.

We suggest reading all of them carefully before going to the actual import. This is to ensure that all data goes to the right place. It’s quite easy, all you have to do is change your Excel or CSV file’s headings and lines to match the template’s format.

For example, here’s the data in the original Excel file.

excel-csv-sample-data-min.png

Take a look at the format we get from the import tool:

import-submission-data-sample-format-min.png
The top line of your Excel or CSV file should be identical and the remaining lines should match the format.

For the import to work, we have to edit the original Excel file and apply the template from the import tool:

excel-csv-sample-import-ready-data-min.png

Note that form elements with multiple fields like Full Name and Address are different, we must combine the data into one column even if your data is stored in multiple columns.

If you’re having difficulties, our support is online 24/7 and they’ll be happy to assist you.

Was this guide helpful?
Contact Support:

Our customer support team is available 24/7 and our average response time is between one to two hours.
Our team can be contacted via:

Support Forum: https://www.jotform.com/answers/

Contact Jotform Support: https://www.jotform.com/contact/

Send Comment:

Jotform Avatar
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Comments:

  • JotUser
  • Laurie Murphy
  • QA MQC Top Glove
  • Deysi Andrade
  • ell jibril
  • Adam Kuda
  • Andrey Shark
  • Andrey Shark
  • CCassum