Quickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in an Awesome Table view.
Listing updated:March 19, 2024
Works with:
695K+
Overview
Files Cabinet by Awesome Table is an add-on that helps you list a Google Drive folder. It explores every child folder and lists every file that can be found. After giving you a quick count of all the folders and all the files, you get a list of the files that are ready to be displayed in a catalog created with Awesome Table.

SAVE METADATA

You can also add some meta-data on the sheet (by adding a column at the end of the sheet). Files Cabinet will match entries and keep the data you entered. It can be very useful if: 
- You're working with collaborators on a folder and want to keep track of what file is completed, and what has to be finished
- You're displaying an album of your holidays, and want to know who's on the pictures: simply add a "People" column at the end of the sheet, and fill it with the names of people appearing on the pictures. After updating the list, the column will still match the entries.
- You're displaying your music library, stored in Google Drive, and want to give a rating to every track or to display the cover of the album. Update the list, these information will remain on the sheet and in the Awesome Table view.

DISPLAY YOUR FILES IN A CATALOG WITH AWESOME TABLE

Files Cabinet automatically creates an Awesome Table view that uses a template and a custom css (example here: https://goo.gl/hyqYRi). But if you're into customization, just give a quick look at the Awesome Table documentation (https://goo.gl/uf6v7a) and set your imagination free!

BUILT TO BE ROBUST

Even if you have a huge Google Drive, Files Cabinet will find its way. It can list thousands of files and is only limited to the size of the spreadsheet (two million cells) - which means up to 100 000 files! Just leave the sidebar open and wait for the spreadsheet to be filled. If you have a bigger Drive, and wish to list it, feel free to contact us.

Files Cabinet does not keep neither use any of your data after they were listed.
Additional information
PricingNot available
Developer
Privacy policy
Terms of service
Files Cabinet by Awesome Table will ask for the permissions shown below. Learn more
Files Cabinet by Awesome Table will need access to your Google account
This will allow Files Cabinet by Awesome Table to :
See information about your Google Drive files
See and download all your Google Drive files
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Allow this application to run when you are not present
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
View the activity history of your Google apps
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Chuckle Duck
May 25, 2023
Saved me likely hours of work, love it!
Is this review helpful?
Yes
No
Profile Picture
Jay Chong Yen Jye (iamJayChong)
October 11, 2022
I don't understand. I followed the instructions and I never able to copy the template. Is it restricted for free plan? So un-paid user can't try anymore?
Is this review helpful?
Yes
No
Profile Picture
Yorick van de Water
March 5, 2021
I take back what I said in my earlier review (included below), even after uninstalling, things are still being messed up, I don't know what's going on, but this add-on went from fantastic, doing what I want to undoing my past work even when it's uninstalled, I don't understand if it's sheets or what's going on, but this app is haunting me, creating hidden sheets left and right and overwriting data in my existing sheets... Old: I've been using it for months, it's always worked great until yesterday when it suddenly started overwriting Google Sheets I didn't even have open, it was making edits every minute, completely erasing edits I had made... I had to uninstall it to get it to stop, but I have no better option than this tool, so I need to install it, use it, and then uninstall it each time I need it now, otherwise it erases my sheets...
Is this review helpful?
Yes
No
Profile Picture
David Landry
August 5, 2021
Love this Add-On. Fit exactly what I was trying to do and support was very helpful the one time I reached out.
Is this review helpful?
Yes
No
Profile Picture
Yank
November 6, 2022
Worthwhile
Is this review helpful?
Yes
No
Profile Picture
MOONLITE 002
August 28, 2020
Good application so far. The only problem is file size converted to Kb, Mb, or Gb, and their size + unit size combined in 1 cell like 1kb or 2gb, so it cant be used for counting as it is. So could this application revised by adding 1 column for size in bytes? Only number without unit size like bytes or b or something?
Is this review helpful?
Yes
No
Profile Picture
Alex Rebelo
January 18, 2021
Works fine, but for large/many files it is quite slow. But still best option I've come across.
Is this review helpful?
Yes
No
Profile Picture
A User of Files Cabinet by Awesome Table
January 20, 2018
I like it, as it does easily what several scrpts also do (less easily). I really don't understand why folder names are included in the list as it would really help creating a complete list using the "type" data.
Is this review helpful?
Yes
No
Profile Picture
Michael Spiess
December 15, 2020
Works ok but lack of a folder path doesn't help much when you have sub folders with the same name (ex. year). It would help to list folders. Seems like this tool is most helpful for large file collections and having the ability to see the folder tree is important. Also it doesn't allow you to choose the root of a shared folder.
Is this review helpful?
Yes
No
Profile Picture
A User of Files Cabinet by Awesome Table
January 29, 2020
Great idea, perfect embodiment. For some reason, the "Create a new sheet for a list of files" mode does not work for me. Exporting to an existing worksheet works fine. Thanks!
Is this review helpful?
Yes
No
1-10 of 35
Search
Clear search
Close search
Google apps
Main menu