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.