How to display excel spreadsheet in SharePoint

In this SharePoint tutorial, we will discuss how to display excel spreadsheet in SharePoint. We will see how we can display excel spreadsheet in sharepoint online classic site as well as on modern site.

In the same way, we can also display excel sheet in sharepoint 2016 and embed excel spreadsheet in sharepoint 2019.

There are 4 different ways we can display an excel sheet in SharePoint.

1. By using File viewer web part
2. By using Embed code web part
3. By using Excel web access web part
4. By using Page viewer web part

Display Excel spreadsheet in SharePoint Online using File viewer web part

We can use the modern file viewer web part to display excel spreadsheet in sharepoint online modern sites. This web part is not available in SharePoint classic versions.

Even the File viewer web part we can use in SharePoint server 2019 modern sites to display excel spreadsheet in SharePoint 2019.

Follow the below steps to use file viewer web part to display excel sheet in SharePoint Online modern sites or SharePoint 2019 modern site.

• Open SharePoint Modern site page.
• Click on the edit link in the top right corner of the SharePoint site to edit the page, so that we can add the required web part.

• After that, you will see a plus sign on the header part or after each section. Click on the plus sign
• After that, a dialog will open, under Featured, click on the File viewer.

• Here it will ask us to select the excel spreadsheet from the below options.
  • Recent: Choose from the recent files.
  • OneDrive: You can even upload the files to OneDrive and choose from there. If your file is presented in OneDrive choose this option,
  • Site: When you choose Site, it will display the document libraries, from where you can choose the excel spreadsheet that you want to display on the SharePoint site.
  • Upload: It will allow you to upload the excel file from your local system. When you will upload the file, it will be saved in the SharePoint documents document library.
  • From a link: You can also provide the excel file link directly.

Here, I have save the file in the document library and choose from there.

• Now, you can see the excel sheet on the page of a SharePoint site.
• Click on Republish.

This is how we can display excel sheet in sharepoint online using the file viewer web part.

Display excel sheet in SharePoint online using Embed Code

Embed code is another SharePoint modern web part that we can use to display excel spreadsheet in SharePoint. The embed code web part is available in modern experience in SharePoint.

So we can use the embed code web part to embed excel spreadsheet in sharepoint online modern sites as well as in SharePoint server 2019 modern site.

Follow the below steps to use embed code web part to display excel document in SharePoint.

• Open SharePoint Modern site page, where you want to display the excel document.
• Click on the edit link in the top right corner to edit the page.

• After that, you will see a plus sign on the header part or after each section. Click on the plus sign
• After that, a dialog will open, under Featured, click on the Embed.

• Here you will add the embed code on your excel work book.

• To add embed code, let’s open the excel workbook that the book wants to add to the SharePoint site. for example details of the client excel workbook.

• Click on the File -> Share -> embed in Excel.

• In the Embed page, under what to show, you can select Entire Workbook, or else you can select a range that will show in your SharePoint site.
• Under Appearance, select the box you want.
• Under Interaction, choose how you want to allow people to interact with the workbook. If you allow sorting, filtering to the people, then people will be sort, filter, expand or collapse the table. If you want to specify a cell to be selected when your page opens, then check the Always start with this cell selected.
• Under Dimension, type the width and height for the viewer, in pixels. To see how it will look to the viewer click on the View actual size link
• Under Embed Code, copy the embed code and paste it under the website address or embed code

• Now you can see the excel workbook in the web part of your SharePoint site after pasting the embed code.

• Click on the Republish.

This is how we can display excel spreadsheet in sharepoint online using embed web part.

The embed web part is also available in classic SharePoint sites.

Display excel document in SharePoint using Excel web access web part

Let us see how to display an excel document using the SharePoint excel web access web part in SharePoint Online classic sites.

• Open SharePoint classic site.
• Click on the edit link in the top right corner of the SharePoint site.

• Navigate to Insert, In Part section click on the Web Part

• Under Categories click on the Business Data, then under the Parts click on Excel Web Access. Click on Add.

• Then click on Click here to open tool pane.

• In Excel web access, under Workbook display, next to Workbook specify the URL, if you don’t know the URL then click on the browse icon and select an excel workbook and click on Insert.

• Named item box is optional, to display a single item, such as a chart, table, and pivot table, type the name of the item.

• In the toolbar and title bar section, toolbar menu command section, navigation, and interactive section, select the features you want to display. Then click on Ok.

• Then click on the Save icon on top right corner.

This is how we can display excel spreadsheet in sharepoint 2013 or SharePoint 2016 or SharePoint Online classic sites using the Excel web access web part.

Display Excel Spreadsheet in SharePoint using page viewer web part

Now, let us see, how to display an excel sheet in SharePoint online or SharePoint 2013 or SharePoint 2016 classic site.

• Open SharePoint classic site page
• Click on the edit link in top right corner of the SharePoint site page.

• Navigate to Insert, then in the Parts section click on the Web Part
• Under Categories, click on the Media and Content.
• Under Parts, click on the Page Viewer.

• Click on Add to add the Page viewer web part.
• Click on the open the tool pane hypertext. Then type/paste the link of your Excel Spreadsheet.

• Copy the link of excel sheet from the Document library of SharePoint site

• Add the link under the Link section in Page viewer.

• Click on OK to display the Excel spread sheet in SharePoint site.

This is how we can display excel spreadsheet in SharePoint 2013 or we can also display excel spreadsheet in SharePoint 2016.

You may like the following SharePoint tutorials:

• What is a SharePoint site collection administrator?
• Grant user access to SharePoint site office 365
• How to allow anonymous read access to a SharePoint site?
• Move files from OneDrive for Business to SharePoint Online
• SharePoint usage reports

In this SharePoint tutorial, we learned different ways to display excel spreadsheet in sharepoint.

• How to display excel sheet in sharepoint online?
• Display excel spreadsheet in sharepoint 2013
• display excel spreadsheet in sharepoint 2010
• How to display excel sheet in sharepoint 2016
• How to embed excel spreadsheet in sharepoint
• How to display excel document in sharepoint Online modern site