How to Share a Google Sheet

Why Sharing Google Sheets Matters

Collaboration is at the heart of modern work. When you keep spreadsheets locked in a single account, you create bottlenecks. Changes require email exchanges. Team members wait for updates. Questions go unanswered because people cannot see the current data. Sharing your Google Sheets breaks down these barriers and transforms how teams work together.

Google Sheets offers three distinct permission levels, each serving different purposes. Viewer gives read-only access. Commenter allows feedback without editing. Editor grants full control to add, modify, and delete content. Understanding which permission to grant to which person ensures your data stays secure while enabling collaboration at the right level.

You can share sheets with specific individuals by their email address, with an entire organization or group, or publicly via a link. Each method has strengths depending on your audience and security needs. This guide covers every sharing method Google Sheets provides, from the simplest individual share to advanced options like time-limited access and protected ranges.

Sharing with Specific People by Email

The most direct way to share is to invite specific people by their email addresses. This method gives you the most control because you know exactly who can access your sheet.

Open your Google Sheet and click the Share button in the top right corner. A dialog box opens. In the text field, type the email address of the person you want to share with. You can add multiple people by typing each address and separating them with commas.

Next to each email address, select the permission level from the dropdown. Viewer is the default. If the person only needs to read and reference data, Viewer is appropriate. If they need to provide feedback or suggestions without changing the actual data, choose Commenter. If they need to actively edit the sheet and make changes, choose Editor.

Add a personal message if you like. The message appears in the invitation email and helps the recipient understand why you are sharing the sheet with them. Click Share, and Google Sheets sends an email invitation to each person you entered.

The recipient receives an email with a link to the sheet and information about their permission level. They click the link and gain access immediately. If they do not have a Google account, they will be prompted to create one, though Google accounts are free and only require a valid email address.

After sharing, you can see who has access by clicking Share again. Under “People”, you see every person with permission to view, comment on, or edit the sheet. You can change someone’s permission level at any time by clicking their name and selecting a different role.

Creating Shareable Links

Sometimes you want to share with people whose email addresses you do not have, or you want to make it easy for multiple people to access without sending individual invitations. Link sharing solves this problem.

Click Share, then click Change at the top where it says “Restricted”. A dialog appears with sharing options. Select “Anyone with the link” to make the sheet accessible to anyone who has the link URL.

Below that, choose the permission level for link sharing. You can set it to Viewer, Commenter, or Editor. This permission applies to everyone with the link, so be intentional about which level you choose. Viewer is appropriate for public information. Commenter works when you want feedback but want to protect the actual data from changes. Editor should only be used if you want anyone with the link to make changes.

Click Share and Google Sheets generates a link you can copy. Share this link via email, messaging, Slack, or any other method. Anyone who clicks the link and signs into their Google account gains access with the permission level you set.

One important distinction: “Restricted” means only the specific people you invite can access the sheet. “Anyone with the link” means anyone with the URL can access it if they are signed into Google. “Public on the web” makes it fully searchable and accessible without requiring any Google login.

For most situations, “Anyone with the link” is the right choice when using link sharing. It balances accessibility with security. Public on the web should only be used if you intentionally want your sheet searchable in Google and accessible to people without a Google account.

Sharing with Google Groups and Organizations

If you work in a Google Workspace organization with multiple employees, you can share sheets with entire groups or domains at once. This is far more efficient than inviting people individually.

When you click Share and enter an email address, you can type a Google Group email instead of a person’s email. If your organization has a group called “marketing-team@company.com”, entering that email shares the sheet with everyone in that group. All group members gain access with the permission level you select.

For Google Workspace administrators, you can share sheets with everyone in your entire domain. In the Share dialog, select the domain name option and choose the permission level. Every employee in your organization gains access. This is useful for company-wide resources like a master budget template or employee directory.

Group and domain sharing scales your collaboration efforts. You do not need to remember every person’s email address or resend invitations when team membership changes. The group membership controls who has access automatically.

Setting Time Limits on Access

Google Workspace accounts have access to a feature called “Expiring access”. This lets you grant temporary permission to a sheet that automatically expires on a date you choose.

Click Share and find the person whose access you want to limit. Click their name to open their settings. In the window that appears, find the option “Expiring access” and enable it. Set the date and time when the access should expire. The person retains full permissions until that moment, then access is automatically revoked.

This feature is perfect for situations where someone temporarily needs to help with a project. You share the sheet with them, set an expiry date for when the project ends, and never have to remember to remove them manually. When the date arrives, their access simply stops working.

Expiring access applies only to people you have invited by email. It does not work with link sharing. If someone needs temporary access, invite them individually and use the expiring access feature rather than sharing a link.

Managing Access and Viewing Permissions

Over time, you may need to change who can access your sheet or what permissions they have. Google Sheets makes this easy by showing you all current access in one place.

Click Share to open the sharing panel. Under “People”, you see every person with access and their current permission level. Hover over a person’s name to see options. Click the permission dropdown next to their name to change from Viewer to Commenter to Editor, or vice versa. The change takes effect immediately.

To remove someone’s access entirely, hover over their name and click the trash icon. Confirm the removal, and they can no longer view the sheet. If they try to open the URL, they receive a message saying they do not have access.

You can also see who has access via the sharing link. Click “Change” next to “Sharing Settings” to see the current link permission level and who has viewed the sheet recently via the link.

For the owner of a sheet, you remain the only person with the ability to delete it or change its title. Editors can modify content but cannot delete the sheet or change core settings. Commenters and Viewers cannot change permissions at all. Understanding these permission boundaries prevents accidental deletions or settings changes by well-meaning collaborators.

Protecting Specific Ranges Before Sharing

Sometimes you want to share a sheet but need to protect certain cells from being edited. Perhaps you want people to see your data but not change your formulas or critical values. Range protection solves this problem.

Before sharing, set up your protected ranges. Open the sheet and select the cells you want to protect. Click Data in the menu, then Protect sheets and ranges. Give your protection a description. Choose to protect the range and set the protection to “Restrict who can edit”.

Select which users can edit the protected range. You can allow only yourself, or you can list specific people who have edit permission even though they normally could not. Everyone else sees the data but cannot modify those cells. Their edits to other cells work normally.

A common pattern is to protect all formula cells and summary rows while allowing people to edit input cells. For example, a budget template might protect the SUM formulas and budget limits but allow editors to change their department’s actual spending in specific cells. This keeps the template intact while letting people use it properly.

Protected ranges are visible to everyone who accesses the sheet. When they try to edit a protected cell, a message appears explaining that the range is protected. They are not blocked from viewing the content, only from changing it. This is a collaborative approach to data integrity.

Making a Sheet View-Only with Download Restrictions

If you want people to see your data but absolutely prevent copying, downloading, or printing, use the “Publish to web” feature with view-only settings.

Click File, then Publish to the web. Choose the sheet you want to publish and decide the output format. You can publish as a web page, PDF, or Excel file. Select “Sheet” and “Webpage” to make it viewable in a browser.

After publishing, a unique URL is generated. Share this URL instead of the sheet itself. People who visit the URL see your sheet in a viewer interface where they can browse the data but cannot download the file, print it, or access the spreadsheet editor.

This approach is useful when you want to display data but need complete control over access. Anyone with the link can view, but they cannot export, modify, or print. If you change the sheet later, the published version updates automatically to reflect your changes.

However, published sheets are completely public once the link is shared. Do not publish sheets containing confidential information. Use standard sharing with permission controls for sensitive data.

Sharing Google Sheets on Mobile Devices

The Google Sheets mobile app for Android and iOS includes sharing features, though they are streamlined compared to the web version.

Open the sheet in the Google Sheets app on your phone or tablet. Tap the share icon (a person with a plus sign) in the top right. The interface looks similar to the web version. Enter the email address of the person you want to share with, select their permission level, and tap Send.

You can also tap the three dots menu and choose Share to access all sharing options, including link sharing. The mobile app handles sharing smoothly, though the smaller screen makes it harder to manage many people at once. For complex sharing changes, the web version is still preferable.

Mobile sharing is perfect when you are on the go and need to quickly give someone access to a sheet. You do not need a computer. Simply open the sheet on your phone, tap Share, and invite the person with a few taps.

Transferring Ownership to Another Account

Occasionally, you need to hand off a sheet to someone else entirely. This is different from just giving them edit access. Ownership transfer makes them the owner, giving them complete control including the ability to delete the sheet.

Click Share and find the person to whom you want to transfer ownership. Click their permission dropdown and select “Make owner”. They immediately become the owner of the sheet. You remain as an editor unless you change your own permission.

Only the owner of a sheet can transfer ownership. Once transferred, the new owner can change permissions, delete the sheet, or transfer ownership again to someone else. This is a permanent change that cannot be undone through the sharing interface.

Use ownership transfer when someone else should be responsible for maintaining a sheet going forward. For example, when a project manager hands off a tracking sheet to their successor, they transfer ownership so the new person has full control.

Sharing Versus Publishing to the Web

Google Sheets offers two distinct ways to make data public. Sharing creates an interactive spreadsheet with full collaboration features. Publishing to the web creates a static, read-only view.

When you share a sheet and set it to “Public on the web”, anyone can find it through Google search and access it. They can view all cells, sort data, and use the sheet as a view. If you give them editor permission, they can also modify the content. This is collaborative and designed for teamwork.

When you publish to the web, you create an embedded view of your sheet. Visitors see the data but cannot interact with the spreadsheet editor. They cannot sort, filter, or edit cells. You can customize what is visible and control updates independently of the actual spreadsheet. This is useful for displaying data on a website or sharing a read-only snapshot without exposing the full spreadsheet.

Choose sharing when you want live collaboration and need people to interact with the actual spreadsheet. Choose publishing when you want to display data on a website or provide a read-only view. The publishing approach is safer for sensitive information because viewers cannot access the formula bar or make any changes.

Troubleshooting Common Sharing Issues

Sharing usually works smoothly, but occasional problems arise. Knowing how to diagnose and fix them keeps collaboration moving.

If someone says they cannot access a sheet you shared, verify their email address. Typos in email addresses are a common cause. Check the Manage Access panel to confirm you sent the invitation to the correct email. Ask the person which email address they use for Google. If it is different from the email you used, send them a new invitation to the correct address.

If you shared via link and someone cannot access the sheet, make sure the link sharing is turned on. It is possible someone turned it to “Restricted” after you shared the link. Click Share and check the sharing settings. If it shows “Restricted”, it is no longer accessible via the link you distributed.

Sometimes an organization has restrictions that prevent external sharing. Your Google Workspace administrator may have disabled sharing outside the organization or with certain domains. If you are working in a corporate environment and cannot share with external people, contact your IT team about your organization’s sharing policies.

If someone has edit permission but their changes are not showing up, ask if they are signed into the correct Google account. People sometimes have multiple Google accounts. They may be editing a different copy of the sheet in another account, not realizing they are not in the shared version. Verify they are signed into the correct account and viewing the sheet at the correct URL.

For sharing problems that persist, make sure both you and the person experiencing the issue have up-to-date browsers and the latest version of the Google Sheets app if using mobile. Clearing your browser cache sometimes resolves unexpected sharing behavior.

Frequently Asked Questions

To apply more advanced control beyond basic sharing, learn how to use IF formulas in Google Sheets to set up conditional access patterns. Discover how to protect cells in Google Sheets before sharing so people cannot accidentally modify critical formulas. If your team needs to create drop-down lists in Google Sheets, shared sheets make it easy for others to use these validated inputs. For collaborative data analysis, understanding how to make a graph in Google Sheets lets multiple people reference the same visualizations. You can also combine sharing with data protection by learning to freeze rows in Google Sheets so shared team members always see your headers.