Google Sheets Duplicate: Copy a File, Tab, or Data

Yes—Google Sheets can duplicate an entire spreadsheet, a single sheet tab, or a selected range of cells. Choose File > Make a copy for a separate file, use a tab’s menu and select Duplicate for another sheet in the same file, or copy and paste cells; repeated data can also be found or removed with Google Sheets’ cleanup tools.

What “duplicate” means in Google Sheets

The word “duplicate” can refer to several different tasks, and the right method depends on what you want to keep together. A duplicate spreadsheet is a new file in Google Drive. A duplicated sheet is a new tab inside the current spreadsheet. A duplicated range is another copy of selected cells, usually placed somewhere else in a sheet. Repeated data, by contrast, means that the same value or record appears more than once; you may want to identify or remove those repeats rather than copy them.

These actions have different effects on formulas, links, access, and the original information. For example, duplicating a tab does not create a separate Drive file, and removing duplicate rows is not the same as making a backup. If you are unsure, make a copy of the file first, then carry out the change in the copy.

Duplicate an entire spreadsheet

To create a separate Google Sheets file, open the spreadsheet in a web browser and choose File > Make a copy. Enter a name for the new file and, if desired, choose a different Drive folder. Review the options in the dialog, then select Make a copy. The new spreadsheet opens separately; the original remains in Drive and is not changed by edits to the copy.

This is useful when you want a fresh version of a template, a snapshot before making major edits, or a file to share with a different group. A whole-file copy normally includes its sheets and their contents, such as cell values, formulas, and formatting. Check the copy itself if a particular feature, link, or permission setting matters to your workflow.

For a reusable template: make a copy, give it a clear name such as “April inventory,” and enter new data in the copy.
Before a risky edit: make a dated copy so you can refer back to the earlier version.
For a separate project: use the copy as a starting point, then review its sharing settings before inviting collaborators.

If you cannot make a copy, you may have view-only access, or the file owner may have restricted copying for viewers or commenters. Ask the owner for permission or for an authorized copy. Do not assume that making a copy also gives everyone who could open the original access to the new file; check the sharing options shown during copying and the copy’s sharing settings afterward.

Duplicate one sheet tab

To duplicate only one tab, find its name along the bottom of the spreadsheet, open the tab’s menu (often by clicking its small arrow or by right-clicking the tab), and choose Duplicate. Google Sheets adds a copy as another tab in the same spreadsheet, commonly named “Copy of” followed by the original tab name. You can rename it by opening the tab menu and choosing Rename, or by double-clicking the tab name.

This is a practical way to make one worksheet for each month, class, location, or reporting period while keeping the tabs in one file. A duplicate sheet keeps its own cells, so changing a value in the new tab does not ordinarily change the corresponding value in the original. Formulas can still refer to other tabs, however. Inspect formulas that use sheet names, especially if the copied sheet is intended to become an independent model rather than a new period linked to the same source data.

The tab menu also offers ways to copy a sheet to another spreadsheet. Use the relevant Copy to option and choose an existing spreadsheet or create a new one when you need the tab elsewhere. That is different from duplicating the tab in place: the destination is a different file, and you should confirm the copied sheet appears in the intended spreadsheet.

Duplicate cells or a range

To copy cell contents within a sheet, select the cell or range, press Ctrl+C on Windows or Command+C on Mac, select the destination, and press Ctrl+V or Command+V. You can also use Edit > Copy and Edit > Paste. If the destination is in another open spreadsheet, copy the range, switch to the destination, and paste it there; browser clipboard behavior can vary, so use the menus if a keyboard shortcut does not work.

Ordinary pasting may bring across formulas, formatting, and other cell properties along with values. If you need only the displayed results, use Edit > Paste special > Values only where available, or the corresponding paste-special option in the context menu. This matters when a copied formula would otherwise continue to calculate from its original references. After pasting, check a few cells and the formula bar to confirm the result is what you intended.

For instance, copying a block of product names and prices can be useful for a new quote, but pasting formulas may leave the new block dependent on the original calculation cells. Values-only paste makes a static snapshot of the results instead. It will not update automatically if the source figures change, so choose between a live formula copy and a fixed snapshot based on the purpose of the destination.

Find repeated values before deleting anything

If you want to spot duplicates rather than make a copy, conditional formatting can highlight repeated values. Select the range, choose Format > Conditional formatting, and set the rule to Custom formula is. With names in A2:A20 and the rule applied to A2:A20, enter =COUNTIF($A$2:$A$20,A2)>1, then choose a formatting style. The rule returns TRUE for each cell whose value occurs more than once in the range. For example, if “Ana” appears in A4 and A11, both cells are highlighted.

This method is helpful for reviewing a list because it does not delete or alter the underlying entries. It is also important to define what counts as a duplicate. Two identical email addresses may be duplicates even if other columns differ, while two orders with the same customer name may be separate legitimate records. If a row should count as a duplicate only when several fields match, inspect the full records or create a careful comparison rule that includes those fields.

Remove duplicate rows safely

Google Sheets has a built-in cleanup command: select the data range and choose Data > Data cleanup > Remove duplicates. In the dialog, indicate whether the range has a header row and choose which columns should be checked. Review those choices before confirming. If you select several columns, Sheets uses the selected columns together to decide whether rows repeat; if you select only one, rows can be treated as duplicates based on that column even when other columns differ.

The command removes repeated rows from the selected data, so first make a copy of the spreadsheet or range if you may need to restore the original. It is best to select the full table when you want to remove entire repeated records, rather than selecting only one column and risking the removal of rows based on an incomplete definition of a match. After cleanup, check the remaining row count and sample the data to make sure distinct records were not removed.

Removal is not always the right choice. If repeated entries represent separate transactions, attendance records, or events, deleting them would lose real information. In that case, use highlighting or a helper column to review them, or add a unique identifier such as an order number so that genuinely repeated records can be distinguished from valid entries with similar names.

Choose the right method

Need a new file that can be edited independently? Use File > Make a copy.
Need another worksheet in the same file? Open the tab menu and choose Duplicate.
Need to repeat only some cells? Copy and paste the range, then check whether formulas or formatting should come along.
Need to find repeated entries? Apply conditional formatting or review the records first.
Need to delete repeated records? Use Data > Data cleanup > Remove duplicates only after confirming which columns define a match and keeping a recoverable copy.

This distinction also prevents a common mistake: using “duplicate” to mean both “make a backup” and “clean up repeated data.” A backup preserves the current contents in another file or tab. Cleanup changes the dataset. If both are needed, make the backup first and clean the working copy second.

Sharing, formulas, and common issues

A copied file has its own identity in Google Drive, so treat its access as something to review rather than assume. The copy dialog may offer a setting to share it with the same people; the available options can depend on the file and your access. After copying, use the Share button to check who can view or edit the new file, especially if it contains personal, business, or confidential data. A copied file is not automatically a safe way to remove sensitive information: inspect hidden tabs, comments, and any data you do not intend to distribute.

Another frequent surprise is formulas that change when copied. Relative references can shift to match the new position, while absolute references marked with dollar signs stay fixed. A duplicated tab can also contain formulas that refer to other sheets in the same spreadsheet. If a result changes unexpectedly, select the cell and inspect the formula, then confirm that the referenced cells and sheet names are appropriate in the copy.

If Duplicate or Make a copy is missing, check whether you have sufficient permission and whether the owner has limited copying. If a copied range looks different, check whether the paste operation included formulas, formatting, or values only. If the cleanup tool removes more rows than expected, undo immediately with Ctrl+Z on Windows or Command+Z on Mac, if the action is still available to undo, and redo the task with a more carefully selected range. A separate backup is more dependable than relying on undo for important data.

How Google Sheets differs from Excel

The basic ideas are similar in Microsoft Excel, but the menus and file workflow differ. In Google Sheets, use File > Make a copy for a separate Drive file and the sheet tab menu for an in-file duplicate. Excel has its own workbook and worksheet commands, so do not follow Excel-specific instructions when working in Sheets. Google Sheets is designed for browser-based editing and Drive sharing; access to a copied file should be checked in Google Drive rather than inferred from the original workbook’s sharing arrangements.

Frequently Asked Questions

Can I duplicate a Google Sheet without changing the original?
Yes. Use File > Make a copy for a separate spreadsheet or duplicate a tab for another sheet in the same file. Edits to the copy do not normally alter the original, though formulas may still link to shared source data.

How do I duplicate a tab in Google Sheets?
Open the sheet tab’s menu at the bottom of the spreadsheet and select Duplicate. Rename the new tab if needed, then review any formulas that refer to other sheets.

Does Google Sheets automatically remove duplicates?
No. Repeated values remain unless you remove them yourself. Use Data > Data cleanup > Remove duplicates to remove matching rows, or use conditional formatting to highlight repeats without deleting them.

Can I duplicate a Google Sheets file if I only have view access?
Not always. The owner can restrict copying, and your account may not have permission to make a copy. Ask the owner to enable copying or provide an authorized version.

Why did my formula change after I duplicated cells?
Relative cell references usually adjust when copied to a new position. Check the formula and its references; use absolute references where appropriate, or paste values only if you need fixed results instead of a live calculation.

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.