4

I have been using Google Drive for several years. At this moment, I have a very robust folder structure there, with many files of various types, altogether more than 13 GB. Now I need to search my Drive for all .gdoc and .gsheet files. With so many files on my Drive, it is almost impossible to do it manually. I know how to search Google Drive for all "text documents" (or for all "spreadsheets") but this gives me also all .docx, .odt, .txt and so on (.xlsx, .ods and so on) files. This is not what I want, I need to filter only .gdoc and .gsheet files.

  • After doing some cursory testing, have you tried using a NOT operator in your search and exempt .xlsx, .docx, etc? For instance, type:document brings up Google Docs as well as .docx files. Using type:document NOT *.doc OR *.docx removed Word docs from the search results. – Brian Nov 24 '16 at 18:23
  • Thank you, this workaround worked. Just for amusement, I had to type these two commands: "type:spreadsheet NOT *.xlsx NOT *.xls NOT *.ods" and "type:document NOT *.docx NOT *.doc NOT *.pdf NOT *.txt NOT *.odt NOT *.bbl NOT *.blg NOT *.aux NOT *.snm NOT *.out NOT *.nav NOT *.tex NOT *.tcp NOT *.tps NOT *.ipe NOT *.svn-base NOT *.civBeyondSwordWBSave NOT *.spl NOT *.brf NOT *.vrb NOT *.pgn NOT *.ini". – Pudl Nov 24 '16 at 19:58
  • Use AND to group things. You can also sync Drive to your computer and then you can search by extension type. It just doesn't run that way on Drive because they're not actually documents. – Brian Nov 24 '16 at 20:46
5

There's an updated version of this now. You can search by apps, so you can just put:

app:"Google Sheets" 

And

app:"Google Docs" 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.