Google Sheets: Duplicate a Sheet Multiple Times

Yes. In Google Sheets, right-click a sheet tab and choose Duplicate to make one copy; repeat the command to create more. Sheets has no built-in command for entering a number and making that many copies at once, but you can use a short Apps Script for a larger batch.

What duplicating a sheet does

A sheet is an individual tab inside a spreadsheet file. Duplicating it creates another tab in that same file, generally carrying over the source sheet’s contents and layout. This is useful when a workbook has one standard format that needs to be reused—for example, one tab per month, class, project, location, or team member.

Duplicating a sheet is different from copying cells. A cell copy transfers a selected range, while a duplicated tab gives you a separate worksheet-like space with its own grid and tab. It is also different from making a copy of the entire spreadsheet file: the duplicate stays in the existing file and uses the same file-level sharing and storage.

There is no “make five copies” dialog in the standard Google Sheets interface. If you only need a few, repeating Duplicate is straightforward. For many copies, automation can save time, but you should check the resulting tabs before relying on them.

Duplicate a tab manually

In Google Sheets in a web browser, use either of these methods:

Find the sheet tab along the bottom of the spreadsheet.
Right-click the tab, or click its small drop-down arrow if shown.
Select Duplicate.
Wait for the new tab to appear, then rename it if needed.

The duplicate usually gets a name such as “Copy of Template.” To rename it, double-click the tab name, type the new name, and press Enter. You can also open the tab’s menu and choose Rename. To make additional copies, select the original template tab and repeat the duplication steps. The exact menu placement can vary slightly with interface updates, but the command is in the sheet tab’s menu.

For example, if you need tabs for April, May, and June, duplicate a tab named “Monthly Template” three times, then rename the resulting tabs. Starting from the same original each time helps keep all three based on the intended template rather than on a copy that may already have been edited.

Make many copies with Apps Script

If you need a larger batch, a bound Apps Script can duplicate the currently selected sheet several times and give each new tab a distinct name. In the spreadsheet, open Extensions > Apps Script, add this function in the editor, save the project, and run it. Change the value of count to the number of copies you want.

function duplicateActiveSheetMultipleTimes() {
  const count = 5; // Change this to the number of copies.
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const source = ss.getActiveSheet();
  const baseName = source.getName() + " copy ";

  for (let i = 1; i <= count; i++) {
    let name = baseName + i;
    let suffix = 2;
    while (ss.getSheetByName(name)) {
      name = baseName + i + " (" + suffix + ")";
      suffix++;
    }
    source.copyTo(ss).setName(name);
  }
}

On the first run, Google may ask you to authorize the script to access the spreadsheet. Review the requested permissions and proceed only if you trust the script and are comfortable granting them. The function copies whichever tab is active when it runs, so select the intended template before clicking Run. If a generated name is too long or otherwise invalid, shorten the source tab name and try again.

This sample creates five copies named along the lines of “Template copy 1” through “Template copy 5.” It checks whether a proposed name is already in use and adds a suffix if necessary. That prevents a naming collision from stopping the batch just because an earlier run left tabs with the same names.

Choose the right method for your task

For two or three copies, the tab menu is usually the quickest option and avoids setting up automation. Use Apps Script when the same task recurs or when creating each tab manually would be tedious. A script is especially helpful for a repeatable monthly process, but it is not necessary just to make a small number of tabs.

One or a few copies: Duplicate the tab manually, then rename each copy.
A recurring batch: Use a saved Apps Script and adjust its copy count or naming logic as needed.
A separate file is required: Use the tab menu’s Copy to option rather than Duplicate.
Only part of a sheet is needed: Copy the relevant cells instead of duplicating the whole tab.

Be clear about whether you want extra tabs or extra spreadsheet files. If you duplicate a tab and then share the spreadsheet, the copies remain inside the same file. If you need each copy to be a standalone file with its own file name or sharing settings, tab duplication alone will not do that.

Rename and organize the copies

Useful names make a spreadsheet easier to navigate and reduce the chance of editing the wrong tab. Choose a consistent pattern, such as “2026-04,” “2026-05,” and “2026-06,” or “North,” “South,” and “West.” A date-first pattern sorts naturally by time when the tab names are reviewed alphabetically, while descriptive names can be clearer for teams or locations.

After renaming, drag tabs along the bottom of the spreadsheet to put them in a useful order. You can also set a tab color from its menu to distinguish working tabs from archived ones, if that helps your workflow. Avoid names that are nearly identical when several people will be editing the file; meaningful labels are easier to spot than a long sequence of “Copy of…” tabs.

Before distributing the spreadsheet, consider keeping one clearly labeled, untouched template tab. You can hide it from casual view using the tab menu’s Hide sheet command, but hiding a sheet is not a security measure: editors may be able to unhide it, and it does not replace controlling access to the spreadsheet file.

What to check after copying

A copied tab can look right at a glance while still needing review. Check the details that matter to the way your spreadsheet works, particularly if it contains formulas, charts, protected ranges, or connected data.

Formulas and references: Inspect important formulas and confirm they point to the intended cells and tabs. A formula that intentionally refers to a central “Rates” or “Setup” tab may need to keep doing so in every copy.
Input areas: Check data validation, dropdowns, and any instructions that tell users what to enter.
Formatting: Review column widths, number formats, conditional formatting, frozen rows or columns, and print settings if they matter.
Charts and other objects: Confirm that charts, images, and drawings appear as intended and use the expected data.
Protections and sharing: Review protected sheets or ranges and file access before giving the spreadsheet to other people. Do not assume that a duplicate has exactly the access behavior you want.

One common misconception is that duplicating a tab creates an independent spreadsheet. It does not: the new tab lives in the same file, so file-level collaborators can still have access to that file. Another frequent mistake is editing the template itself before making all the copies. If each tab should begin from the same clean baseline, duplicate the unchanged template first and make tab-specific edits afterward.

Copy a sheet to a different spreadsheet

If the goal is to move a tab into another Google Sheets file, use the tab menu and choose Copy to, then select New spreadsheet or Existing spreadsheet. The labels may be presented in a submenu. For an existing spreadsheet, choose the destination from the available files and confirm the copy. You may need access to that destination file.

This action copies a sheet to another spreadsheet; it is not the same as creating several duplicates in the original file. It can be useful when a template needs to be distributed to separate project files or when a tab should be moved into a different working document. Afterward, open the destination and check formulas, links, and references: a formula that depends on another tab in the original file may not have the same context in the destination.

Common problems and fixes

If Duplicate is missing, first make sure you have opened the file in Google Sheets and are using the sheet tab’s menu—not a cell’s right-click menu. You may also have limited permissions. A viewer or commenter may not be allowed to change the file; ask the owner for editor access or for a copy that you can modify.

If a script stops with an error, check that the intended tab was active, that you authorized the script, and that the requested tab names are valid and available. If a previous run created some copies before an error, inspect the tabs before running it again. The sample checks for existing names, but a very long source name can still cause a name-length issue. Reduce the source name or adjust the script’s naming scheme.

If a duplicate appears but formulas show unexpected values, do not assume the duplication failed. Look at the formula bar and determine whether the formula references the copied tab, another tab, or an external spreadsheet. Correct the reference or update the template, then make future copies from the corrected version. For a critical workbook, test the process on a disposable copy of the file before changing the working spreadsheet.

Frequently Asked Questions

Can Google Sheets duplicate a tab several times in one click?
No. The standard Duplicate command makes one copy at a time. Repeat it for a small number of tabs, or use Apps Script when you need a larger batch.

Does duplicating a sheet copy the whole spreadsheet?
No. It makes another tab inside the same spreadsheet file. Use File > Make a copy when you want another spreadsheet file, or use the tab menu’s Copy to command to copy a tab to a different file.

Can I duplicate a sheet in Google Sheets on a phone?
The steps and available controls can differ in the Google Sheets mobile app. The instructions here are for Sheets in a web browser. For a batch script, use the browser-based Apps Script editor and run the function there.

Will duplicated tabs update when I change the original?
No. A duplicate is a separate tab, not a live synchronized copy. Later edits to the original do not automatically rewrite the duplicate, although formulas in either tab may still refer to shared cells or other tabs.

Can I duplicate a tab into a different spreadsheet?
Yes. Open the tab menu, select Copy to, and choose a new or existing spreadsheet. Check formulas and links in the destination because they may depend on other tabs in the source file.

Is a hidden template tab private?
No. Hiding a tab only removes it from the normal tab display. It does not protect sensitive information from people who can access the spreadsheet; manage access to the file and protect data appropriately.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.