In this article:

How to Find Trash in Google Sheets (Easiest Way in 2024)

Google Sheets Trash

Google Sheets itself does not have a dedicated "Trash" or "Bin" feature within its interface for directly managing deleted files. Instead, files deleted from Google Sheets are moved to the Trash (or Bin) in Google Drive. Files in the Trash will be automatically deleted after 30 days. You can restore files from your Trash before the 30-day time window expires.

How to Find Trash in Google Sheets

To find trash in Google Sheets, you can navigate Google Drive. Here’s how you can access Google Sheets trash. 

1. Access Trash in Google Drive

Instead of looking in Google Sheets, go directly to your Google Drive dashboard. This location stores all your files, including Google Sheets. In Google Drive, find the "Bin" section on the left sidebar. This is where all deleted files are temporarily stored.

google sheets trash

2. Locate Your Deleted Google Sheets File

Within the Trash or Bin, you can search or scroll to find your deleted Google Sheets document. Use the search bar for quicker access if you remember the file name.

how to find trash in google sheets

3. Restore or Permanently Delete Your File

Right-click on the Google Sheets file you wish to recover or remove forever. Choose "Restore" to get it back or "Delete forever" to remove it permanently.

google sheets trash folder

4. Confirm Your Decision to Restore or Delete

After choosing to restore or delete, a confirmation prompt may appear. Confirm your choice to complete the action.

where is trash in google sheets

We hope that you now have a better understanding of how to find trash in Google Sheets. If you enjoyed this article, you might also like our article on how to add cell borders in Google Sheets or our article on how to embed Google Sheets.

Automate repetitive tasks with Lido

Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.

Select trigger
When a cell value in Google Sheets changes
Check Google Sheets for today's date
When a new row is added to Google Sheets
On new Google Form submission
Send me a daily reminder
On new Typeform submission
When a cell value in database changes
Check database for today's date
When a new row is added in database
When a new HubSpot customer is created
Select action
Creates a one- or multiple-day calendar event with optional attendees
Adds an object to Hubspot
Create a Slack channel, and optionally add a topic or members
Makes any HTTP request
Replaces [@column_name] values in a Google Doc with the corresponding table row's values
Replaces [@column_name] values in a Google Doc with the corresponding table row's values, then export it as a PDF
Makes any HTTP request and returns the response
Inserts given array below defined values in given worksheet
Sends an email using your Google account
Sends an email using your Microsoft Outlook account
Sends a Slack message
Sends an SMS message using your Twilio account
Updates cells with given values
Updates a property of a Hubspot object
Trigger is required
Action is required
Get started