In this tutorial, we will learn How to make a copy of a file in Google Sheets
Whenever you need to create a copy of your existing Google spreadsheet you can easily do it following the two methods which we are going to show you in this tutorial.
You can duplicate your existing Google Spreadsheet either directly by opening the spreadsheet which you want to copy or from Google drive as well.
Enclosed are the steps to make a copy of a file in Google Sheets
- Open the Google Sheets that need to be copied.
- Navigate to the File menu on the Main menu bar
- From the drop-down options select “Make a copy“
- Specify the name of the new Spreadsheet File.
- Now Click on “OK“
Enclosed are the steps to make a copy of a Google Sheets file, from Google Drive :
- Logon to Google drive
- Identify the file which you want to copy
- Now Select the File and right-click on it.
- From the available drop-down Select “Make a copy”
Let’s see the above-mentioned steps in detail.
How to make a copy of a file in Google Sheets: Step by Step Guide
# Make a copy from within the existing Google Spreadsheet
How to make a copy of a google sheet within a google sheet?
To make a copy of a google sheet within a Google Sheet, Logon to Google Sheets, open the Google Spreadsheet that you want to copy, Go to File menu and select “Make a copy” option ( File->Make a copy)
Follow the below steps to make a copy of a file in Google Sheets.
Step 1: Open the Google Sheets that need to be copied.
Open the Google Sheets that you want to copy. In this example, we have a Monthly Budget/expense spreadsheet from which we want to make a copy and create a similar file with a different name.

Step 2: Navigate to the File menu on the Main menu bar
Step 3: From the drop-down options select “Make a copy”
Click on the File menu as shown below.
Select “Make a copy ” from the drop-down

Step 4: Specify the name of the new Spreadsheet File.
Once you click on “Make a copy” a new Copy document window will pop up where you can specify the new file name

Step 5: Now Click on “OK“


You also get the option to share the document with the same set of people with whom the document was shared earlier using “Share it with same people“.Simply check this option to share it with the same people.
if you want to also copy the comments from the existing spreadsheet, you can click on the option “Copy comment” which will copy the existing comments as well to the new document.
#Make a copy of the existing Google spreadsheet from Google drive
How to make a copy of a google sheet from google drive?
To make a copy of a Google Sheet from Google drive, logon into Google drive, identify the file which needs to be copied, Select the file right click and choose “Make a copy” from the drop-down
Follow the below steps to make a copy of the existing Google spreadsheet from Google drive
Step 1: Logon to Google drive
Go to the Google drive link to log in or follow the alternate method to log in.
Once you are logged in to your Google Account Click on the dotted square icon beside your profile and click on the Google Drive icon.

Step 2: Identify the file which you want to copy

Step 3: Now Select the File and right-click on it.
Step 4:From the available drop-down Select “Make a copy”
Once you right-click on the file, from the available drop-down options select “Make a copy“

Once you click on Make a copy you will get a message on the bottom left of your Google drive stating “creating a copy of ” followed by the filename.
Once the copy has been created you can find the new copy of your existing spreadsheet in Google drive.

Wrapping up
You can easily create a copy of an existing spreadsheet following the two methods which we have discussed in the tutorial.
We hope this tutorial on How to make a copy of a file in Google Sheets was useful.
Related articles :
How To Transpose Data in Google Sheets
How to count non-empty cells in google sheets