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:
- Go to https://import.jotform.io/.
- Click the Import Submissions Now button.
- Authorize the app to access your forms by clicking the Allow button.
- Select the form you want to import the data to then click Continue.
- Apply the template format from the import tool to your Excel or CSV file.
For more information, check out the “CSV and XLS Template Format” section of this guide. Once your source file is ready:
- Click Select Source File and select the XLS or CSV file that you want to import.
- Finally, click the Import button.
Wait for the import to finish and if all goes well, you should see the Results at the bottom of the page.
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.
Take a look at the format we get from the import tool:
For the import to work, we have to edit the original Excel file and apply the template from the import tool:
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.
Send Comment:
10 Comments:
This is sooooo close to what I need for my team on both coasts! Is there ANY way to embed the "import" button into Excel? I have 14-15 operators who each have to submit a report at the end of their shift - and it's primarily all numbers. When they (manually) input the numbers into the Jotform, "fat fingers" sometimes prevail and 2,500 units can become 2,500,000 units, etc. If I could embed this type of process, no more bad numbers! Yes, if the form stopped at Jotform, it's an easy fix - but within a few minutes, the form is pulled (indirectly) into Zoho, for which I have no access to make corrections - I have to wait until "that person" is available. Pretty please!!!!!
for enterprise users, a critical piece of info is missing from the above... the link to use!
To use the Import App for your Enterprise server, please open it from the following URL:
Is it possible to import from an Excel file into a Configurable List Widget?
Why is it not working even after the results with the information of submission of number of fields per submission are displayed?
Hi! If I'm importing submissions from another form, will the submission IDs also get imported? Or will they have new IDs in the new form?
what will happen if am importing data that has a picture how will I make the picture visible on my form
Is this process secure for HIPAA compliant purposes?
Hey,
http : // import . jotform . io / does not have an SSL certificate that secures the connection.
My browser warns me about not entering any senstive data on this site such as passwords, emails etc.
Could you make this site have a secure HTTP connection please?
Hey,
site does not have an SSL certificate that secures the connection.
My browser warns me about not entering any senstive data on this site such as passwords, emails etc.
Could you make this site have a secure HTTP connection please?
Can you incrementally import rows from Excel into a table? I will be getting more rows of data in my Excel file over time, but want to add them in batches to the table. How do you add incrementally?