How to Display Excel Spreadsheet on SharePoint site


Display Excel Spreadsheet on Sharepoint Page

To display a Microsoft Excel Spreadsheet on SharePoint Site with its contents, you can make use of the File Viewer Web Part.

Steps:
  • Open SharePoint Page in edit mode,
  • Now click on the + icon in the section where you want to display the excel spreadsheet,
  • Now search for File Viewer and select it,
    File Viewer Web Part SharePoint
    File viewer SharePoint Site Web Part Widget
  • Click on Add File and select an Excel Spreadsheet that you want to embed,
  • You might see a message below just which you can select OK,

    Just checking...

    This item is from your OneDrive site. Files and folders in OneDrive are private unless you share them. Have you shared this file with your site members so they can access it?

  • The excel Spreadsheet will be embedded on the page, Republish to apply changes.

More Excel sheet display options

Click on the "Edit Web Part" icon to see extra options for embedding the spreadsheet.

Advance Options Embed Excel Spreadsheet Sharepoint Page

You can choose from the options available to display a chart, table, range, or the entire workbook.

When you choose the entire workbook, you can choose from the below options,

  • Show grid lines
  • Show row and column headers
  • Allow sorting and filtering columns

You will need to provide the chart/table name from the excel sheet if you go with the chart/table option.

The Range options is the one you may use if you want to display a specific section of the sheet. You will need to provide the below details,

  • Sheet name
  • Starting cell
  • Ending cell

If you provide an incorrect excel sheet name you will get an error - "Unable to display named item"

Error - Unable to Display Named Item
-


Have Questions? Post them here!

Topics Coverage:


🎉 We are celebrating the 10th years of Code2care! Thank you for all your support!

We strongly support Gender Equality & Diversity.

Follow Us: GitHub | Facebook | Twitter | Instagram