This guide is for the official Drive Explorer add-on. Install it to list, export, and audit Google Drive files and folders directly in your spreadsheet or browser.
If you have used Drive Explorer for quite sometime, you might have noticed that your custom sheet formatting is not persisted after Drive Explorer executes. To setup a consistent formatting of the sheet, select Extensions → Drive Explorer → Customize fields.
You can set custom title & width for the sheet columns, row height and font size, or enable word wrap for all columns.
Especially, this feature is helpful when you list your thumbnails as they look so small in the cells with the default config.

Install Drive Explorer from the Google Workspace Marketplace today and start exporting file metadata, folder sizes, and sharing permissions directly inside Google Sheets or on your browser.