Not to be confused with Import Submissions.
Jotform Tables is a powerful tool you can use to organize, manage, and share data. You can use your data to perform complex calculations, track the progress of tasks, create visualizations, analyze your data, collaborate with your team, and organize workflows. Jotform makes it easier for you to import data and manage your data in Tables. You can either import your data into a new table or 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 an inline edit.
To import your data into a new Table
- Go to My Tables and select Create Tables in the upper-left corner.
![The Create Table button in My Tables](https://www.jotform.com/blog/wp-content/uploads/2023/11/my-tables-create-button-min.png)
![my-forms-quick-access-tables-min-png](https://www.jotform.com/blog/wp-content/uploads/2020/10/my-forms-quick-access-tables-min.png)
Note: You can also access My Tables from the app selector panel in My Forms.
- Select Import Data.
![The Import Data option in My Tables](https://www.jotform.com/blog/wp-content/uploads/2020/10/my-tables-import-data-option-min.png)
- Upload your Excel or CSV file.
![The Upload File button in My Tables](https://www.jotform.com/blog/wp-content/uploads/2023/11/my-tables-import-data-upload-file-button-min.png)
- Turn on Set the first row as column headers and change the column types if needed.
- Select Import Data when finished.
![Import data configurations in My Tables](https://www.jotform.com/blog/wp-content/uploads/2020/10/my-tables-import-data-config-min.png)
You can now manage your imported data in Jotform Tables.
![Sample Tables with imported data](https://www.jotform.com/blog/wp-content/uploads/2020/10/tables-imported-contacts-data-min.png)
To import your data into an existing table
- In Jotform Tables, add a new tab.
- Select Table.
![Steps to add a new Table tab in Jotform Tables](https://www.jotform.com/blog/wp-content/uploads/2023/11/tables-add-tab-next-min.png)
- Select Import Data, then upload your Excel or CSV file.
![How to Import Data in Jotform Tables Image-1](https://www.jotform.com/blog/wp-content/uploads/2023/11/tables-add-tab-import-data-min.png)
- Turn on Set the first row as column headers if applicable.
![How to Import Data in Jotform Tables Image-2](https://www.jotform.com/blog/wp-content/uploads/2023/11/tables-set-first-row-as-column-headers-min.png)
- Set your desired column types, then select Create.
![How to Import Data in Jotform Tables Image-3](https://www.jotform.com/blog/wp-content/uploads/2023/11/tables-import-colunm-types-create-min.png)
You can now view and manage your data in the new tab.
![The imported Contacts tab in Jotform Tables](https://www.jotform.com/blog/wp-content/uploads/2023/11/tables-imported-contact-data-sample-min.png)
Send Comment:
10 Comments:
143 days ago
The column type options when importing from an existing excel do not have all column types listed. For example email.... We cannot use the widgets or send forms with the accurate data because we cant import the column as an email field. only short text... long text etc... found in your demo. How do we fix this
More than a year ago
how do you import into an existing table, not a new tab
More than a year ago
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.
More than a year ago
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
More than a year ago
How many records (rows) can I import into a Table Form?
More than a year ago
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 https://www.jotform.com/tables/211815820622045/211876286204054 Help...
More than a year ago
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.
More than a year ago
How do you get a date to import correctly? It imports as the julien date (ie. 44297), verses a usable date (4/29/2021)
More than a year ago
can you save or back up a table?
More than a year ago
Can you add the data to tables and integrate it with a form? If headers match fields in Form will it auto populate?