How to Display Excel Spreadsheet in SharePoint Online?

Recently, I was working on building a SharePoint Online site page that required displaying an Excel spreadsheet, allowing employees to view the data directly on the page rather than navigating to the document library and opening it.

After researching, I found two different web parts for displaying an Excel spreadsheet on a SharePoint site page:

• using Embed web part.
• using the File and Media web part.

In this tutorial, I will show you how to display an Excel spreadsheet on a SharePoint site using the two web parts mentioned above.

Note: In classic SharePoint sites, you can use the SharePoint page view web part to display an Excel spreadsheet.

Display Excel Spreadsheet in SharePoint Online Site Using Embed web part

Let’s start by implementing the display of the Excel spreadsheet on the SharePoint Online site page using the embed web part.

To do this, we first need to add an Excel file to the SharePoint document library, add it, and then follow the steps below to display the Excel file on the SharePoint site page.

1. Open the file in a browser -> Click on File at the top navigation -> Click on Share -> Click on Embed this workbook as shown below.

2. It opens the Embed window, as shown in the image below. Choose the context from Excel that you want to display, such as the entire spreadsheet or only the table, or specify the number of columns and rows you want to display.
3. Additionally, you can select other settings, such as Appearance, Interaction, and Dimensions. After updating the settings, copy the embed code.

4. Then, edit the SharePoint site page where you want to display the Excel spreadsheet, and click on the + icon, add the Embed web part.

5. Then, on the right-side properties, paste the embed code under the ‘Website address or embed code‘ section.

6. Then, save the changes and Republish the site page.
7. You can then see the Excel spreadsheet on the site page. You can turn off the ‘Resize to fit the page‘ setting if it takes up more space on the site page. Then, the Excel spreadsheet will be displayed as shown in the example below.

This way, we can embed the Excel spreadsheet in a SharePoint Online site page.

Read More: SharePoint List Title Column

Display Excel Spreadsheet in SharePoint Site Page Using File and Media Webpart

Let’s see how to utilize the File and Media web part to display the Excel spreadsheet on the site page.

1. Open the SharePoint site page where you want to display the Excel spreadsheet. Edit the site page, click on the + icon to add the web part ->Choose the File and Media web part.

2. Then, it will open a page to choose the Excel file. On the page, you can see many options to choose the file:
   • Recent
   • OneDrive
   • SIte
   • Upload
   • From a link
3. After choosing the file, click on the Insert button at the bottom, and it will add the Excel file to the page.

4. After adding the Excel spreadsheet to the site page, you can edit it to display only a particular table, the entire workbook, a range of items, a chart, or add a description to that web part, etc.

This way, we can add the Excel spreadsheet to the SharePoint Online site page using the File and Media web part.

In this tutorial, I have explained two different web parts for displaying an Excel spreadsheet on a SharePoint Online site page. Users can easily view the details directly on the page, and any updates or changes made to the file are reflected immediately on the sheet displayed on the page. Do let me know if this tutorial is helpful.

Also, you may like the following tutorials:

• SharePoint Text Web Part
• SharePoint Quick Links Web Part
• SharePoint Highlighted content web part
• SharePoint Online Code Snippet Web Part
• “Sharing is Limited on This Item” Error in SharePoint

Bijay Kumar

After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.