NEWSheetSteps AI now turns entire websites into clean spreadsheet columnsExplore web scraping →

Google Sheets tutorials›Spreadsheet basics›Copy a sheet to another spreadsheet

Google Sheets · Verified tutorial

Copy a sheet to another spreadsheet in Google Sheets

Create a stable workbook-copy fixture by duplicating Source sheet and renaming the duplicate exactly "Workbook copy". Keep the original sheet.

Verified by JosephineJuly 25, 2026About 60 seconds

Quick answer

Create a stable workbook-copy fixture by duplicating Source sheet and renaming the duplicate exactly "Workbook copy". Keep the original sheet.

Step-by-step

1

Select the targetCreate a stable workbook-copy fixture by duplicating Source sheet and renaming the duplicate exactly "Workbook copy".

2

Apply the changeKeep the original sheet.

Shortcut or faster method

Use the menu path shown in the video and keep the target range selected until the change is applied.

Expected result

The source and a visible Workbook copy both exist, with the source records preserved.

Common mistake

Applying the change to more rows, columns, or cells than the task specifies.

Troubleshooting

Undo the last change, reselect the intended range, and try again. The source and a visible Workbook copy both exist, with the source records preserved.

Example spreadsheet data

This is the clean fixture used for the verified run.

Project	Owner	Budget
Website	Anna	1200
Launch	Ben	1800
Audit	Cara	900

Video transcript

Open the prepared Source sheet spreadsheet.
Select the target. Create a stable workbook-copy fixture by duplicating Source sheet and renaming the duplicate exactly "Workbook copy".
Apply the change. Keep the original sheet.
The source and a visible Workbook copy both exist, with the source records preserved.