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:

  1. Upload the Excel spreadsheet to 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 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 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.

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!

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

  • 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 *