How to Find Documents Opened by Users in Microsoft 365
Question details
The user needs to find the specific names and locations of individual files that a particular user has accessed, edited, downloaded, or shared in Microsoft 365.

- Product
- Microsoft 365
- Device & OS
- not provided
- Scenario
- Tracking detailed user activity and document access for compliance, security, or administrative monitoring purposes.
- Observed behavior
- Standard Microsoft 365 usage reports only provide aggregated totals of activities, failing to display the exact names and locations of the individual files involved.
Ensure that you have administrator permissions (such as Global Administrator or Compliance Administrator) and that auditing is actively turned on for your Microsoft 365 organization.
Search the Audit Log in the Microsoft Purview Portal
Use the audit log search feature within the Microsoft Purview portal to generate a detailed report of individual file access and sharing events.
The Microsoft Purview audit log is the central tool for tracking user and administrator activity across your Microsoft 365 environment. By querying the audit log, administrators can pinpoint exactly which documents were opened, modified, or downloaded by a specific user.
Log in to the Microsoft Purview compliance portal using your administrator credentials.
In the left navigation pane, scroll down and select 'Audit' to access the audit log search interface.
Set the Start date and End date for your search. Click the 'Activities' dropdown and select specific events such as 'Accessed file', 'Modified file', or 'Downloaded file' under the SharePoint and OneDrive workloads.
In the 'Users' field, type the name or email address of the specific user whose document activity you want to investigate.
Click the 'Search' button. Once the results are generated, you can click 'Export' to download the data as a CSV file, which will contain the detailed names and URL locations of the opened documents.

Manage Your Documents Effectively with WPS Office
While Microsoft 365 provides complex enterprise-level audit trails, individual professionals and small teams often need a simpler, cost-effective solution for daily document creation and management. WPS Office offers a lightweight, highly compatible alternative with built-in cloud synchronization and easy file history tracking.
- 1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
- 2. Sign In for Cloud Features: Create or sign in to your WPS account to enable cloud backup and track your recent document history.
- 3. Open and Edit Seamlessly: Open your existing Microsoft Office documents directly in WPS Office to view, edit, and manage them without formatting issues.

Frequently Asked Questions
Can standard users see who opened their documents in Microsoft 365?
Standard users can see basic view counts and activity on files they own in OneDrive or SharePoint by checking the file's details pane or 'Manage Access' section. However, running a comprehensive audit search for specific file activity across the organization requires administrator permissions.
Why are some document activities missing from my Microsoft 365 audit log?
Activities may be missing if audit logging was not enabled for your organization prior to the event, if the activity occurred outside your subscription's data retention period (usually 90 to 180 days), or if the specific activity type was not selected in the search criteria.
Does the standard Microsoft 365 usage report show individual file names?
No, standard usage reports in the Microsoft 365 admin center only provide aggregated data and totals for user activity (e.g., total files viewed or edited). To see individual file names and exact locations, administrators must use the Purview audit log.




