How to Display Excel Spreadsheet on SharePoint site

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

  • Open SharePoint Page in edit mode,
  • Now click on the + icon in the section where you want to display the Microsoft 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
Display Excel Spreadsheet on Sharepoint Page

Facing issues? Have Questions? Post them here! I am happy to answer!

Author Info:

Rakesh (He/Him) has over 14+ years of experience in Web and Application development. He is the author of insightful How-To articles for Code2care.

Follow him on: X

You can also reach out to him via e-mail:

Copyright © Code2care 2024 | Privacy Policy | About Us | Contact Us | Sitemap