Steps to Copy a Google Sheet
1. Open the Google Sheet
To begin, you’ll need to open the Google Sheet you wish to copy. If it's been shared with you, you can find it in your Google Drive or use the link provided. Simply click on the link to open the sheet.
2. Make a Copy of the Sheet
Once the sheet is open, follow these steps:
Navigate to the Menu Bar: At the top of your screen, click on the File menu.
Select "Make a Copy": From the dropdown menu, click on Make a copy. This option will create a duplicate of the original Google Sheet.
3. Rename the Sheet (Optional)
When you click "Make a Copy," a dialog box will appear allowing you to rename the file.
Enter a New Name: If you want to give the copied sheet a different name, type it into the “Name” field.
Keep the Original Name: If you prefer to keep the original name, you can leave it as is, or simply add a “(copy)” to the end.
4. Choose the Destination Folder
In the same dialog box, you’ll see an option to choose where you want to store the copy in your Google Drive.
Select a Folder: If you want to save it to a specific folder in your Drive, click on the My Drive dropdown, and select the folder where you want to store the file.
Save to Root Drive: If you don't choose a folder, the copied sheet will be saved in your main Google Drive directory.
5. Click "OK"
Once you’ve renamed the file and selected the folder (if needed), click the OK button. Google Sheets will create a copy of the original file in your Google Drive.
6. Edit Your New Copy
Now that you have your own copy of the sheet, you can start making changes right away. The original document remains unchanged, so you’re free to edit, update, and customize the sheet to meet your needs.
You can add data, modify existing content, or apply new formatting as necessary.
Any changes you make will only affect your copy, not the original sheet.
Conclusion
Copying a Google Sheet is a quick and easy process that allows you to create your own version of someone else’s document. Whether you're working on a template, need a base for further customization, or simply want to save a copy for personal use, this method ensures you can make it your own without altering the original.
Feel free to follow these steps anytime you need to create a duplicate of a Google Sheet for your personal or professional use!
If you have any questions, please reach out to our Customer Success team via the blue chat icon in the bottom right of your screen, or via [email protected].