'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Open SharePoint Files Directly in Excel for the Web
Question details
The user wants to open files stored in SharePoint directly through Excel for the web (excel.office.com) rather than viewing them within the default SharePoint interface.
- Product
- SharePoint / Excel for the Web
- Device & OS
- not provided
- Scenario
- Accessing and editing Excel spreadsheets stored in a SharePoint document library.
- Observed behavior
- Files open by default in the SharePoint file viewer interface, and the user prefers a direct excel.office.com URL routing behavior.
Ensure you have the necessary edit permissions for the SharePoint document library and that your Microsoft 365 account is fully logged into your browser.
Use the 'Open in Browser' Option within SharePoint
Since SharePoint natively controls the file URL routing, you must manually select the option to open the file in the dedicated Excel web interface.
Currently, SharePoint strictly manages file locations and their associated URLs. Because of this architecture, it cannot automatically replace its default viewing URL with an excel.office.com URL when you simply click a file name.
Navigate to your SharePoint Document Library and find the Excel file you want to open.
Right-click the file name, or click the three dots (Show actions) located next to the file.
Hover over 'Open' in the dropdown menu, then click 'Open in browser' or 'Open in Excel' to launch the file in the dedicated Excel interface instead of the SharePoint viewer.
Looking for a smoother spreadsheet experience? Try WPS Office
If you are frustrated by browser limitations and complex cloud file URLs, WPS Office provides a lightweight, highly compatible alternative to Microsoft Excel. Enjoy a seamless desktop experience for all your spreadsheet tasks without the hassle.
- 1. Download the software: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install and sign in: Run the installer, set up WPS Office on your device, and sign in to access free cloud storage and synchronization features.
- 3. Open your spreadsheets: Open your Excel files directly in WPS Spreadsheet for a seamless, fast, and secure editing experience.
Frequently Asked Questions
Can I make excel.office.com the default behavior for all SharePoint files?
No, currently SharePoint controls the default file URLs and routing. You cannot automatically force all files to bypass SharePoint's interface for excel.office.com upon clicking.
Why do my Excel files open in view-only mode in SharePoint?
This usually happens if you lack edit permissions, if the file is checked out by another user, or if it contains unsupported features. Use the 'Open in Desktop App' option to see if editing becomes available.
How do I force SharePoint to open Excel files in the desktop app by default?
You can change this in the document library settings. Go to the Gear icon > Library Settings > More library settings > Advanced Settings. Under 'Opening Document in the Browser', select 'Open in the client application' and save your changes.
