✦Template Printable Ideas Insights

How to Create a View-Only Copy of Google Sheets

By

Ever wanted to share a Google Sheets file without giving others the ability to modify it? The process is straightforward, and in this guide, we'll walk you through the steps to create a view-only copy of your Google Sheets file.

Before we dive in, let's ensure you understand why you might need to make a Google Sheets copy that is view-only. This is particularly useful when you want to share sensitive data, prevent accidental edits, or maintain a master version of your sheets while allowing others to view it.

Creating a View-Only Copy of Google Sheets

To get started, we'll navigate through the Google Sheets interface and make a copy of your file with view-only permissions.

How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
How to add a Calendar into a cell in Google Sheets #googlesheets #tutorial #spreadsheet
6 Crazy Google Sheets Formulas You Should Know
6 Crazy Google Sheets Formulas You Should Know
Google Sheets Checklists
Google Sheets Checklists

First, open the Google Sheets file you want to share. If the file is not yours, make sure you have editing rights. If you don't, ask the file owner to give you editing access or follow the view-only link they've shared.

Making a Copy of the Google Sheets File

Once you have the file open, the first step is to create a copy of it. Follow these steps:

How To Create Checklists with Google Sheets
How To Create Checklists with Google Sheets
the google sheets has hidden gems you're not using on your webpages
the google sheets has hidden gems you're not using on your webpages
How to use Google Sheets: A beginner's guide | Zapier
How to use Google Sheets: A beginner's guide | Zapier
  1. Click on File in the menu.
  2. Hover over Make a copy and click on it.
  3. In the top-right corner of the popup, click on the down arrow next to the name of the new file that's about to be created.

Changing the Share Settings to View-Only

Now that you have a copy of the file, let's make it view-only. Here's how:

  1. Click on the drop-down arrow next to the name of the new file in the top-left corner.
  2. Select Share from the menu that appears.
  3. Under the General access section, adjust the share settings to Anyone with the link can view or Restricted, depending on your preference.
  4. Click on Done to save the changes.

Sharing the View-Only Copy

Now that you've created a view-only copy of your Google Sheets file, it's time to share it. Here's how:

1. Follow the same steps as above to open the Share menu.

Google Sheets: Copy Down FAST - Teacher Tech with Alice Keeler
Google Sheets: Copy Down FAST - Teacher Tech with Alice Keeler
How To Create A Filter in Google Sheets Mobile?
How To Create A Filter in Google Sheets Mobile?
9 Google Sheets Apps to Boost Your Productivity
9 Google Sheets Apps to Boost Your Productivity
How to Calculate Running Total in Google Sheets
How to Calculate Running Total in Google Sheets
Create a Google Sheets Second Brain
Create a Google Sheets Second Brain
Weekly Planner (Google Sheets)
Weekly Planner (Google Sheets)

2. In the People section, type the email addresses of the people you want to share the file with. You can also share the file via a link by clicking on Copy link.

Sending the Invitation or Link

Once you've added the recipients, you can send them an invitation or share the link. Here's how:

  1. If you're using email addresses, select the role of each person. For view-only access, select Viewer.
  2. Click on the Send button to send the invitations.
  3. If you've chosen to share the link, you can do so directly in the email or messaging platform of your choice.

That's it! You've now successfully created a view-only copy of your Google Sheets file and shared it with others. By following these steps, you can maintain control over your sensitive data while allowing others to view it.

Google Sheets - Export to CSV File
Google Sheets - Export to CSV File
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
15+ Ways for Teachers to Use Google Sheets in the Classroom - SULS0187
Essential Google Sheets Text and Web Formulas for Productivity
Essential Google Sheets Text and Web Formulas for Productivity