How to Move a Sheet to Another File in Google Sheets

When copying a sheet within the file, you can use the "Duplicate" command. When copying a sheet to a new file or an existing file, you need the "Copy to" command, which is the same as "Move and Copy" from Microsoft Excel.

Step 1: Open the workbook and right-click the tab name;

Step 2: Click the "Copy to" from the dialog box;

Step 3: Select "New spreadsheet" if you want the sheet as a single file, otherwise to select "Existing spreadsheet";

Step 4: You will get a message when the new file is ready;

Step 5: Please note that the newly created document has the name of "Untitled spreadsheet", please change the name by following how to name or rename a Google spreadsheet.


  1. Christina January 31, 2022
    • Joe Smithson March 20, 2022

Leave a Reply