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?

Microsoft SharePoint offers seamless integration with Microsoft Excel, allowing you to embed spreadsheets directly within SharePoint pages. This enhances collaboration, as any changes made to the Excel file automatically reflect in SharePoint in near real-time. Users do not need Excel installed on their systems to work with embedded files either. In this comprehensive guide, we will go through the steps to embed Excel workbooks hosted in SharePoint document libraries or OneDrive into SharePoint Online pages.

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:

  1. Upload the Excel spreadsheet to the SharePoint Online document library first. 
  2. Open the Excel file in the Web browser (Excel Online) >> Click on File >> Share >> Embed.embed excelsheet in sharepoint online
  3. 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 by setting the respective checkboxes on the embed page. Copy the embed code generated once done.How to display excel spreadsheet in sharepoint online modern page
  4. 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.embed web part sharepoint online
  5. Save and Publish the page.

Now, you should see the Excel spreadsheet embedded in the SharePoint Online page. As users interact with the embedded document, the changes also take effect in the source Excel file stored in the document library. 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.

Here is a sample iframe code to embed an Excel file in the SharePoint site web page:

<iframe width="402" height="346" frameborder="0" scrolling="no" src="https://crescent.sharepoint.com/sites/Retail/_layouts/15/Doc.aspx?sourcedoc={27fdefa1-1b27-4c36-a429-f55da8c42d9d}&action=embedview&wdAllowInteractivity=False&wdHideGridlines=True&wdHideHeaders=True&wdDownloadButton=True&wdInConfigurator=True&wdInConfigurator=True"></iframe>

Refer to this Microsoft Documentation for further help in setting parameters to the HTML iframe code.

It’s worth noting that you must set the permissions for the underlying Excel Workbook on the SharePoint library, before embedding to a page (Grant “Read” access to “Everyone”). Also, 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.

Summary

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. Powerful capabilities like Excel embedding will enable the creation of interactive, engaging pages with live spreadsheets in SharePoint Online. It facilitates collaboration on Excel without relying on attachments or downloads. By following the steps outlined in this article, you should be able to embed your Excel spreadsheet in your SharePoint Online pages easily.

Salaudeen Rajack

Salaudeen Rajack - Information Technology Expert with Two-decades of hands-on experience, specializing in SharePoint, PowerShell, Microsoft 365, and related products. He has held various positions including SharePoint Architect, Administrator, Developer and consultant, has helped many organizations to implement and optimize SharePoint solutions. Known for his deep technical expertise, He's passionate about sharing the knowledge and insights to help others, through the real-world articles!

10 thoughts on “How to Embed Excel Spreadsheet to Modern SharePoint Online Pages?

  • Thanks very much. The directions are clear and worked perfectly.

    Reply
  • When I do this, no matter if I only select a certain range, the user still has the option inside sharepoint to view the entire workbook from clicking the very bottom right button to see the whole book. Is there a way to only share what is selected and make any other part of the workbook not visible?

    Reply
  • This is very cool! But, I would like to share a chart from within an Excel sheet on a public website. Can I make this available somehow, without visitors having to login first? Tried it in OneDrive instead, but still the same Problem.

    Reply
    • Sorry, I did get it working publicly on some devices 😃, although every browser seems to behave a bit different. It works on Firefox and Edge on Windows 10/11 (including sandboxes of each of these), MacOS Safari, but unfortunately still showing Microsoft login button on iPad, iPhone (Safari) and Samsung phone. Any idea anyone?

      It would also be nice, if I could get rid of the Excel bar below the chart.

      Reply
  • Thanks!.. It was very helpful.. but I have a question.
    Can we lock the user from scrolling up or down?
    I mean after I import Excel into modern SharePoint and set the height and width, can I lock the height and width so the user can’t scroll down in my excel

    Reply
  • Thank you! This is exactly what I was looking for!

    Reply
  • 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.

    Reply
  • hello! how different is this compared to using File Viewer web part?

    Reply
  • 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.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *