How to Embed Excel in a SharePoint Page (Workbook, Chart or Range)

Megan Bowen, our sales lead in Boston, keeps the quarterly numbers in one Excel workbook. She wanted those numbers on the team’s SharePoint page, so nobody has to dig through a library to find them.

The File and media web part does this in a few minutes. The workbook stays in its library, and the page shows the latest saved version.

In this tutorial, I’ll show you how to embed excel in sharepoint page layouts, first the whole workbook and then a single chart, table or range.

Here’s what we’re building, a published page with the live Q4 sales workbook on it:

Before You Start

You need edit rights on the page, and readers need at least view access to the file. The workbook must live in a SharePoint document library or OneDrive, not on your PC.

My sample workbook, Regional Sales Q4 2026.xlsx, has a table named SalesTable and a column chart. These are the Q4 totals:

Region	Manager	Q4 2026 Total
Northeast	Megan Bowen	$163,850
Southeast	Alex Wilber	$137,050
Midwest	Adele Vance	$122,550
Southwest	Lee Gu	$111,850
West	Nestor Wilke	$179,250

Step 1: Upload the Workbook to a Library

1. Create a document library called ESP Excel Embed.
2. Select Create or upload, upload the workbook, or drag it onto the library.

I did the same with PnP PowerShell:

Connect-PnPOnline -Url "https://<tenant>.sharepoint.com/sites/EnjoySharePoint" -ClientId "<your-app-id>" -Interactive
New-PnPList -Title "ESP Excel Embed" -Url "ESPExcelEmbed" -Template DocumentLibrary
Add-PnPFile -Path "C:\SPGuidesDemo\ExcelEmbed\Regional Sales Q4 2026.xlsx" -Folder "ESPExcelEmbed"

Checkpoint: the library shows one file of about 15 KB.

Step 2: Add the File and Media Web Part

1. Open the page, or create one with New > Page, and select Edit.
2. Open the Toolbox on the right, or select the + sign on the page.
3. Search for file and select File and media.

Some Microsoft pages still call it File viewer. The File and media web part also shows Word, PowerPoint, PDF and video files, but not images.

Step 3: Pick the Workbook

1. In Pick a file, select Site and open the ESP Excel Embed library.
2. Select Regional Sales Q4 2026.xlsx, then select Select at the bottom.

Skip On this device for shared numbers. Microsoft stores that upload as a separate copy in Site Assets, so it won’t follow changes to the real file.

Checkpoint: the web part shows the Q4 Sales sheet with its sheet tabs. Select Republish.

Step 4: Show Only a Chart, Table or Range

On a busy home page, the whole workbook can be too much. The web part can show one piece of it.

1. Select the web part and choose Edit properties (the slider icon).
2. Change Entire workbook to Chart, Table or Range.
3. Type the item’s name. My chart is Chart 1, and the table is SalesTable.

Not sure of the name? Open the workbook in Excel, select the chart and read its name in the Name Box. For a table, check Table Name on the Table Design tab.

For the whole workbook, the pane also has Show grid lines, Show row and column headers and Allow sorting and filtering columns.

Checkpoint: only the chart appears. For list data, the Quick Chart web part is another option.

Test the Page

Change a December number in the workbook, save it and refresh the page. The new total should appear. If a colleague sees an error instead, they lack access to the file, much like the sharing is limited on this item error.

Make It Production-Ready

• Give readers view access to the library. They can’t edit the workbook on the page.
• Keep the workbook small. Microsoft caps embedded workbooks at 10 MB.
• Use table and chart names, so the view survives when rows move.
• Looking for Excel Web Access? It’s a classic web part and isn’t available on modern pages.

Where to Take It Next

For a full dashboard, build a Power BI report from SharePoint and Excel. If the rows belong in a list, import Excel data into a SharePoint list instead.

More ways to put content on your SharePoint pages:

• How to Embed a PowerPoint Presentation in a SharePoint Page (2 Ways)
• SharePoint Online Document Library Web Part (Complete Guide)
• How to Customize a SharePoint Site Home Page Using Out-of-the-Box Web Parts
• Power Automate Read Excel File From SharePoint

Frequently Asked Questions