Not to be confused with Import Submissions.
Jotform makes it easier than ever for you to import data and manage your data in Tables. You could either import your data into a new table or to an existing table.
Notes
- The Reply and Edit Entry options are disabled for imported data.
- To update the imported data, double-click a cell to perform inline edit.
Importing Data into a New Table
Here’s how you can import your data into a new Table:
- Go to My Tables and click Create Tables.
Note: You can also access My Tables using the quick access menu in My Forms.
- Next, select Import Data.
- Afterward, upload your file then click Import Data.
- Change the column types if needed then click Complete to start the import process.
You can now manage your imported data in Jotform Tables.
Importing Data into an Existing Table
To import your data into an existing table:
- Click Add Tab in Jotform Tables.
- Choose Table then click Next.
You can also choose any of the other tab styles.
- Afterward, select Import from file then click Next.
- Upload your file then click Next.
- Change the column types if needed then click Create to start the import process.
A new tab will appear and you can now view and manage your imported data in the new tab.
Send Comment:
9 Comments:
how do you import into an existing table, not a new tab
I have a list of products and their suppliers, and I want create a form to send to each supplier, listing only their products. I was wondering if that's possible.
for clarification, I import 4 products, where item's 1 and 2 are supplied by supplier A, and 3 and 4 are supplier B. then the form I send to supplier A will only show items 1 and 2, and not 3 and 4, and vice versa for supplier B.
I have a lot of suppliers with different amount of products
I would prefer not to have to create 2 separate forms for the 2 suppliers.
Is it possible to merge imported data with an existing table - i.e. not have the imported data on a separate tab? We are using jotform for new membership applications and already have some entries - but want to add all the pre-jotform members to the same table. thank you
How many records (rows) can I import into a Table Form?
I uploaded an excel file with money figures, short text, and formulas from within excel for calculating percentages etc. When I uploaded, no data shows up in the table. The tab I uploaded into is "Tims Rates" and is in this table <a target='_blank' href="https://www.jotform.com/tables/211815820622045/211876286204054" >https://www.jotform.com/tables/211815820622045/211876286204054</a> Help...
How do you limit import of data from Excel to only include rows with data? I imported an Excel sheet with 66 rows populated and got 990 entries in my table. Made sorting an issue.
How do you get a date to import correctly? It imports as the julien date (ie. 44297), verses a usable date (4/29/2021)
can you save or back up a table?
Can you add the data to tables and integrate it with a form? If headers match fields in Form will it auto populate?