Compliance Problems

How to Find Documents Opened by Users in Microsoft 365

John WilsonJohn Wilson Nov 3, 2026 870 views

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.

How to Find Documents Opened by Users 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.
Before you start

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.

Solution 1Recommended

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.

1
Sign in to Microsoft Purview

Log in to the Microsoft Purview compliance portal using your administrator credentials.

2
Open the Audit Tool

In the left navigation pane, scroll down and select 'Audit' to access the audit log search interface.

3
Configure Date and Activities

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.

4
Filter by Specific User

In the 'Users' field, type the name or email address of the specific user whose document activity you want to investigate.

5
Run Search and Export

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.

Search the Audit Log in the Microsoft Purview Portal
Audit Data Retention: Audit records are only retained for a specific duration based on your organization's licensing (typically 90 or 180 days). Ensure you perform your search within this retention window.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download the free installation package for your operating system.
  2. 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. 3. Open and Edit Seamlessly: Open your existing Microsoft Office documents directly in WPS Office to view, edit, and manage them without formatting issues.
Highly compatible with Microsoft Office formats including Word, Excel, and PowerPoint files.Lightweight application that runs smoothly on Windows, Mac, Linux, iOS, and Android.Built-in file history and cloud synchronization for easy personal document tracking.Free to use with a familiar, tabbed user interface ensuring seamless transition.
microsoft office alternative - wps office

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.