How to Duplicate a Google Sheet: Quick & Easy Guide

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. However, I did not know how to duplicate a Google Sheet.

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

So I thought I would share with you how to copy sheets in Google Sheets.

How to Duplicate a Sheet in Google Sheets

Here’s how to duplicate Google Sheets tabs:

Step 1: Right-click on the sheet you want to duplicate or click the down arrow on the sheet tab

Step 2: Select Duplicate from the menu.

Right-click on the sheet you want to duplicate or click the down arrow on the sheet tab then Select Duplicate from the menu.

The new Google Sheets duplicate will automatically show in the tray as “Copy of Sheet X” If you don’t need to copy your data into a completely new file, this is how to duplicate a Google spreadsheet most easily.

The new Google Sheets duplicate will automatically show in the tray as "Copy of Sheet X"

How to Duplicate a Google Sheet Into Another Google Sheet

Sometimes you might want to copy the data you have to a new or an existing spreadsheet. Instead of copying the rows you can also just copy the sheet. Below are the steps on how to copy a Google Sheet to another sheet:

Copy to a New Spreadsheet

  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.
Right Click to copy and move google sheet
  1. Click on ‘Copy to..’ option.
  2. You will get 2 options: Copy to New spreadsheet and Existing spreadsheet. Click New spreadsheet.
New Spreadsheet
  1. Choose copy to a New spreadsheet. You will get the prompt below to show the sheet copied successfully.
Successfully copied spreadsheet
  1. Click Open spreadsheet to view the new spreadsheet with the duplicated sheet.

Copy to an Existing Spreadsheet

  1. Right-click on the sheet that you want to move to another master tracker Google Sheets document.
Right Click to copy and move google sheet
  1. Click on ‘Copy to..’ option.
  2. You will get 2 options: Copy to New spreadsheet and Existing spreadsheet. Click Existing spreadsheet.
New Spreadsheet
  1. In the dialog box that opens, you need to select the Google Sheets where 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
  2. 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 now know how to copy a Google Sheet to a sheet, you can simply enter the link at the bottom of the dialog box (step 4 above), and then click Select.

How to Rename the Duplicated Sheet.

Once you have duplicated a sheet in Google Sheets it is automatically named Copy of “Original Sheet Name”. You can change the sheet name by:

  1. Left-click the duplicated Google Sheet tab
  2. Select Rename
  3. Type in the new name.
Rename the sheet
  1. Hit Enter

How to Move a Sheet

If you are working with multiple sheets, you might want to rearrange them for convenience. Moving a sheet is a very simple process:

  1. Right-click on the sheet tab you want to move and hold
  2. Drag it to where you want to move it
  3. Release the right mouse button to place the tab in the new position

Frequently Asked Questions

Can You Duplicate a Whole Google Sheet?

Yes, you can. In this article, we have shown you how to copy a spreadsheet in Google Sheets. All you need to do is right-click in the sheet tab for the sheet you want to duplicate and choose duplicate. This will create a new spreadsheet called Copy of “Original Sheet Name”.

How Do I Mass Duplicate a Sheet in Google Sheets?

There is currently no way to mass duplicate Google Sheets multiple sheets to a specific number all at once. An easy way to mass duplicate a sheet is by duplicating multiple existing copies of the sheet:

  1. Create your first duplicate using the method shown in the article above.
  2. Click the first sheet, hold down the CTRL key and click the second sheet. This is a cool trick to highlight Google Sheets multiple tabs simultaneously.
  3. Next right click on the second sheet and choose Duplicate. You will get two more copies instead of one.

Can I Duplicate a Sheet Multiple Times in Google Sheets?

You can duplicate a sheet in Google Sheets as many times as you want. However, you will have to do it one by one. We’ve already shown you how to copy a tab in Google Sheets. You can also duplicate multiple Google Sheet tabs by creating a copy and then duplicating the original sheet tab and the copy simultaneously.

Final Thoughts

Whichever method you use, this process is fairly straightforward, and you should now know how to duplicate a Google Sheet.

Google Sheets Duplicate works well to copy an entire sheet with one click. while Copy to is great to assign where you need the copy.

Now that you know how to copy a sheet in Google Sheets, check out some of our other articles, like how to transpose data or how to compare two columns in Google Sheets.

Related:

Spreadsheet Expert at Productivity Spot | + posts

Sumit is a Google Sheets and Microsoft Excel Expert. He provides spreadsheet training to corporates and has been awarded the prestigious Excel MVP award by Microsoft for his contributions in sharing his Excel knowledge and helping people.

Popular Posts
You May Also Like