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.
display excel sheet in SharePoint modern site
display excel sheet in sharepoint online
  • 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.
display excel sheet in sharepoint online
display excel sheet in sharepoint online using 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.

display excel spreadsheet in sharepoint
display excel spreadsheet in sharepoint
  • Now, you can see the excel sheet on the page of a SharePoint site.
  • Click on Republish.
display excel sheet in sharepoint online
display excel sheet in sharepoint online

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.
embed excel spreadsheet in sharepoint
embed excel spreadsheet in sharepoint
  • 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.
display excel document in sharepoint
display excel document in sharepoint
  • Here you will add the embed code on your excel work book.
display excel file in sharepoint web part
display excel file in sharepoint web part
  • 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.
display excel sheet in SharePoint modern site
display excel sheet in SharePoint modern site
  • Click on the File -> Share -> embed in Excel.
embed excel spreadsheet in sharepoint
embed excel spreadsheet in sharepoint
  • 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
display excel spreadsheet in sharepoint online
display excel spreadsheet in sharepoint online
  • Now you can see the excel workbook in the web part of your SharePoint site after pasting the embed code.
display excel spreadsheet in sharepoint
display excel spreadsheet in sharepoint
  • Click on the Republish.
embed excel spreadsheet in sharepoint
embed excel spreadsheet in sharepoint

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.
display excel spreadsheet in sharepoint 2013
display excel spreadsheet in sharepoint 2013
  • Navigate to Insert, In Part section click on the Web Part
display excel spreadsheet in sharepoint
display excel spreadsheet in sharepoint
  • Under Categories click on the Business Data, then under the Parts click on Excel Web Access. Click on Add.
how to display an excel sheet in sharepoint
how to display an excel sheet in sharepoint
  • Then click on Click here to open tool pane.
display excel spreadsheet in sharepoint 2013
display excel spreadsheet in sharepoint 2013
  • 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.
display excel sheet in sharepoint 2016
display excel sheet in sharepoint 2016
  • Named item box is optional, to display a single item, such as a chart, table, and pivot table, type the name of the item.
display excel sheet in sharepoint 2013
display excel sheet in sharepoint 2013
  • 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.
display excel file in sharepoint web part
display excel file in sharepoint web part
  • Then click on the Save icon on top right corner.
display excel file in sharepoint web part
display excel file in sharepoint web part

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.
display excel spreadsheet in sharepoint 2013
display excel spreadsheet in sharepoint 2013
  • 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.
display excel spreadsheet in sharepoint
display excel spreadsheet in sharepoint
  • 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.
display excel spreadsheet in sharepoint 2013
display excel spreadsheet in sharepoint 2013
  • Copy the link of excel sheet from the Document library of SharePoint site
display excel spreadsheet in sharepoint
display excel spreadsheet in sharepoint
  • Add the link under the Link section in Page viewer.
display excel sheet in sharepoint 2016
display excel sheet in sharepoint 2016
  • Click on OK to display the Excel spread sheet in SharePoint site.
display excel sheet in sharepoint 2013 online
display excel sheet in sharepoint 2013 online

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:

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
>