D
D
Dima2020-09-03 16:49:43
Google Sheets
Dima, 2020-09-03 16:49:43

How to move all sheets from one Google spreadsheet to another?

There are 2 table files, each with 10 sheets, how quickly from one table file, transfer all 10 sheets to another?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
G
Grigory Boev, 2020-09-03
@qpz

1) Use IMPORTRANGE (table_key; range)
2) Right-click on the sheet label: Copy to... > Existing table
3) Write a script: iterates over all sheets, copies the sheet to a new table.

const id="тут_id_таблицы-приёмника";
  let destination = SpreadsheetApp.openById(id)
  let ss = SpreadsheetApp.getActiveSpreadsheet();
  let sheets = ss.getSheets();
  for (var sheet in sheets){
    sheets[sheet].copyTo(destination)
  };

M
Maks331, 2020-09-03
@Maks331

And how to transfer only one sheet from a table with 10 sheets to another table that will contain only one sheet?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question