List SharePoint or OneDrive Files Shared with External Users

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)?
  • How do I see which of my OneDrive files are shared with guests?
  • How do I find files shared with "Anyone with the link"?

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)

  1. Open the target SharePoint site in a browser.
  2. Select Site contents from the left navigation or the Settings gear menu.
  3. Choose Site usage (top-right of the Site contents page).
  4. Locate the Shared with external users card and select Download (CSV).
  5. Open the CSV. Typical columns include item name, URL, who it is shared with (external emails), and permission type (view, edit, or link).
Note: This export lists only items shared with external users for that specific site. It does not include internal sharing or full permission inheritance details.

OneDrive: review and export items you shared externally (OneDrive owner)

  1. Go to OneDrive on the web and sign in.
  2. Select Shared in the left navigation.
  3. Open the Shared by you tab to see items you have shared.
  4. Use filters or search to locate items shared with external people (look for guest emails or "Anyone with the link").
  5. If Export to Excel is available in your tenant, select items and export. Otherwise, open an item's Details pane (the "i" icon) and choose Manage access to identify external recipients and record them.
Tip: External users appear as guest accounts or non-company email addresses. "Anyone with the link" indicates anonymous access, which is external by nature.

Additional Help

If you need further assistance, you have several options:

  • Bowdoin Bot: Chat with Bowdoin Bot directly from any KB page for instant answers.
  • Phone: Call the Bowdoin College Service Desk at (207) 725-3030.
  • In person: Visit the Tech Hub in Smith Union during business hours.
  • Submit a ticket: Request assistance through the Service Catalog.
Print Article

Related Articles (1)

Extend or Remove Guest Access in OneDrive and Teams
Explains how content owners can review external guest access to OneDrive files and Microsoft Teams, which expires after 180 days at Bowdoin. Covers extending or removing access from the My Access portal, removing a guest directly in Teams, and changing or ending sharing for OneDrive files and folders. Applies to Bowdoin faculty, staff, and students who own shared content or a Microsoft Team.