SharePoint Document Issues

How to Open SharePoint Office Documents in Preview Mode by Default

Rana GarciaRana Garcia Oct 22, 2026 870 views

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.

How to Open SharePoint Office Documents in Preview Mode by Default
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Column Settings

Navigate to your SharePoint document library, click the dropdown arrow on the 'Name' column header, and select 'Column settings' followed by 'Format this column'.

2
Access the JSON Editor

In the formatting pane that appears on the right, click 'Advanced mode' at the bottom to switch to the JSON code editor.

3
Apply Custom Code

Paste a customized JSON script designed to append the preview web URL parameters to the file link, then click 'Save' to apply the changes.

Use JSON Formatting for the Name Column
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install the Software: Follow the simple on-screen instructions to install the lightweight suite on your device.
  3. 3. Open and Edit Files: Open your downloaded SharePoint documents directly in WPS Office for a seamless viewing and editing experience.
100% compatibility with Microsoft Word, Excel, and PowerPoint formatsTabbed interface for previewing and editing multiple files in one windowLightweight application that loads files instantly without browser lagFree essential editing tools for daily office tasks
microsoft office alternative - wps office

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.