Duplicate Table?

[Mark_Daniel]

Is there an easy way to duplicate a table structure, with or without the data, inside one project?

A couple of times I’ve added a new table and thought it has a lot of similar fields to an existing one and it would be quick to just duplicate but I can’t find a way to do it.

Thanks,
Mark

[natalie-grist]

Hi Mark,

Making a new, separate copy of a table’s data is definitely something we plan on adding.

When you have multiple sets of data with the same structure, we recommend keeping it all in a single table and creating a field that differentiates each subset of data. Read more at the forum post linked below:

How do I duplicate a page without it being tied to the original page?

Hello @senojgnip, and welcome to the forum! When you have multiple sets of data with the same structure, my advice is to keep all data in a single table, separated by some field, and to use widget linking to allow selecting and working with the different subsets. This is the approach typically used in databases. For instance, let’s say you are an interior decorator, and for each client you’d like a table of furniture items you’ve picked out for them. Rather than placing them into separate tabl…

There may be a few cases where this is not the best option. You can export a table as CSV then re-import it into your document as a new table. This will duplicate the structure of your data. You will need to add any formulas and set up column types after importing. If you have any choice / choice list columns, you can copy the choice items from the original table then paste them into the column configuration panel on the new table. This makes setup much easier, especially if you have color-coded your choices as it will copy the formatting as well.

Thanks,
Natalie