My Google Sheets: How to Find and Manage Your Files

Your Google Sheets are spreadsheets saved in Google Drive and linked to the Google Account you used to create or open them. To find them, go to sheets.google.com while signed in, or search for them in Google Drive; if a file is missing, first check that you are using the right account.

“My Google Sheets” is not a separate app or folder name. It usually means your Sheets documents: files you own, files shared with you, or spreadsheets available through a school or work account. Here is how to locate, open, organize, share, and troubleshoot them in a web browser.

What Google Sheets stores

Google Sheets is Google’s browser-based spreadsheet application. A spreadsheet you create is saved in Google Drive, Google’s online file storage service. You can usually return to it from the Sheets homepage or from Drive, and changes are saved online as you work when your connection is available. The file is associated with the Google Account in use, not with a particular computer.

A Google Sheets file can contain one or more tabs, which appear along the bottom of the spreadsheet. Each tab is a worksheet within that same file; it is not a separate document in Drive. A file might hold a household budget, a class schedule, or several months of sales records on separate tabs. This distinction helps when searching: look for the spreadsheet’s file name, rather than the name of a tab inside it.

Sheets can also open and edit some Microsoft Excel files. An Excel workbook may remain an .xlsx file when edited in Sheets, or you can convert it to Google Sheets format. The file type and available features can differ, so check the file name and extension in Drive when you need a particular format.

How to find your spreadsheets

Start at sheets.google.com. If you are signed in, the page shows spreadsheets you can access, including recent files. Use its search box to look for a title or a word you remember. If the list looks empty or unfamiliar, click your profile picture in the upper-right corner and confirm the account shown there. People commonly have separate personal, school, and work accounts open in the same browser.

You can also find Sheets files through Google Drive:

Open drive.google.com and sign in to the account that should have the spreadsheet.
Enter part of the file name in the Drive search field. If you do not know the exact name, try a distinctive word from it.
Use Drive’s search filters, including file type, to narrow results to Google Sheets files.
Check My Drive, Shared with me, and any relevant shared drive if the file does not appear in the first results.

“Shared with me” is a useful place to look for a spreadsheet someone else owns and gave you access to. It does not necessarily mean the file is in your My Drive. You can add a shortcut to a shared file in a location you can find later, but moving or organizing a shortcut does not transfer ownership of the original spreadsheet.

Open a sheet or create a new one

Click a spreadsheet’s name in Sheets or Drive to open it in the browser. If it opens in view-only mode, you may not have permission to edit, or the file owner may have limited access. A file that is still an Excel workbook may display an Excel file indicator; opening it in Sheets does not always mean that it has been converted to Google Sheets format.

To make a new spreadsheet, open sheets.google.com and choose Blank spreadsheet, or use the New button in Google Drive and select Google Sheets. Give the file a descriptive name near the top of the page. Google Drive places a new file in the location where you created it, so starting from a folder can make it easier to keep related documents together.

For example, a household expense sheet could be named “Household expenses 2026” and have tabs for each month. Clear names make search more useful later. If you create a file from a template, review its existing labels and formulas before entering personal information; a template is a starting point, not a guarantee that its layout fits your needs.

Organize and work with your files

In Drive, you can create folders, move files you own, and add stars to documents you want to find quickly. Right-click a file in Drive to see available organization options. For shared files, some actions may be restricted by the owner or by an organization’s settings. A shortcut can help you keep a shared spreadsheet near your own work without making a second copy that could become outdated.

Inside a spreadsheet, click a cell to enter text, numbers, dates, or a formula, then press Enter. You can rename, add, or rearrange worksheet tabs from the tab controls at the bottom. Common tools include number formatting, filters, charts, and conditional formatting; for example, Format > Conditional formatting lets you apply a visual rule to cells that meet a condition. Menu availability can change with your permissions and the kind of file you opened.

When multiple people edit a file, changes can appear for collaborators without sending separate versions by email. That is convenient, but it makes clear labels and careful editing important. Before changing a shared spreadsheet, check which tab and range you are working in. If you only need to suggest a change, use a comment or ask the owner whether you have commenter access rather than altering the data directly.

Sharing, permissions, and ownership

To share a spreadsheet, open it and select the Share button. Add the person’s email address and choose an access role such as Viewer, Commenter, or Editor, when those options are available. Viewers can read the file, commenters can leave feedback, and editors can change its contents. The owner can also set general access, such as Restricted or access for anyone with the link, subject to any restrictions imposed by a school or workplace.

Use the narrowest access that meets your purpose. A link does not automatically make a file public; its effect depends on the general-access setting shown in the sharing dialog. Before sending a link, check who can open it and what they can do. Avoid putting confidential or sensitive information in a spreadsheet shared broadly, and remember that copying a link into a message does not itself grant permission if the recipient is not allowed access.

Ownership matters when someone leaves a team, changes accounts, or removes a file. A shared spreadsheet may be owned by another person or organization, and you may not be able to transfer it yourself. If you need continued access, ask the owner or administrator about the appropriate option. Making a copy may be possible, but it creates a separate file and may not carry over every permission, link, or workflow connected to the original.

Saving, version history, and recovery

Sheets generally saves changes to Drive automatically when the browser is online. Look for the saving or saved status near the top of the page if you want confirmation. If your internet connection drops, wait for it to return and check the document’s status before closing the tab. Do not assume an unsent local change has reached collaborators until the service indicates that it is saved.

To review earlier edits, open the spreadsheet and choose File > Version history > See version history. The history panel shows saved versions and, in many cases, who made changes. You can inspect an earlier version and restore it if appropriate. Restoring affects the shared document, so consider telling collaborators first. For a safer comparison, you may make a copy of the current file before restoring an older state.

If a spreadsheet was deleted, check the Trash in Google Drive. You may be able to restore a file that is still there, depending on your account and organization’s policies. If it is not in Trash, was permanently deleted, or belongs to a managed account, contact the owner or administrator promptly. Avoid assuming that a spreadsheet can always be recovered indefinitely.

Download, export, and Excel differences

To save a local copy or create a file for another application, open the spreadsheet and use File > Download. Available formats can include Microsoft Excel (.xlsx), PDF, and comma-separated values (.csv), depending on the document and current options. A CSV export is generally for tabular data and does not preserve the full spreadsheet experience, such as multiple tabs, formatting, or charts. Choose the format based on what the recipient needs to do with the file.

Google Sheets and Microsoft Excel overlap, but they are not identical applications. Some formulas, formatting, charts, scripts, and data features can behave differently when a file moves between them. If you export a workbook for an Excel user, open the downloaded copy in Excel and review important formulas and layouts before relying on it. In Google Sheets, use Google’s own menus and help for instructions; Excel has different menu names and may handle a feature differently.

Common problems and practical fixes

The file is missing: Check the account profile, search Drive with part of the title, look in Shared with me and Trash, and ask the owner whether the file was renamed or access changed.
You can open it but cannot edit: Check whether the page says view-only, then request editor access from the owner. Do not make a separate copy unless that is acceptable for your task.
A link says access is denied: Sign in with the account the owner invited, or request access from the page. A link alone does not override the spreadsheet’s permissions.
Changes seem absent: Check the saving status and internet connection, then reopen the file after it has synced. If another editor changed the same cells, consult version history before replacing data.
The wrong file opens: Search by the full title and check whether similarly named copies or Excel files exist. Confirm the file’s location and owner before editing or deleting anything.

If you are using a work or school account, an administrator may control sharing, retention, access, or account availability. A personal account and an organizational account can show different files even when both are signed in in the same browser. For account access problems, use the sign-in recovery process or contact the organization’s administrator rather than sharing passwords with another person.

Frequently Asked Questions

Where are my Google Sheets stored?

Google Sheets files are stored in Google Drive and associated with the Google Account that has access to them. Find them at sheets.google.com or drive.google.com. Shared files may appear under Shared with me rather than in My Drive.

Why can’t I see my Google Sheets?

The most common reason is that you are signed in to a different Google Account. Check your profile picture, then search Drive by file name and check Shared with me and Trash. If it is still missing, ask the owner whether it was moved, deleted, or shared with another account.

Does Google Sheets save automatically?

Sheets saves changes to Drive automatically when it is connected and the changes have synced. Check the status near the top of the spreadsheet, especially after an internet interruption. Avoid closing the page while it still indicates that changes are being saved.

Can I use Google Sheets without a Google Account?

You generally need to sign in to create and manage your own Sheets files. Someone may be able to view or edit a particular file without signing in if its owner has enabled an applicable link-sharing option, but that is controlled by the file’s access settings and may be blocked by an organization.

Can I open my Google Sheets in Excel?

You can download a spreadsheet using File > Download > Microsoft Excel (.xlsx), then open that copy in Excel. Check formulas, formatting, and features after conversion because the two programs do not support every feature in exactly the same way.

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.