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.
Onedrive Explorer is an add-on that works on top of Google Sheet™. It lists your Microsoft OneDrive files in an easy to visualise tabular view on a Google Sheet.
Install Drive Explorer from the Google Workspace Marketplace today and start exporting OneDrive file metadata, folder structures, and details directly inside Google Sheets.