Google Sheets stores the workbook as a Google Drive file. If the whole spreadsheet disappeared, start with Drive Trash and ownership. If the file still opens but cells or tabs are missing, skip Trash and use version history.
Fast answer: In Drive, select Trash, sort by Trashed date, right-click the Sheet, and choose Restore. Files remain in Trash for 30 days unless someone deletes them forever sooner.
1. Rule out a moved or renamed spreadsheet
- Verify the Google account shown in the browser.
- Search Drive with the file type set to Spreadsheets.
- Filter by owner, location, people, and modification date.
- Inspect Shared with me and relevant shared drives.
- Open Drive Activity to identify a move, rename, or deletion.
Search with a known tab name or old URL when the title is uncertain. If the link opens but requests access, ask the owner to restore permission. That is not a deleted workbook.
2. Restore the Sheet from Drive Trash
- Open Trash in Drive's left navigation.
- Sort by Trashed date.
- Select the likely spreadsheet and inspect its owner.
- Right-click and choose Restore.
- Search for the filename again and note its restored location.
Google states that Drive keeps trashed files for 30 days. Emptying Trash permanently removes them earlier. Do not create a same-name replacement first; it can make searches and collaborator messages ambiguous.
3. Resolve ownership and shared-drive cases
A Sheet shared with you may belong to another person. Removing it from your view does not necessarily delete the owner's copy. Ask the owner to inspect their Drive, Trash, and Activity and to re-share the original URL.
Files created in a Workspace shared drive belong to the organization. Recovery permissions depend on the member role. Google documents that restoring from a shared drive's Trash requires at least Contributor access, while managers have broader deletion controls. If you cannot see the relevant Trash or drive, contact a manager or Workspace administrator.
4. Recover a workbook that lost its folder
An owned spreadsheet can become unorganized when its parent folder is removed. Search Drive for <code>is:unorganized</code>. Verify the workbook by opening it and checking a known sheet or cell, then move the same file into a stable folder.
Avoid making a copy merely to organize it. A copy starts a separate file history and can divide collaborators between two spreadsheets.
5. Escalate after permanent deletion
When the Sheet is absent from Trash, try Google's signed-in recovery flow if offered. Work and school users should contact their Workspace administrator quickly. Supply the owner account, old URL, title, approximate deletion time, former folder or shared drive, and whether Trash was manually emptied.
Recovery is not guaranteed. Account type, deletion timing, administrative retention, and legal-hold settings can change what remains available.
6. Audit the spreadsheet after restoration
Do not stop when the grid appears. Check the structures that determine results:
- Compare the expected sheet-tab list, including hidden sheets.
- Inspect final rows and key input cells.
- Sample formulas at the top, middle, and bottom of important ranges.
- Confirm named ranges, protected ranges, filters, and filter views.
- Check PivotTables, charts, conditional formatting, and data validation.
- Review sharing roles and linked Forms or external data.
Avoid sorting, importing, or changing formulas until this baseline is recorded. Those actions can create a new version that obscures the state you are trying to assess.
7. Use version history for missing cells or tabs
Open File > Version history > See version history. Google requires edit access to browse prior versions. Select a timestamp before the unwanted change and verify the exact cells, formulas, or tab that disappeared.
Use Make a copy from the version menu when only part of an older workbook is needed. Then transfer a range or sheet into a duplicate of the current file. Restore the whole earlier version only when its entire state is preferable.
Google's cell-level Show edit history can help identify some changes, but it does not show every type of operation. Inserted rows, formatting, and formula-driven changes may require full workbook history.
Match the failure to the tool
| What you observe | Best tool | Spreadsheet check |
|---|---|---|
| Sheet is in Trash | Drive Restore | Tabs and formulas |
| Old URL requests access | Owner or manager | Sharing roles |
| Workbook is present but a tab vanished | Version history | Hidden and deleted sheets |
| Parent folder was removed | <code>is:unorganized</code> | Same file ID |
| Shared drive disappeared | Workspace manager | Membership and role |
| Trash is empty | Recovery flow or admin | Owner and deletion time |
Close the recovery safely
Once the workbook passes its audit, return it to the correct folder and ask a second stakeholder to verify critical totals. Name the current version with the recovery date. For a high-value financial or operational sheet, export a dated Excel or PDF snapshot and store it outside the live collaboration path.