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