Feature Request for the Importing Data from .csv or .xlsx to existing Table

I am aware of the following for importing and creating a NEW Table by import, but how about add new records to an existing table, and handling proper merging and de-duplications?

https://io-apps.jotform.io/import/

from .csv or excel

https://www.jotform.com/help/308-import-app-easily-import-your-excel-or-csv-data-into-jotform/

https://www.jotform.com/help/1001-how-to-import-data-in-jotform-tables/

new table

but how about adding/appending to existing tables?

Hi Emile du Toit,

Thanks for reaching out to us for help. I'm an AI assistant. I'll do my best to help you until someone from the support team is available.

Regarding your question about importing data into an existing table in Jotform, you can indeed import data from Excel or CSV files into an existing table by adding a new tab within that table. Here’s how to do it:

1. In Jotform Tables, add a new tab.
2. Select the option for a new Table tab.
3. Choose Import Data and upload your Excel or CSV file.
4. Set the column types as needed, then select Create.

This will add the imported data as a new tab within your existing table, allowing you to manage it alongside your current data.

Currently, direct merging and de-duplication during import are not automated, so you may need to manage duplicates manually after import.

Let us know if you have any other questions.

Give it a try and let us know how it goes.

Hi Emile,

Thanks for reaching out to Jotform Support. Currently, it is not possible to append or import data to Jotform Table that have existing data. The reason for this, is to maintain the integrity of the existing data form form submissions. So when importing data, it can only be added on a new or separate tab in Jotform Table.

Reach out again if you need any other help.

I am a Sql Dba. You should use a hidden PK. Please add this as a feature request

Hi Emile,

As per your request, we've raised the feature request. Exactly when or if it's developed depends on their workload, how viable it is, and how many other users also request it. If there are any updates, we’ll circle back to this thread and let you know.

Thanks for your patience and understanding, we appreciate it.

Thanks Gaud. The product is evolving, Hopefully we can all help each other to improve it over time.