How to Create Multiple Duplicate Sheets in Google Sheets

Creating one sheet copy is easy.

Creating 20, 50, or 100 copies with different names? That’s where things get messy.

Let’s walk through the simplest way to duplicate sheets in bulk — especially when you want each copy to have a different name.

✅ The Easy Way: Use a Google Sheets Add-on

If you frequently create multiple duplicate sheets, there’s a much faster way than manually copying them one by one.

There’s a Google Sheets add-on called Create Template Copies Easily that allows you to generate multiple sheet copies at once using a list of names inside your spreadsheet.

Instead of repeating:

• Right-click sheet
• Click “Duplicate”
• Rename
• Repeat again and again

You can do everything in just a few steps.

Step 1: Install the Add-on

You can install it from the Google Workspace Marketplace here.

Search for Create Template Copies Easily and install it.

Once installed, reload your spreadsheet.

Step 2: Prepare a List of Sheet Names

Create a column containing the names you want your new sheets to have:

Client A
Client B
Client C
Client D

Each row will become a new sheet name.

Step 3: Select the Names

Highlight the list of names you want to use.

Step 4: Create Template Copies

Go to:

Extensions → Create Template Copies Easily → Create Template Sheet Copies

A modal will open with a dropdown showing all sheets in your spreadsheet.

Select the sheet you want to use as the template.

Click proceed.

What It Does

• Creates a duplicate of the selected template sheet
• Renames each copy using your selected list
• Preserves formatting, formulas, layouts, and structure
• Creates all copies in seconds

Why This Is Easier

• ✅ No repetitive manual duplication
• ✅ No scripting required
• ✅ Works directly from a name list
• ✅ Ideal for monthly reports, client dashboards, batch projects

🧩 Create Multiple Duplicate Sheets Using Apps Script

If you want to automate sheet duplication directly inside Google Sheets, you can use Apps Script.

This method allows you to:

• Select a list of new sheet names
• Choose one sheet as the template
• Automatically create multiple copies
• Rename each copy based on your list

Step 1: Open Apps Script

1. Open your Google Sheet
2. Click Extensions → Apps Script
3. Delete any existing code
4. Paste the script below
5. Click Save
6. Run onOpen() once
7. Authorize permissions
8. Refresh the spreadsheet

You’ll now see a new menu called Template Tools.

Full Script (With Menu)

function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu("Template Tools")
    .addItem("Create Template Sheet Copies", "createTemplateCopies")
    .addToUi()
}

function createTemplateCopies() {
  let ss = SpreadsheetApp.getActiveSpreadsheet()
  let sheet = ss.getActiveSheet()
  let range = sheet.getActiveRange()
  let values = range.getValues()

  if (!range) {
    SpreadsheetApp.getUi().alert("Please select a list of sheet names first.")
    return
  }

  let templateName = SpreadsheetApp.getUi().prompt(
    "Enter the name of the sheet you want to duplicate:"
  )

  if (templateName.getSelectedButton() !== SpreadsheetApp.getUi().Button.OK) return

  let templateSheet = ss.getSheetByName(templateName.getResponseText())

  if (!templateSheet) {
    SpreadsheetApp.getUi().alert("Template sheet not found.")
    return
  }

  for (let i = 0; i < values.length; i++) {
    let newName = values[i][0]

    if (newName && !ss.getSheetByName(newName)) {
      let newSheet = templateSheet.copyTo(ss)
      newSheet.setName(newName)
    }
  }

  SpreadsheetApp.getUi().alert("Sheets created successfully.")
}

How It Works

1. Select a column containing the new sheet names
2. Click Template Tools → Create Template Sheet Copies
3. Enter the name of the sheet you want to duplicate
4. The script creates copies and renames them automatically

Things to Keep in Mind

• You must authorize the script
• It needs to be added to each spreadsheet separately
• If a sheet name already exists, it will be skipped
• Prompts and alerts are basic UI elements

Apps Script gives you full flexibility — but it requires setup and some technical comfort.

🚀Need Something More Advanced?

If you’re looking to automate your workflow in Google Sheets, connect multiple services, sync data between platforms, or pull data from external tools directly into Sheets — I can help.

I specialize in building custom Google Apps Script solutions that save time and eliminate repetitive work.

• 5+ years of experience
• 50+ clients helped
• Automation, integrations, dashboards, data syncing

If you have a custom requirement or want to streamline your workflow, feel free to reach out.

📩 Contact me: upgradewithai@gmail.com