How To Add Excel Sheet To SharePoint Page

Adding an Excel sheet to a SharePoint page can enhance collaboration and increase productivity for your team. There are two methods you can use to achieve this: using the Embed web part in SharePoint Online and publishing the workbook to SharePoint.

To use the Embed web part in SharePoint Online, start by uploading the Excel spreadsheet to a SharePoint Online document library. Then, open the Excel file in the web browser (Excel Online) and click on File, Share, and Embed. In the Embed window, select the content you want to display from the Excel spreadsheet and customize your preferences. Copy the embed code and navigate to your SharePoint page. Add an “Embed Web part” and paste the code. Save and publish the page to see the Excel spreadsheet embedded within your SharePoint page.

It’s important to note that the embedded spreadsheet will be publicly accessible to anyone who has access to the SharePoint page, and any changes made to the original spreadsheet will be reflected in the embedded version.

Alternatively, you can publish the workbook to SharePoint. Select the Save As option, choose SharePoint as the destination, and browse to the folder where you want to publish the workbook. You can select specific worksheets or items to publish and add defined names as parameters. After saving the workbook, you can grab the URL to the public workbook and specify additional parameters for desired presentation.

However, there are limitations to consider. The maximum workbook size is 10 megabytes, and there is a maximum limit of 1000 concurrent viewers for the published workbook. Keep these constraints in mind while choosing the appropriate method to add an Excel sheet to your SharePoint page.

How to use the Embed web part in SharePoint Online

The Embed web part in SharePoint Online allows you to seamlessly integrate an Excel spreadsheet into your SharePoint page. To get started, follow these steps:

1. Upload the Excel spreadsheet to a SharePoint Online document library. Make sure the file is saved in a compatible format.

2. Open the Excel file in the web browser using Excel Online. Click on “File,” then “Share,” and finally “Embed.”

3. In the Embed window, choose the content you want to show from the Excel spreadsheet. You can select specific data or entire sheets.

4. Customize the preferences, such as the size of the embedded spreadsheet and whether to show the toolbar or not.

5. Copy the embed code provided in the Embed window.

6. Navigate to your SharePoint page where you want to add the Excel spreadsheet.

7. Add an “Embed Web part” to the page and paste the copied embed code into the appropriate field.

8. Save and publish the page to see the Excel spreadsheet embedded on the SharePoint page.

It’s important to note that the embedded spreadsheet will be publicly accessible to anyone who has access to the SharePoint page. Any changes made to the original spreadsheet will be reflected in the embedded version as well.

Alternatively, you can also publish the workbook to SharePoint. Simply select the “Save As” option in Excel, choose SharePoint as the destination, and specify the folder where you want to publish the workbook. You can select specific worksheets or items to publish and add defined names as parameters. After saving the workbook, you can grab the URL to the public workbook and specify additional parameters depending on the desired presentation.

However, it’s important to consider the limitations of publishing workbooks to SharePoint. The maximum size of a workbook is 10 megabytes, and there is a maximum limit of 1000 concurrent viewers.

Meet the Author

Abdul Rahim has been working in Information Technology for over two decades. Learn how Abdul got his start as a Tech Blogger , and why he decided to start this Software blog. If you want to send Abdul a quick message, then visit his contact page here.