How to Open SharePoint Office Documents in Preview Mode by Default
Question details
The user wants to configure SharePoint document libraries to open Microsoft Office files (like Word and Excel) in preview mode by default, similar to how PDF files are handled.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Viewing and managing files directly within a SharePoint document library.
- Observed behavior
- PDF files automatically open in preview mode, whereas Word and Excel documents default to opening in their respective Office web applications for editing.
Determine whether you need preview mode specifically to read the content without modifying it, or if you simply want to edit the file's metadata without launching the full web application.
Use JSON Formatting for the Name Column
Since SharePoint lacks a native global setting, you can apply custom JSON code to the Name column to alter the default click behavior.
JSON column formatting allows administrators and site owners to customize how fields are displayed and how their links behave. By modifying the Name column, you can force the hyperlink to route through SharePoint's built-in file viewer instead of the Office web app.
Navigate to your SharePoint document library, click the dropdown arrow on the 'Name' column header, and select 'Column settings' followed by 'Format this column'.
In the formatting pane that appears on the right, click 'Advanced mode' at the bottom to switch to the JSON code editor.
Paste a customized JSON script designed to append the preview web URL parameters to the file link, then click 'Save' to apply the changes.

Edit Metadata Without Opening Files
Use SharePoint's built-in quick edit features if your goal is to update file properties without launching Word or Excel online.
Try WPS Office for Lightweight Document Management
If SharePoint's strict file opening defaults disrupt your workflow, consider handling your local and cloud documents with WPS Office. As a free, lightweight alternative, it gives you complete control over viewing and editing Office documents offline and online.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Follow the simple on-screen instructions to install the lightweight suite on your device.
- 3. Open and Edit Files: Open your downloaded SharePoint documents directly in WPS Office for a seamless viewing and editing experience.

Frequently Asked Questions
Can I configure SharePoint to open documents in the desktop app by default?
Yes. Navigate to Library Settings > Advanced settings. Under the 'Opening Document in the Browser' section, change the default behavior from 'Open in the browser' to 'Open in the client application'.
Why do PDFs open in preview mode but Word files do not?
SharePoint handles file types based on available web apps. Because Microsoft 365 includes native web applications for Word, Excel, and PowerPoint, it prioritizes opening those files for immediate editing. Lacking a native web editor for PDFs, it defaults to the read-only file viewer.
Will JSON formatting change my document permissions?
No. Applying JSON formatting to a column only alters the visual presentation and hyperlink behavior within the browser. It does not affect underlying site permissions, file security, or sharing settings.




