The fastest way to copy a Google Sheet
Open the sheet you want to copy, click the File menu at the top left, then select Make a copy. Google will create a duplicate in your own Google Drive with the name "Copy of [original name]". The copy includes all the data, formulas, formatting, and charts from the original — everything except comments and edit history.
This method works whether someone shared the sheet with you, you found it through a public link, or you are copying your own sheet to a different folder. The copy is entirely separate from the original, so changes you make will not affect the version other people see.
If you want to rename the copy when ready, Google will prompt you to do so right after you click Make a copy. You can also rename it later by right-clicking the file in Google Drive and selecting Rename.
Key Takeaways
- Make a copy from the File menu creates a complete duplicate in your Google Drive, including all data, formulas, and formatting.
- The copy is independent — changes you make do not affect the original sheet or anyone else's access to it.
- You can rename the copy during creation or anytime afterward through Google Drive.
- If you want to copy only specific rows, columns, or sheets within a larger file, you can select and copy them manually instead.
- Shared sheets, public sheets, and your own sheets can all be copied using the same method.
What gets copied and what does not
The copy includes every cell of data, all formulas and functions, cell formatting (colors, fonts, borders), charts, and pivot tables. If the original sheet has multiple tabs at the bottom, all of them copy over as well.
Comments and suggestions do not copy. Edit history does not copy. If the original sheet has data validation rules (dropdown menus, number ranges, or other restrictions on what can be entered), those rules copy to the new sheet. Protected ranges and sheets do not copy — the new sheet will be fully editable by you.
If the original sheet pulls data from another source using IMPORTRANGE or similar functions, those formulas copy but may not work in your version if you do not have permission to access the source. You will see an error in those cells instead.
Copying only part of a sheet
If you need only certain rows, columns, or a single tab from a larger sheet, you can copy those pieces manually instead of duplicating the whole file. Click and drag to select the cells you want, press Ctrl+C (or Cmd+C on Mac), then open a new or existing sheet and press Ctrl+V to paste.
When you paste, Google will ask whether you want to paste values only (just the numbers and text, no formulas) or paste all the formatting and formulas as well. Choose based on what you need — if you want the formulas to recalculate based on your new sheet's data, paste all formatting. If you just want the numbers, paste values only.
To copy a single tab from a multi-tab sheet, right-click the tab name at the bottom and select Move or copy. Choose Copy and select which sheet you want it to go to, or create a new sheet for it. This preserves the tab's name and all its contents in one step.
Where the copy lands in your Google Drive
When you use Make a copy, Google places the new sheet in the same folder as the original. If you copied a sheet from someone else's Drive that was shared with you, the copy goes into your own Drive's main folder (the root level) unless you move it.
You can move the copy to a different folder right after creating it, or anytime afterward. In Google Drive, click and drag the file to the folder you want, or right-click it and select Move to browse folders.
Copying a sheet to share with others
Once you have made a copy, it belongs to you and only you can share it. Open the copy, click the blue Share button at the top right, enter the email addresses or link you want to share with, and choose whether people can view, comment, or edit.
If you want to share the copy with the same people who had access to the original, you will need to share it separately — copying does not automatically carry over the original's sharing settings. This is useful if you want to give people a version they can edit without affecting the original.
Troubleshooting common copy problems
If the Make a copy option is grayed out or missing, you may not have permission to copy that sheet. Some sheets are restricted by their owner. Ask the owner to change the sharing settings or to make a copy for you.
If you see an error message after copying, it usually means a formula in the original sheet references data you do not have permission to see. The formula will not work in your copy. You can delete those cells or rewrite the formula to reference data in your own sheet instead.
If the copy is taking a very long time to appear in your Drive, refresh your browser or wait a few minutes — large sheets with many formulas or charts can take longer to duplicate. If it still does not appear after 10 minutes, try making the copy again.
Frequently Asked Questions
Can I copy a Google Sheet if it is password protected?
If the sheet itself is password protected, you cannot copy it at all — the Make a copy option will not appear. If only certain ranges within the sheet are protected, you can still copy the whole sheet, but those protected ranges will remain protected in your copy. You will not be able to edit them unless the owner removes the protection.
What happens if I copy a sheet that has a lot of formulas?
All formulas copy exactly as they are. If a formula references cells within the same sheet, it will work normally in your copy. If it references cells in a different sheet or file, it may break depending on whether you have permission to that other file. You can edit any formula in your copy without affecting the original.
Can I copy a Google Sheet to Microsoft Excel or another program?
You can read your copy as an Excel file, CSV, PDF, or other formats by opening the sheet, clicking File, then read, and choosing the format you want. This creates a separate file on your computer — it is not the same as copying within Google Drive.
If I copy a sheet and then the original gets deleted, does my copy disappear too?
No. Once you make a copy, it is completely independent. If the original sheet is deleted, your copy remains in your Google Drive untouched. The only exception is if the original sheet was shared with you and the owner removes your access — that does not affect your copy, which you own.
Can I copy a sheet that someone is currently editing?
Yes. Google will copy whatever version exists at the moment you click Make a copy. If the other person is editing it at the same time, you might get the version from a few seconds before their changes appear. Once your copy is made, their future edits will not affect it.