How to Embed Excel Spreadsheet to Modern SharePoint Online Pages?
Requirement: Display Excel Spreadsheet in SharePoint Online.
SharePoint Online: How to Embed an Excel Spreadsheet?
We don’t have Excel Web Access Web Part in modern SharePoint Online sites that integrate an Excel sheet into SharePoint pages. However, we can use the Embed web part to display an Excel spreadsheet in SharePoint Online:
- Upload the Excel spreadsheet to SharePoint Online document library first.
- Open the Excel file in the Web browser (Excel Online) >> Click on File >> Share >> Embed.
- In the Embed window, choose the content from the Excel spreadsheet you want to show, such as a Table, Range of Cells, or full workbook. You can customize further by setting other preferences on the embed page. Copy the embed code generated once done.
- Now, navigate to your Modern SharePoint Online page where you would like to show the Excel file. Add an “Embed Web part” and paste the code you copied from the Excel web app.
- Save and Publish the page.
Now, you should see the Excel spreadsheet embedded in your modern SharePoint Online page. You can also customize the display of the embedded spreadsheet by adjusting the height and width of the web part and the layout of the page.
It’s worth noting that when you embed an Excel spreadsheet in a SharePoint Online page, it’s important to keep in mind that the spreadsheet will be publicly accessible to anyone who has access to the SharePoint page. Additionally, any changes made to the original spreadsheet will be reflected in the embedded version.
In summary, Embedding an Excel spreadsheet in a modern SharePoint Online page is a simple process that allows you to share your data in an interactive and dynamic way. By following the steps outlined in this article, you should be able to embed your Excel spreadsheet in your SharePoint Online pages easily.
I would like to be able to display and edit an Excel sheet from sharepoint, is this possible? I know I can view but being able to edit right from the screen would be ideal.
Other than the Online version of Office, I don’t find any other ways.
hello! how different is this compared to using File Viewer web part?
this is very helpful, except how do you refresh the embedded spreadsheet. i am making changes in the browser and the desktop app and not seeing them appear in the embedded version. i understand that i can not make & save changes via the embedded version. i’ve also tried refreshing the webpage and clicking the icon “Refresh all data connections”. eventually, i do see the changes, but it can take a long time.