Add more Metadata to the Sheet

By default, Drive Explorer fetches 8 different metadata to your sheet from the total of 34 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

List of all available metadata

1. Folder name

Name of the folder.

2. Folder Path

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

3. Filename

Name of the file.

4. Description

Description of the file/folder.

5. 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.

11. Share Status

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

12. File Size

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

13. Owner

E-mail address of the owner of the file.

14. Viewers

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

15. Commenters

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

16. Editors

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

17. Created At

The time at which the file was created.

18. 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.

19. Last Modified At

The time at which the file was last modified.

20. 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.

27. Filetype

Type of the file. For eg: Google Docs.

28. Width

Populated for image & video files width in pixels.

29. Height

Populated for image & video files height in pixels.

30. Video Duration

Populated for video files duration in seconds.

31. File Extension

Extension of the file.

32. Custom Metadata 1

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

33. Custom Metadata 2

Similar to custom metadata 1 mentioned above.

34. Custom Metadata 3

Similar to custom metadata 1 mentioned above.