Body
Questions
- How can I get a list of SharePoint or OneDrive files that are shared with people outside my organization?
- Can I download a CSV report of externally shared items from a specific site?
- What information will the report include (file name, link type, guest email, permissions)?
Environment
This article applies to Microsoft 365 SharePoint Online and OneDrive for Business. It describes options for site owners and OneDrive owners to quickly export a list of items shared with external users.
Resolution
SharePoint site: Export “Shared with external users” (site owners)
Notes: This export lists only items shared with external users for that specific site. It does not include internal sharing or full permission inheritance details.
- Open the target SharePoint site in a browser.
- Select Site contents from the left navigation or the Settings gear menu.
- Choose Site usage (top-right of the Site contents page).
- Locate the “Shared with external users” card and select Download (CSV).
- Open the CSV. Typical columns include item name, URL, who it’s shared with (external emails), and permission type (view/edit/link).
OneDrive: Review and export items you shared externally (OneDrive owner)
Tips: External users will appear as guest accounts or non-company email addresses. “Anyone with the link” indicates anonymous access, which is external by nature.
- Go to OneDrive on the web and sign in.
- Select Shared in the left navigation.
- Open the Shared by you tab to see items you’ve shared.
- Use filters or search to locate items shared with external people (look for guest emails or “Anyone with the link”).
- If Export to Excel is available in your tenant, select items and export. Otherwise, open an item’s Details (the “i” pane) > Manage access to identify external recipients and record them.
Additional Help
If you need further assistance, you can chat with Bowdoin Bot of contact the Bowdoin College Service Desk by phone at (207) 725-3030 or in person at the Tech Hub in Smith Union.