How to Access Shared Google Sheets

To access a shared Google Sheet, open the link the owner sent you while signed in to the Google account they shared it with. If you do not have a link, find the file in Google Drive under Shared with me. If Google says you need permission, use Request access or ask the owner to share the sheet with your email address.

What You’ll Need

A web browser and an internet connection. These steps are for Google Sheets and Google Drive in a browser.
The Google account that has been given access. If the owner shared the file with a work or school address, use that account rather than a different personal account.
Either the sharing link or enough information to locate the sheet in Google Drive. If the file is not shared with you yet, you will need to ask its owner for access.

Step-by-Step

Check which Google account is active. Open a Google page, such as Drive, and look at the profile icon in the upper-right corner. If you have several Google accounts, click the icon to see which one is currently selected. Choose the account the owner used when sharing the sheet. If it is not listed, select the option to add another account and sign in with the correct address. A file shared with one account normally will not appear as accessible when you are signed in to another.
Open the sharing link if you have one. Click or copy the link from the email, chat, or message where it was sent, then paste it into your browser’s address bar. Check that the address is a Google Sheets or Google Drive link and that you have not copied extra punctuation or only part of it. If the link opens a Google sign-in page, sign in with the account that was given permission, then return to the link if it does not reopen automatically.
Review the file name and access notice. When the link loads, confirm that the sheet is the one you expected. Google may show a request-access screen instead of the spreadsheet if your active account is not authorized. Do not assume that a link grants access simply because someone sent it to you: the owner’s sharing settings determine who can open it. If the page says the file does not exist, check the link with the sender before trying other accounts.
Find the sheet in Drive if there is no link. Go to Google Drive in your browser and select Shared with me in the left-hand navigation. Look for the spreadsheet by name, or browse folders that someone shared with you. Use the search box in Drive if you know all or part of the file name. Search results can include files you own as well as shared files, so check the owner or location if several similar results appear.
Open the file. In Drive, double-click the spreadsheet’s name to open it in Google Sheets. If it is inside a shared folder, open the folder first and then open the sheet. A single click selects a file; it may not open it. You can also select a file and use the open action shown in Drive, but double-clicking is usually the most direct method.
Check what you are allowed to do. Look at the controls and any access label near the top of the sheet. A Viewer can read the contents but cannot change the sheet. A Commenter can add comments and suggestions where available but cannot directly edit cells. An Editor can make changes. The owner may also set restrictions, so an editor might not be able to perform every action, such as changing sharing settings or downloading the file.
Use the sheet without changing more than intended. If you only need to read it, avoid typing in cells. If you have editing access, select a cell and enter the change, then press Enter; Google Sheets saves changes automatically when you are online. For feedback that should not replace data, use a comment if your role and the sheet’s settings allow it. If the owner expects a separate version, ask before making a copy, because a copy is a different file and later changes to the original will not automatically appear in it.
Make the file easier to find next time. A file in Shared with me is not necessarily stored in your own My Drive. In Google Drive, you can use the file’s context menu and choose Organize > Add shortcut to place a shortcut in a folder you can find easily, if that option is available. The shortcut does not transfer ownership or change who can access the original. Keep the original link or note the file name if you are unsure where you put the shortcut.

Common Mistakes

Using the wrong account is the most frequent cause of an access problem. A person may have a personal Gmail account and a separate work or school account open at the same time. The browser may automatically use the wrong one for a link. Check the profile icon and deliberately switch accounts before requesting access; otherwise, the owner may approve a different email address from the one you intend to use.

Another common mistake is treating the link as permission. A link to a restricted file only identifies the file; it does not authorize every recipient to open it. Conversely, an owner might allow anyone with the link to view a sheet, but that does not mean recipients can edit it. Confirm both the access scope and the role rather than assuming what the link permits.

People also sometimes search in the wrong place or mistake a shortcut for a copy. Shared files can be found in Drive’s Shared with me area, and adding a shortcut does not create an independently editable spreadsheet. Finally, avoid opening a file under a name that merely looks familiar. Check its title and owner, especially when a message contains several links or similarly named spreadsheets.

Tips

Ask the sender to share the sheet directly with the email address you will use. That is often clearer than passing around a restricted link.
When a sheet contains sensitive information, do not forward its link or change its access settings unless the owner has authorized you to do so.
Before editing, check whether other people are working in the file. Google Sheets can show collaborators, and edits may be visible to them as you work. Use a comment to flag an uncertain value rather than silently overwriting it.
If you need to work offline, do not assume a shared sheet will be available without preparation. Offline access depends on Google Drive settings, the browser, and the account, and may be restricted by a work or school administrator. Confirm availability before relying on it.
These directions are for Google Sheets in a browser. Excel sharing works differently: shared Excel workbooks are commonly stored and shared through OneDrive or SharePoint, and its menus and permissions are not the same as Google’s.

Troubleshooting

Google asks you to request access. First check the profile icon and switch to the account the owner shared with. If you are already using that account, click Request access and, if a message box is offered, explain briefly who you are and why you need the file. The owner or an authorized manager must approve the request. If the request button is not available, contact the person who sent the link and ask them to add your exact email address with the appropriate role.

The owner says access was granted, but the sheet still will not open. Verify which address they added, then reload the page. If you have multiple Google accounts signed in, open the link in a browser profile associated with the correct account, or sign out of the other accounts and sign in again. A private or incognito window can help isolate account confusion, but you still need to sign in with the account that has permission. Do not send your password or verification code to the owner.

The link shows an error, a blank page, or the wrong file. Ask the sender to resend the complete link and confirm that the spreadsheet has not been moved to the trash or deleted. If it opens a Google Drive preview, use the option to open the file in Google Sheets when shown. Refresh the page, check your internet connection, and try another current browser if the page will not load. If other Google files work but this one does not, the problem is more likely the file’s link or permissions than your browser.

You can view the sheet but cannot edit it. This usually means your role is Viewer or Commenter, or the owner has limited editing. Check the access role and contact the owner if you need to make changes. Explain which cells or task you need to edit so they can decide whether to change your role or provide another method. Do not make a separate copy as a workaround unless that is acceptable for the task; changes to a copy do not update the shared original.

You cannot find the file in Shared with me. Confirm that you are in the right account, search Drive using part of the file name, and ask the sender to check whether they shared the file or only mentioned it in a message. A file may also be inside a folder, or the sender may have shared a link that is accessible only to a particular group. If a workplace administrator manages the account, organizational sharing rules may limit access even when the sender wants to share it.

Frequently Asked Questions

Do I need a Google account to open a shared Google Sheet?

It depends on the owner’s sharing settings. A restricted file generally requires you to sign in to an account that has been granted access. If the owner permits anyone with the link to view it, you may be able to open it without being added individually, though Google may still ask you to sign in for some actions. Follow the access prompt shown for that file.

Why does a shared Google Sheet say I need permission?

The active account may not be the one the owner shared with, or the file may be restricted to named people or an organization. Check your account first. If it is correct, request access or ask the owner to share the file with your exact email address.

Can I open a shared sheet without changing it?

Yes. If you have Viewer access, you can read the sheet without editing its cells. If you have a higher role, simply avoid typing or changing controls. If you need to leave feedback, ask whether comments are appropriate and whether your access level allows them.

Can I edit a sheet if I only have the link?

Only if the owner’s settings give your account edit permission or allow link users to edit. A link by itself does not determine your role. If the sheet opens as read-only, ask the owner for Editor access rather than trying to bypass the restriction.

Where do shared sheets go in Google Drive?

Files shared with you usually appear in Shared with me, not automatically in My Drive. You can search for them in Drive or add a shortcut to a folder for easier access. A shortcut points to the shared original and does not create a new copy.

Will I see new changes after opening the sheet once?

Usually, yes. Opening the same shared file again shows its current contents, provided you still have access and are online. A downloaded file or a separate copy is not the live shared sheet, so changes made there may not match the original.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.