How to move a spreadsheet to an other GoogleSheet

I’ve a
GoogleSheetA with 3 spreadsheets inside (Table1, Table2 and Table3)
and other
GoogleSheetB with 1 spreadsheet inside (Table4)

I want to move the spreadsheet(Table3) that is in a GoogleSheetA to GoogleSheetB

the spreadsheet description is the same (column name, column order …)
this is what I need to have:

GoogleSheetA with 3 spreadsheets inside (Table1, Table2)
and other
GoogleSheetB with 2 spreadsheets inside (Table4, Table3)

I copy past Table3 from GoogleSheetA to GoogleSheetB

what is the good way to do that, I don’t want to lose all the attribute I’ve set in my Table3. ?

more information:
if I delete the Table3 in my App I will lose all the attribute

if I add the new spreadsheet GoogleSheetB.Table3 in my App, I will have give a new name to the table for not having duplicate name in my App?

The process is actually pretty simple:

  1. In GoogleSheetA, for Table3, select Copy to, then Existing spreadsheet, then choose GoogleSheetB. This will add a copy of Table3 to GoogleSheetB.

    image

  2. In GoogleSheetB, confirm that the copy of Table3 arrived and is how you want it. You may want to rename it.

  3. In the app editor, in Data >> Tables, update the configuration for Table3 to use the new copy of the Table3 worksheet. Change Source Path to GoogleSheetB and Worksheet Name/Qualifier to the name of the new copy of Table3. Then Save & Verify Data.

  4. Confirm your app is using the new worksheet by making some data changes from the app and observing that the new worksheet is receiving those changes rather than the old worksheet.

  5. If you want, you may delete the old Table3 worksheet from GoogleSheetA.

Note that there is no need to make any other changes to your app configuration. You won’t lose any column configurations.

2 Likes

top,super, thanks
so i don’t need to make regenerate table.