Google Sheets: How to Duplicate a Workbook and Share It

To duplicate an entire Google Sheets workbook in a web browser, open it and choose File > Make a copy. Enter a name and choose where to save the new spreadsheet; Google Sheets creates a separate file, leaving the original in place. To copy just one tab, use the tab’s menu and choose Duplicate.

What “duplicate a workbook” means in Google Sheets

Google Sheets calls a spreadsheet file a spreadsheet, though people often use “workbook” to mean the whole file. A spreadsheet can contain several sheets, shown as tabs along its bottom edge. The distinction matters: File > Make a copy duplicates the spreadsheet file and its tabs, while duplicating a tab adds another sheet inside the same file.

A full-file copy is useful when you need a new version for a different month, client, class, project, or team. It keeps the original available as a reference and gives you a separate file to edit. Duplicating a tab is better when you want another copy of a template or worksheet but want it to stay alongside the other tabs in the existing spreadsheet.

Neither action is the same as downloading a spreadsheet as an Excel file. A copy made in Sheets remains a Google Sheets file in Google Drive. Downloading creates a file in another format, such as Microsoft Excel, and may affect features that depend on Google Sheets.

How to make a copy of the entire spreadsheet

Use the browser version of Google Sheets and follow these steps:

Open the spreadsheet you want to copy.
Select File > Make a copy.
In the dialog, enter a descriptive name for the copy.
Choose a destination folder in Google Drive if you do not want to use the suggested location.
Review any sharing or copying options shown in the dialog, then select Make a copy.

The new spreadsheet opens separately. Check its name near the top of the page and its location in Drive before you begin editing. If you have access only to view the original, Google may limit your ability to copy it; the owner or administrator can also restrict copying, downloading, or printing for viewers and commenters. If the copy option is unavailable, ask the owner whether they can make a copy or adjust access.

To find the copy later, use Google Drive search or open the destination folder you selected. It is worth renaming files clearly, for example “Q3 Budget — Working Copy” rather than “Copy of Budget,” especially when several people manage similar versions.

What a spreadsheet copy includes

A normal copy is intended to reproduce the spreadsheet’s contents and structure, including its tabs, cell values, formulas, formatting, and much of its layout. Charts, notes, data validation, and conditional formatting are generally part of the spreadsheet contents too. The copied file is a new Drive item with its own name and file location, rather than a second view of the original.

Do not assume that every relationship around the original file becomes an independent relationship in the copy. A formula that refers to another tab in the same spreadsheet will generally continue to refer to the corresponding tab in the copied spreadsheet. But a formula or feature that draws on a separate spreadsheet, website, form, add-on, or service may still depend on that original source or require authorization. For example, a copied sheet using IMPORTRANGE can still refer to the source spreadsheet identified in the formula; making a copy does not automatically create a new source file or change that connection.

A copy also should not be treated as a complete record of the original’s past. The new file has its own future edit history; do not rely on it to preserve the original spreadsheet’s version history. If you need an audit trail, keep the original and use its version history or another approved recordkeeping process.

How to duplicate just one sheet tab

If the goal is another worksheet inside the same spreadsheet, locate the tab at the bottom of the page. Open its drop-down menu, or right-click the tab, and select Duplicate. Google Sheets adds a copy of that sheet to the same spreadsheet, usually with a name such as “Copy of…” followed by the original tab name. Rename the new tab by opening its menu and choosing Rename, or by double-clicking the tab name.

This is handy for recurring layouts. A teacher might duplicate a grade-entry tab for a new class, or a project manager might copy a task sheet for the next phase. Before entering new information, inspect formulas and references. A formula that refers to another tab may still point to the original tab, depending on how it was written, so confirm that totals and lookups use the intended data.

Duplicating a tab does not create a separate Drive file or provide a separate set of file-level sharing permissions. Anyone who can edit the spreadsheet can generally work with its tabs according to their access. Use File > Make a copy if the new version needs a different audience or must be managed independently.

Choosing between a full copy and a tab copy

Choose based on what needs to be separate. A full copy gives you a distinct file that can be placed in another Drive folder and shared independently. A duplicate tab stays in the same file and is visible to people who already have access to that spreadsheet.

Make a full copy for a new reporting period, a client-specific version, an editable backup, or a draft that should not change the source file.
Duplicate a tab for a new month or group when the worksheet belongs in the same shared spreadsheet.
Use neither as your only backup if you need a formal retention or recovery plan. Follow your organization’s Drive policies and keep an appropriately controlled source.

Consider links and collaborators as well as the sheet contents. If a team needs to work on the new version without seeing the original, make a file copy and check its access. If everyone should see both worksheets in one place, a tab copy is often simpler. Before distributing either version, remove sample records, confidential data, or notes that the next audience should not receive.

Sharing, ownership, and privacy

Creating a copy does not automatically mean that the original and copy have identical access in every situation. The copy dialog may offer an option to share the new file with the same people, but the options shown can depend on your account, organization, permissions, and where you save it. Read the dialog rather than assuming that previous collaborators have or have not been added.

After copying, use the Share button in the new spreadsheet to inspect who has access. Confirm that the intended people have the right role, such as viewer, commenter, or editor, and that the general-access setting is appropriate. If you are copying into a shared drive, access may also be affected by that drive’s membership and policies. A file’s location can matter as much as its individual sharing settings.

Keep sensitive information in mind. A copied file may contain hidden or less obvious material such as additional tabs, comments, or data that is not visible in the current view. Review the whole spreadsheet before sharing it externally. If you do not have permission to share the original’s information, making a copy does not grant that permission.

Common problems and checks after copying

A copy can look complete while depending on something outside itself. Check formulas that import data, links to other files, connected forms, add-ons, and any workflow that sends or receives information. A copied spreadsheet may not duplicate the external service, its permissions, or its configuration. If a formula displays an error after copying, check whether the referenced source still exists and whether the account viewing the copy is authorized to access it.

Also verify the file and tab names. Formulas that use a tab name can be affected if you rename or remove that tab, while links shared with colleagues may still point to the original file. Send the new URL when you intend people to use the copy. For a monthly template, a practical routine is to make the file copy, update the reporting period, confirm source connections, remove old entries where appropriate, and test key totals before sharing.

If you cannot make a copy, check whether you are signed into the Google account that has access, whether the owner permits copying, and whether your organization applies restrictions. If the menu is present but the action fails, confirm that you can save to the selected Drive location and try another permitted folder. For managed work or school accounts, an administrator may control these settings.

Google Sheets copies versus Excel copies

In Google Sheets, File > Make a copy creates a Google Sheets file in Drive. In Excel for Microsoft 365, the comparable goal is commonly handled with File > Save As or by copying a file in its storage location; the exact options depend on whether the file is saved on a computer, OneDrive, or SharePoint. Excel and Sheets also differ in features, formulas, and collaboration behavior, so a file converted between them may not behave identically.

If you specifically need an Excel-format file from Sheets, use File > Download and choose a Microsoft Excel format when available. That is an export, not simply a Google Sheets duplicate. Check the downloaded file for compatibility if it uses Sheets-specific functions, linked data, or automation. Keep the Google Sheets original if you still need its live collaboration or Google-specific features.

Frequently Asked Questions

Does making a copy change the original Google Sheet?
No. Making a copy creates a separate file, so edits to the copy do not normally change the original. However, external connections such as imported data can still refer to the original or another source.

How do I copy a Google Sheet without sharing it with the same people?
Choose File > Make a copy and review the sharing options in the dialog. If an option to share with the same people appears, leave it unchecked if appropriate, then inspect the new file’s Share settings before distributing it. Organization policies may affect what you can change.

Can I duplicate a Google Sheets file on my phone?
Google Sheets and Drive mobile apps can offer file-management options, but the exact menus can differ by device and app version. For the clearest full-copy workflow and to review all dialog options, open the spreadsheet in a desktop web browser and use File > Make a copy.

Will a copied spreadsheet keep its formulas and formatting?
Its formulas and formatting are generally copied with the spreadsheet. Still, check formulas that refer to other tabs or external files, since a copy does not necessarily duplicate those external sources or update every connection for a new workflow.

Can I duplicate only one tab into another spreadsheet?
Yes. Open the tab menu and choose Copy to, then select a destination spreadsheet if it is available to you. You can also duplicate the tab in its current file and move or copy it as needed. Check formulas and formatting in the destination afterward.

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.