Convert Native Table to a Google Sheet
Last updated
Last updated
There is an option Convert to a Google Sheet available in More Actions of your native tables.
This action is not reversible. Once your table converts to a Google Sheet, you cannot convert it back to a native table.
You might wonder what happens to the existing table references in your building blocks if you convert your table to a Google Sheet. The good news is that the table references can stay unchanged since the table id does not change on converting the table to a Google Sheet. You only need to ensure that the column names are the same. Case-sensitivity does not matter: If the column is named "column one" in your native table and "COLUMN One" in your Google Sheet, this will not break any references in the building blocks. If some of the column names that building blocks refer to are not the same, simply rename the column names either in your Google Sheet or in your native table before converting. Otherwise those columns that are not present in your Google Sheet will be removed and all the references to them in your building blocks will be automatically removed, too.
Beware that all rows in your native table will be permanently deleted once your table is converted to a Google Sheet. You can secure your data by using the export option (Export Data as CSV) before converting.