How to Copy a Sheet from One Google Sheets to Another

I am a fan of creating to-do lists and trackers. And Google Sheets is my weapon of choice.

Since I have created a lot of these lists and trackers, I  decided to merge all my trackers into one single Google Sheets document and then use this master tracker instead.

And to do this, I had to copy sheets from multiple Google Sheets into one single Google Sheets document.

While it’s not complicated, it took me a few minutes to figure it out.

So I thought I will share it with you all (in case you want to get this done yourself).

Copy a Sheet from One Google Sheets to Another

Below are the steps to create a copy of a sheet in another Google Sheets document:

  1. Open the Google Sheets document from which you want to copy the sheet. So these would be different trackers (lists) that I want to combine.
  2. Right-click on the sheet that you want to move to another master tracker Google Sheets document.
  3. Click on ‘Copy to..’ option.Right Click to copy and move google sheet
  4. In the dialog box that opens, you need to select the Google Sheets in which you want the sheet to be copied. This Google Sheets document could be in your own Google Drive or the one that is shared with you (with edit rights).Dialog box to copy google sheets to another
  5. Once the Google Sheets in which you want to copy the sheets is selected, click on Select.

You will see a prompt that will tell you that the sheet has been copied. You can also open the target Google Sheets document, which now has the copied sheet.

Note that when the sheet is copied, it still remains in the source worksheet. A copy of the sheet is created in the target document.

In case you have the link to the Google Sheets in which you want to copy the sheet, you can simply enter the link at the bottom of the dialog box (step 4 above), and then click Select.

You May Also Like the Following Tutorials:


10 Google Sheets Tips that will save you hours every week

Bar Sparkline in Google Sheets - rtl
Google Sheets

Sparkline in Google Sheets – The Only Guide You Need

Sparklines are miniature charts that you can create within a cell. These are quite useful when you’re creating a dashboard and want to quickly show a trend, seasonal increase or decrease, or outliers (maximum/minimum) visually. According

Google Sheets

How to Insert Timestamp in Google Sheets

Google Sheets is a great tool when you’re collaborating and working with people on the same sheet. It allows people to work in the sheet simultaneously. In this tutorial, you’ll learn various to insert timestamp in Google

Google Sheets Keyboard Shortcuts - Spreadsheets
Google Sheets

101 Google Sheets Keyboard Shortcuts

Google Sheets is a relatively new spreadsheet tool in the market. It has quickly gained a lot of fan following and I see a lot of people migrating from other spreadsheets applications to Google Sheets.