How do I find and delete large files from Google Docs?

The company I work for uses Google Apps (currently the free edition). I am nearing my storage limits (1GB) for the associated Google Docs.

Is there a way to find the large files (non Google Docs format files) that I have uploaded to Google Docs? I don’t see a way to filter files based on size. I am hoping to delete the larger files to free up some space for my account. I am aware that we can purchase more storage if we need it, but I want to try deleting some files before we consider purchasing more storage.

Any suggestions?

Answer

The answer does not quite fit into webapps, but there it is. I don’t know of any other way to get the info without custom code.

  1. Go to Google Docs
  2. Create a new Spreadsheet
  3. Go Tools/Script Editor
  4. Replace the empty function in there with the text from here: http://pastebin.com/2uRe6GR0
  5. Save (give any name)
  6. Press run (green arrow) button. You may need to do it twice and at some point it will ask you to authorize the script and then you may need to press it again. Basically get the script to run
  7. Go back to your original empty spreadsheet and voila, it has the information you need with the biggest file at the top. Apparently, files in native Google Docs format show size as 0 and do not contribute to your quota.

Attribution
Source : Link , Question Author : ossandcad , Answer Author : Alexandre Rafalovitch

Leave a Comment