How to Open SharePoint Files in Excel and Edit Them

How-to basics · Updated November 20, 2026

To open a SharePoint workbook in Excel, find it in the document library, select the file, then choose Open > Open in app to use the desktop version, if that option is available. If you simply select the workbook, it will usually open in Excel for the web in your browser. You need permission to the file and, to use the desktop app, Excel installed and signed in with an account that can access the SharePoint site.

What You’ll Need

  • A work or school account with access to the SharePoint site and workbook. A link alone does not grant permission if the file is restricted.
  • A current web browser, such as Microsoft Edge or Chrome, for SharePoint and Excel for the web.
  • For the desktop route, the Excel desktop app installed and signed in with an account that has access to the file. Your organization may also need to allow Office files to open in desktop apps.
  • A stable internet connection for opening the SharePoint file and saving changes back to it. If your organization uses multifactor authentication, have your approved sign-in method available.

Step-by-Step

  1. Open the SharePoint site. Sign in to Microsoft 365 with the account that has access, then open the relevant SharePoint site. You can use the site address supplied by a colleague or find the site through your organization’s SharePoint home page. If you received a file link, open it in a browser and confirm that you are signed in to the correct account before continuing.
  2. Go to the document library. On the site, select Documents or the library name where the workbook is stored. If the site uses a customized navigation menu, the library may have a different name. Browse its folders, or use the library’s search box to locate the workbook by name. Check the folder path as well as the filename; several departments may keep files with similar names.
  3. Open the workbook in the browser if you want the simplest route. Select the Excel file, typically with an .xlsx or .xlsm extension. In most modern SharePoint libraries, this opens Excel for the web in a new browser tab. Wait for the workbook to load and check that the displayed filename and contents are the ones you expect. If selecting the file downloads it instead, do not assume the downloaded copy is connected to SharePoint; go back to the library and use its open options.
  4. Choose the desktop app when you need it. In the SharePoint library, select the workbook and look for Open > Open in app in the command bar. Depending on the library layout, the command may appear in the file’s three-dot menu or after you open the workbook in the browser. In Excel for the web, look for an option such as Open in Desktop App or Open in app; the exact placement can vary as Microsoft updates the interface. Approve the browser prompt to launch Excel if it appears.
  5. Confirm the correct account and location in Excel. When the desktop app starts, check that Excel is signed in with the same work or school account you used for SharePoint. The workbook should open from its SharePoint location, not just from a Downloads folder or another local folder. If Excel asks whether to open the file, verify the filename and choose the option to continue. If a sign-in window appears, complete it with the authorized account.
  6. Choose the editing mode you need. Excel for the web usually opens files for editing when you have permission, but you may see a read-only view if the file is locked or your access is limited. In the desktop app, use the displayed editing controls if the workbook opens in Protected View or read-only mode. Do not enable editing or macros unless you trust the file and its source. If your task only requires viewing, leave the workbook unchanged.
  7. Make a small check, then save or confirm autosave. In Excel for the web, changes are generally saved automatically to SharePoint; wait for the saving status to finish before closing the tab. In the desktop app, look for AutoSave and the save status near the top of the window. AutoSave may be unavailable for some file types, accounts, or configurations. If it is off, use File > Save and check that Excel finishes saving to the SharePoint location. Avoid closing the app while a save or sync is still in progress.

For Mac users, the SharePoint browser steps are much the same. The desktop option launches Excel for Mac if it is installed and associated with Microsoft 365. Browser wording and prompts can differ from Windows, and some Excel features differ between Mac, Windows, and the web. If a keyboard shortcut is needed, Windows commonly uses Ctrl+S to save; on Mac, use Command+S. For files that support AutoSave, check its status rather than relying only on a shortcut.

Common Mistakes

  • Choosing Download instead of Open in app. Download creates a separate local copy. Changes to that copy do not automatically update the SharePoint workbook. Use the library’s open command when you intend to edit the shared original.
  • Using the wrong Microsoft account. A personal account or a different work account may not have site access, even if Excel is already signed in. Check the account shown in the browser and the account shown in Excel.
  • Assuming every workbook opens the same way. Browser defaults, library settings, file type, and organization policies can affect whether a file opens in Excel for the web or the desktop app. Look for the available open command instead of expecting a particular behavior.
  • Closing before changes finish saving. A visible edit is not proof that it has reached SharePoint. Wait for the save status or AutoSave indication, especially after a large edit or when your connection is weak.
  • Editing a duplicate or a read-only file without noticing. Compare the filename and location, and check for a read-only message. If you need a separate version, use an approved copy workflow and make clear to collaborators which file is the working copy.

Tips

  • Use Excel for the web for quick shared edits. It avoids launching another app and makes it easy to work from a browser. Use the desktop app when you need a feature that is unavailable or limited in the web version, or when it better fits your workflow.
  • Keep the workbook in SharePoint while collaborating. Opening the same shared file allows eligible collaborators to work on it together, subject to the workbook’s features and permissions. Tell colleagues before making major structural changes, and avoid creating parallel copies unless there is a clear reason.
  • Use the library search and check the path. Searching by a distinctive part of the filename is often faster than opening folders one by one. Before editing, verify the library and folder so you do not change an archived or departmental copy by mistake.
  • Use Sync only if you need files in File Explorer or Finder. SharePoint’s Sync command can connect a document library to the OneDrive sync app. After it has synced, you can open the local synchronized file, but allow OneDrive to finish syncing before relying on changes from another device. Sync is not required just to open a workbook in Excel.
  • Be careful with macros and sensitive files. An .xlsm workbook may behave differently in Excel for the web, and browser editing does not run VBA macros. Use the desktop app if the workbook requires macros, and follow your organization’s security rules rather than enabling content from an untrusted source.

Troubleshooting

The workbook will not open or you see an access request. Confirm that you are signed in to the right work or school account, then reload the link. If access is still denied, ask the file owner or SharePoint site administrator to grant the appropriate permission. Do not try to bypass a restriction by downloading someone else’s copy.

Open in app is missing. Open the workbook first and check the available commands in Excel for the web, or select the file and inspect the library’s command bar and three-dot menu. If the option is still absent, your organization may have disabled desktop opening, or the file type or browser setup may not support that route. Try Excel for the web, or contact your Microsoft 365 support team about the policy.

The browser downloads the file instead. Check whether you selected Download rather than the file or its open command. Return to the SharePoint library and try opening the workbook there. If the browser continues to download it, check browser download behavior and ask your administrator whether the library is configured to open Office files in the browser or desktop app.

Excel opens but says the file is read-only. Check for a read-only banner, an active editing session, or a message that another person has locked the workbook. Ask collaborators to close it if appropriate, or ask the owner to confirm your permission. Some file formats and workbook settings limit browser editing; try the desktop app if you are authorized, but do not overwrite a separate copy and assume it updates the original.

Your edits are not appearing for others. Check that you edited the SharePoint-hosted file rather than a downloaded copy. Confirm the save or AutoSave status, reconnect to the internet, and allow time for OneDrive or Office to finish syncing if you are working from a synchronized folder. If Excel reports a conflict, compare the versions before choosing which changes to keep. For important changes, preserve a copy and contact the site owner or support team rather than repeatedly saving over conflicting work.

Frequently Asked Questions

Can I open a SharePoint Excel file without installing Excel?
Usually, yes. Open the workbook in a supported browser to use Excel for the web. Some features may work differently or be unavailable compared with the desktop app.

Does Open in app create a local copy?
It is intended to open the SharePoint-hosted workbook in the desktop app, not to download an unrelated working copy. Check the workbook’s location and save status in Excel. Using Download, by contrast, creates a separate file that may not sync back to SharePoint.

How do I make SharePoint files open in the desktop app by default?
Some libraries or organizations can set a preferred opening behavior, but the setting may be controlled by an administrator and its location can vary. If you do not see a default-app option in the library, use Open in app for individual files or ask your SharePoint administrator about the site’s configuration.

Can several people edit the workbook at once?
Often, yes, when the workbook is stored in SharePoint, users have edit permission, and the file and features support co-authoring. Excel for the web is a straightforward choice for simultaneous editing. If someone sees a lock or read-only message, check whether the file type, feature, or current editing session is limiting collaboration.

Why does my SharePoint link open in a browser instead of Excel?
That is a common default: selecting a workbook in SharePoint often opens Excel for the web. Use the available Open in app command to launch the desktop version. If the command is unavailable, the organization’s settings or your device configuration may limit desktop opening.

Can I open a SharePoint workbook on a Mac?
Yes. Open it in Excel for the web in a browser, or use the desktop-open command if Excel for Mac is installed and your account has access. The interface and available features may differ slightly from Windows.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.