How to embed an Excel workbook on website

Question

It is possible to embed or publish an Excel sheet stored in a Sharepoint site into a public website?

I have a basic list of items for sale that I maintain in Excel, stored in OneDrive/SharePoint Site, that I want an up-to-date read-only view to be available on my website via iframe. I'm using Microsoft365 online apps. Office Windows computer apps are available if needed.

I have read this Microsoft Guide that seems exactly what I need, but it is out of date and does not work - many of the menu items are no longer available in Microsoft 365. The end result iframe page still prompts for SharePoint Online Sign In.

https://support.microsoft.com/en-us/office/embed-your-excel-workbook-on-your-web-page-or-blog-from-sharepoint-or-onedrive-for-business-7af74ce6-e8a0-48ac-ba3b-a1dd627b7773

I read that the "Everyone" group mentioned by the support.microsoft.com guide is now disabled by default in Microsoft365 and may be the cause of the 'sign in' requirement. I have attempted to re-instate it, but still have no luck in embedding an Excel sheet onto my webpage without requiring sign in.

https://docs.microsoft.com/en-US/office365/troubleshoot/access-management/grant-everyone-claim-to-external-users

Steps I have taken, following the above support.microsoft.com guide as closely as able.

1. re-enable "Everyone" group access for Sharepoint via Powershell https://docs.microsoft.com/en-US/office365/troubleshoot/access-management/grant-everyone-claim-to-external-users
2. create the Excel file in a Sharepoint Site
3. Manage Access in Sharepoint, add "Everyone" as Read only, untick the box "require sign-in" as per the support.microsoft.com guide.
4. share a link "anyone can view".

This creates a link URL to Excel Online that opens the sheet read-only.

What I need is the embedded version without the Excel ribbon...so:

5a) edit the link by appending with &action=embedview as per the support.microsoft.com link above. I structure this into an iframe as per the guide.

This still presents "SharePoint Online Sign In" before the sheet is visible on a webpage.

5b) Open the file in Excel online and file->share->embed.

This creates an embedded view / iframe with a URL of slightly different format, which creates an elegant table view with filter controls/no ribbon, but still requires Sharepoint Online sign in before it opens.

How do I embed an Excel view on a webpage without requiring sign-in? Thankyou.

Answer 1

Thankyou for your quick response Mia,

I have tried your method with varied results depending on which computer I view it from and when.

At home and at work (UK based) the embedded Excel is visible without signing in on the host website via the iframe.

However I open an Incognito Chrome window on the same computer at home and the 'sign in' prompt is visible.

https://snipboard.io/QH0U5e.jpg

I have asked colleagues around the world to try, and results vary - some can view the Excel fine, some are presented with 'sign in'.

I have been careful to create a new webpage and new iframe solely to test your method, to ensure it is not a caching issue, and can confirm via the page source that the iframe link is updated to the one you have helped me craft.

If we browse to the direct 'anyone can view' link when it is not embedded in an iframe, then it works on all computers.

I wonder therefore if it is some security filtering based on the viewer's IP / location that is causing SharePoint to prompt for Sign In when a document is embedded in an iframe?

I do not want to post the website and link publicly because the data is not proofed yet but I am happy to share via private message.

Thankyou for your help

Answer 2

Hi,

Appreciate your reply with the detailed test results.

It seems like the behavior is different/random from users in your organization and the iframe should have been worked correctly as some users will be able to view it without sign in.

In this situation, it is suggested to open a support ticket in Admin Center and contact the escalated engineers in that channel as they will have the support resources like collecting the logs from your side or having a remote session with you and the issue users' sides to further investigate the root cause of the behavior.

I'd like to share you any further help but really sorry that forum engineers here have no resources to access users' ends and collect the logs as it can be the most efficient way to investigate this kind of issue.

Appreciate your understanding and hope a nice day for you!

Best Regards,

Mia

Answer 3

I will open a support ticket.

Thankyou Mia, I am grateful for your replies

Kind regards

Answer 4

Hi,

Welcome to Microsoft Community.

Sorry about the not-updated screenshots in the official article, kindly check the detailed below from the tests I did just now.

1.Get the Anyone link for the workbook with Allow-edit button unchecked.

2.Open the workbook in Excel Online>click File>Share>Embed and copy the Embed code.

3.Delete the contents in src part and replace it with the Anyone link. You should get this

<iframe width="402" height="346" frameborder="0" scrolling="no" src="***The Anyone link from Step1*****&action=embedview&wdbipreview=true"></iframe>

The bold part need to add manually. Check this as a reference: Embed PDFs and documents to our site home page - Microsoft Community

If you follow the steps above but still get the same 'ask for sign in' issue, feel free to post back and share me a video about the issue behavior on you side. Also, ask if other users on you side will have the same issue even if he/she followed the above steps.

Have a nice day!

Best Regards,

Mia