Add more Metadata to the Sheet

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

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.

When you are not a premium user, Drive Explorer will only list the first 200 files it can find.
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.

8. Thumbnail Link

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

9. Folder Link

Link to acess the folder in the Google Drive Dashboard.

10. File Link

Link to acess the file in the Google Drive Dashboard.

11. Preview Link

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.

12. Direct Link

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

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.

24. Export PDF Link

Direct link to download the file in PDF format.

25. Export ePub Link

Direct link to download the file in ePub format.

26. Export CSV Link

Direct link to download the file in CSV format.

27. Export ZIP Link

Direct link to download the file in ZIP format.

28. Export DOCX Link

Direct link to download the file in DOCX format.

29. Export XLSX Link

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.