Add more Metadata to the Sheet

By default, Drive Explorer fetches 8 different metadata to your sheet from the total of 37 available metadata. You can bring the metadata you need to the Google Sheet. Select Add-ons → Drive Explorer → Choose display fields and check all the data you want and click on Save.

drive explorer sheet columns dialog

Globel field list selection

By default, the fields you select will appear in all Google Sheets of your Google account. You can list different sets of fields in different Google Sheets by unchecking "Make the field list selection global".

List of all available metadata

1. Folder name

Name of the folder.

2. Folder Size

Value is N/A when files are selected instead of folders. The folder size you see on the sheet may not be accurate due to the following reasons.

  1. When you are not a premium user, Drive Explorer will only list the first 200 files it can find.
  2. Appscript has runtime limitations. Because of that, Drive Explorer may not have completed listing all the files.
To get accurate folder size results, please run Drive Explorer from Google Drive.

3. Folder Size in bytes

Folder size but in bytes. You will see a number in the cell.

4. Folder Path

Path of the file on the Drive. Eg: My Drive > Design Folder > Final Design.xcf.

5. Filename

Name of the file.

6. Description

Description of the file/folder.

7. Thumbnail

Thumbnail of the file if available. Useful for image files. Initially, thumbnails look small inside the sheet cells. Please use the Customize fields menu option to increase the height and width of the cells. Learn more.

Url of the thumbnail. It is the raw link of the image of thumbnail field.

Link to acess the folder in the Google Drive Dashboard.

Link to acess the file in the Google Drive Dashboard.

Preview link of the file, usually for images. Files will be loaded in the browser from this link. You can use this link in the src attribute of img element to display images on a webpage.

Keep in mind that for the link to work for anyone on the internet, the file must have been shared with anyone with the link.

Direct download link of the file. Defaults to PDF if applicable.

13. Share Status

General information about how the file has been shared with others.

14. File Size

Size of the file in readable format rounded off to two decimal places. Ex: 5.23 MB, 1.2 GB.

15. File Size in bytes

File size but in bytes. You will see a number in the cell.

16. Owner

E-mail address of the owner of the file.

17. Viewers

Comma separated e-mail addresses of people who have view access to the file.

18. Commenters

Comma separated e-mail addresses of people who have comment access to the file.

19. Editors

Comma separated e-mail addresses of people who have edit access to the file.

20. Created At

The time at which the file was created.

21. Created At Custom

No of days since December 30, 1899. You will see numbers in this column. Please custom format this column using Google Sheet's Format → Number feature.

22. Last Modified At

The time at which the file was last modified.

23. Last Modified At Custom

No of days since December 30, 1899. You will see numbers in this column. Please custom format this column using Google Sheet's Format → Number feature.

Direct link to download the file in PDF format.

Direct link to download the file in ePub format.

Direct link to download the file in CSV format.

Direct link to download the file in ZIP format.

Direct link to download the file in DOCX format.

Direct link to download the file in XLSX format.

30. Filetype

Type of the file. For eg: Google Docs.

31. Width

Populated for image & video files width in pixels.

32. Height

Populated for image & video files height in pixels.

33. Video Duration

Populated for video files duration in seconds.

34. File Extension

Extension of the file.

35. Custom Metadata 1

You can add your own custom data in this field. Refer to custom metadata section.

36. Custom Metadata 2

Similar to custom metadata 1 mentioned above.

37. Custom Metadata 3

Similar to custom metadata 1 mentioned above.