Google Sheets Duplicate File: How to Make a Copy

To duplicate a Google Sheets file in a web browser, open the spreadsheet and choose File > Make a copy, then name the copy and choose where to save it. Google Sheets creates a separate file in Google Drive, leaving the original unchanged; you can also duplicate just one sheet tab if you do not need a copy of the whole spreadsheet.

What a Duplicate File Actually Does

A Google Sheets file is the complete spreadsheet document, which can contain multiple sheet tabs, formulas, formatting, charts, and other spreadsheet features. Making a copy creates another Drive file based on that document. The copy can be renamed, edited, moved, or shared independently of the original, subject to your account’s access and organizational settings.

For example, if a team has a monthly budget workbook, a copy can serve as the starting point for next month. The original remains available as a reference, while the new file can receive new figures. This is different from duplicating a tab, which adds a second worksheet inside the same file rather than creating a separate Drive item.

A copy is useful when you want a reusable template, a safe working version, or a separate document for another person or project. It is not the same as downloading a spreadsheet: a downloaded Excel file is a separate local or exported file, while a Google Sheets copy remains in Drive and can be edited in the browser.

Make a Copy from an Open Spreadsheet

Use the browser version of Google Sheets for these steps. You need permission to view the original, and the owner or organization may restrict copying in some situations.

Open the spreadsheet you want to duplicate.
Choose File > Make a copy.
In the dialog, enter a name for the new spreadsheet. A descriptive name such as Project Plan – Q3 Working Copy is easier to identify than a generic copy name.
Choose the destination folder in Google Drive. If you do not select another folder, the copy is generally saved in the suggested location, often the same folder as the original.
Review any available options, such as copying comments or sharing the file with the same people. The options shown can depend on the file and account.
Click Make a copy. Sheets opens the new document so you can check it and begin working.

Before clicking, check the destination and name carefully. If the copy is meant for a different audience, avoid leaving it in a folder that grants access to people who should not see it. Drive folder permissions can affect who can access files stored there.

Copy a Spreadsheet from Google Drive

You do not have to open a file first. In Google Drive, locate the spreadsheet, right-click it, and choose Make a copy. Depending on the Drive layout, you may also be able to select the file and use the available More actions menu. Drive creates a separate spreadsheet copy; rename it and move it to the appropriate folder if needed.

This route is handy when you are organizing several files or want to make a copy before opening the original. It can also help avoid editing the source by mistake. If Make a copy is missing or unavailable, check whether you have adequate access and whether the file owner or a Google Workspace administrator has disabled copying for viewers or commenters. The exact controls can differ between personal Google accounts and work or school accounts.

Duplicate One Sheet Tab Instead

If you want another worksheet inside the same spreadsheet, do not make a file copy. At the bottom of the spreadsheet, right-click the sheet tab and choose Duplicate. You can also use the small arrow on a tab to open its menu and select Duplicate. Sheets creates a new tab in that same file, usually with a name indicating it is a copy. Rename the tab to make its purpose clear.

Duplicating a tab is useful for creating a new month from a prior month, preserving a layout, or testing a change while keeping the original tab nearby. The new tab is not an independent document: it remains in the same spreadsheet, and anyone with access to the spreadsheet may be able to see it. Formulas on a duplicated tab may also refer to other tabs in that file, so inspect them if the copy is intended to stand alone.

Use a whole-file copy when you need an independent Drive file, a separate sharing boundary, or a complete backup-style working version. Use Duplicate on a tab when the task is simply to add another worksheet to the current document.

What Is Included in the Copy?

A spreadsheet copy normally carries over the workbook’s content and structure, including its sheet tabs, cell values, formulas, formatting, and charts. Features such as data validation, conditional formatting, and many spreadsheet settings are generally part of the copied document as well. Still, a copied file should be checked before it becomes the official working version, particularly if it relies on external information or special account-level access.

Comments and suggestions: The copy dialog may offer a choice to include them. Read the option carefully, especially when comments contain internal discussion or personal information.
Version history: The copy is a separate file with its own history going forward. Do not treat it as a complete duplicate of the original file’s past revision timeline.
Protected ranges: Protection settings may carry over, but access to change protections or edit restricted cells can depend on the new file’s ownership and permissions.
External data: Formulas or connected data that rely on another file or service may need access or authorization in the copy. For example, a formula using IMPORTRANGE can require the new spreadsheet to be granted access to the source spreadsheet.
Automation: A spreadsheet with an attached Apps Script or other automation deserves a separate review. A copied document is not a guarantee that every trigger, authorization, or external integration will behave exactly as it did in the original.

For a routine template, the copied cells and layout may be all you need. For a business-critical workbook, open the copy and test the important formulas, imports, protections, and automated processes before relying on it.

Sharing, Ownership, and Privacy

Making a copy does not mean that the original and copy become one shared document. They are separate Drive files, so changes to one do not normally update the other. The person creating the copy generally becomes its owner, though organizational rules and shared-drive arrangements can affect ownership. Sharing permissions should be checked rather than assumed to match the original.

The Make a copy dialog may provide an option to share the copy with the same people. If it appears, decide whether that is appropriate before confirming. Even when that option is selected, check the copy’s sharing settings afterward. The destination folder can also grant access to its members, and a work or school administrator may apply policies that limit external sharing or ownership.

Privacy matters when copying a spreadsheet that contains names, customer details, payroll information, or confidential project data. A new name does not remove sensitive content. Before sharing or moving the copy, review its data, comments, sharing list, and folder location. If a file is meant to be a clean template, remove example or private data rather than assuming the copy process will strip it out.

Common Problems and Practical Checks

If you cannot make a copy, first confirm that the original opens and that your account has permission to copy it. A viewer may be allowed to see a file but blocked from copying or downloading it. In a managed Google Workspace account, organizational settings can impose additional restrictions. Ask the owner or administrator for an allowed copy or the access level you need rather than trying to bypass the restriction.

If the new file is hard to find, look in the destination folder selected in the copy dialog and check Drive’s recent files. Search by the name you entered. A copy can be created successfully even if the original browser tab remains open, so verify the document title before editing or sharing.

After making a copy, use a short checklist:

Confirm the title and Drive folder are correct.
Check who can access the copy, including access inherited from its folder.
Look for formulas that refer to the original file, another tab, or an external data source.
Test important charts, dropdowns, protected cells, and imports.
Remove private sample data or comments if the copy will become a public-facing template.

A common misconception is that a copy is a live backup. It is a snapshot made at the time you copy it, not a continuously synchronized second file. If you later change the original, those edits do not automatically appear in the copy. For ongoing collaboration, share one file with the right people or use a deliberate process to transfer updates.

Google Sheets Copy Versus Excel Copy

In Google Sheets, the File > Make a copy command creates another Google Drive spreadsheet. In Microsoft Excel, making a copy may mean using Save As or creating a copy through OneDrive or SharePoint, depending on where the workbook is stored. The general idea is similar, but the menus, file formats, ownership model, and sharing controls are not identical.

A Google Sheets copy remains a Google Sheets document unless you export it to another format. To create an Excel-format file, use File > Download and choose Microsoft Excel (.xlsx). Downloading produces a separate file and may affect compatibility for features that do not translate perfectly between Sheets and Excel. If the goal is simply to work independently in Sheets, Make a copy is usually the more direct choice.

Frequently Asked Questions

Does duplicating a Google Sheets file change the original?
No. Make a copy creates a separate file, and ordinary edits to the copy do not change the original. The two files can contain similar content initially, but they do not stay synchronized automatically.

How do I copy a Google Sheet without changing the original?
Open the spreadsheet and choose File > Make a copy. Give the new file a distinct name and confirm the destination before creating it. Edit the newly opened copy, and check its title to ensure you are not still working in the source file.

Can I duplicate just one tab in Google Sheets?
Yes. Right-click the sheet tab and select Duplicate, or open the tab’s menu and choose Duplicate. This adds a tab to the same spreadsheet; it does not create a separate Drive file.

Will the copy have the same sharing permissions?
Not necessarily. The copy dialog may offer an option to share it with the same people, and folder access may also apply. Review the new file’s Share settings and the destination folder’s access before sharing sensitive information.

Why can’t I make a copy of a Google spreadsheet?
The owner may have restricted copying, or a work or school administrator may enforce a policy. Your access level can matter, too. Contact the owner or administrator to request permission or an approved copy.

Does a copied spreadsheet keep updating when the original changes?
No. A normal copy is independent, not a live mirror. If you need updated information from another spreadsheet, you may need a formula or a separate update process, and the new file may require access to the source.

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.