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

Last Update: 

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

Importing your data in Excel or CSV format to your Jotform has never been easier. Here’s how:

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

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

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

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

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

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

import-submission-data-sample-format-min
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

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:

  • Craig Watkins - Profile picture
  • JotUser - Profile picture
  • Laurie Murphy - Profile picture
  • QA MQC Top Glove - Profile picture
  • Deysi Andrade - Profile picture
  • ell jibril - Profile picture
  • Adam Kuda - Profile picture
  • Andrey Shark - Profile picture
  • Andrey Shark - Profile picture
  • CCassum - Profile picture