Using from a Google Sheet™
Drive Explorer Google Add-on
This guide is for the official Drive Explorer add-on. Install it to list and export OneDrive files and folder structures directly in your spreadsheet.
After installing the add-on, select Extensions → Drive Explorer for OneDrive → Launch.
- Select Authorize OneDrive to connect your OneDrive account.
- Authorize access to Onedrive Explorer on the page opened.
- Comeback to the sheet and select Pick from OneDrive.
- Select one or more folders on the OneDrive file picker and click on Choose.
- Now, the picked files should be listed on the sidebar.
- Select Fetch files to list the file details within the chosen folder(s) on the Google Sheet™.
Ready to list OneDrive files at spreadsheet speed?
Install Drive Explorer from the Google Workspace Marketplace today and start exporting OneDrive file metadata, folder structures, and details directly inside Google Sheets.