Help & Support
Send Feedback
Files Cabinet by Awesome Table
Quickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in an Awesome Table view.
132,586 users
Works with
Install
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.
Please visit the Chrome Web Store if you would like to reply or rate a review for this app.
Reviews
A User of Files Cabinet by Awesome Table
July 11, 2019
Needed to get the links to 600+ sheets in a shared Drive folder. This add-on did the trick! I added the shared folder to my drive, ran the add-on, and then concatenated the first part of the shared url to the ID column that the add-on produced from the folder in my drive and voila: URLs to the sheets in the shared folder!
Submit reply
Cancel
A User of Files Cabinet by Awesome Table
April 13, 2019
It only lists folders in My Drive, not the ones synced to my devices. Since the device files are the vast majority of my work, it's really quite useless.
Submit reply
Cancel
A User of Files Cabinet by Awesome Table
July 24, 2018
doesn't work on shared drive - THEY COULD HAVE MENTIONED THAT BEFORE I INSTALLED. It doesn't appear on the list of Chrome Extensions so I don't know how to remove it.
Submit reply
Cancel
A user of Files Cabinet by Awesome Table
July 30, 2019
@Fritz: That's a pretty subtle "gotcha" (with a less-than-obvious solution), so thanks for the tip there!
A user of Files Cabinet by Awesome Table
June 20, 2019
You must go to the shared folder, right-click, tap Add to My Drive. Then the folder will appear in the list of folders in the sidebar.
A user of Files Cabinet by Awesome Table
March 1, 2019
It appears to work for me; however, should you wish to remove it: Open a Google Sheet Look under the Add-Ons dropdown Choose Manage Add-Ons Choose the Add-On in question Choose "manage" Choose "remove"
A User of Files Cabinet by Awesome Table
May 17, 2018
I prefer to list folder and files only not files inside folders
Submit reply
Cancel
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.
Submit reply
Cancel
A User of Files Cabinet by Awesome Table
December 21, 2017
Not working.
Submit reply
Cancel
Tabish Zaidi
July 12, 2017
I like what it CAN do. But There's no way to do listing for a folder in Team Drive folders as it doesn't allow shareable links for folders in Team Drives.
Submit reply
Cancel
A User of Files Cabinet by Awesome Table
April 18, 2017
When it works it's awesome...
Submit reply
Cancel
A User of Files Cabinet by Awesome Table
April 9, 2017
Really Helpful, I have tried many scripts for listing my Google Drive Files but none of them worked for me, Finally this Add-on Helps Me.
Submit reply
Cancel
Aaron Bannasch
January 10, 2017
This should be a function of Google Drive, but since it isn't I'm really glad Awesome Table created this!
Submit reply
Cancel
1-10 of 14
Additional information
Search
Clear search
Close search
Google apps
Main menu