Others

How to Display Microsoft Lists Data on a Website

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to display a news section populated by Microsoft Lists data on an external website and is looking for supported methods to publish or retrieve this data.

Product: Microsoft Lists
Device & OS: not provided
Scenario: Integrating and displaying dynamic or static list data on a public-facing or external website.
Observed behavior: Seeking proper configurations, web parts, or API methods to successfully embed or retrieve list data externally.

Before you start

Determine whether your target website is an internal SharePoint page or an external site, and clarify if you need live data updates or if static data is sufficient.

Solution 1Recommended

Use Microsoft Graph API for External Websites

Retrieve live list data dynamically for non-SharePoint external websites using Graph API.

For external websites, directly embedding a list is often restricted by security policies. The most robust method for live updates is retrieving the data dynamically using the Microsoft Graph API.

Register Your Application

Register your web application in Azure Active Directory (Entra ID) to obtain the necessary Client ID and setup authentication.

Configure API Permissions

Assign the appropriate Microsoft Graph API permissions, such as 'Sites.Read.All', to allow your application to read list items.

Fetch and Display Data

Make HTTP GET requests to the Graph API endpoints targeting your specific Microsoft List, parse the JSON response, and render the live data on your website's front-end.

Development Knowledge Required: This method requires web development experience to handle API requests, authentication tokens, and frontend data rendering.

Solution 2

Use the SharePoint List Web Part

Easily display list data if your target website is hosted within the SharePoint environment.

Solution 3

Export List Data to Excel for Static Display

Export the list to an Excel spreadsheet if you only need a static snapshot of the data without live updates.

Free Microsoft Office alternative

Analyze and Manage Exported List Data with WPS Office

If you choose to export your Microsoft Lists to Excel for static website display, WPS Office provides a free, lightweight, and highly compatible alternative to process, format, and visualize your spreadsheet data seamlessly.

1. Download WPS Office: Get the free WPS Office suite from the official website and install it on your device.
2. Open WPS Spreadsheet: Launch the application and select the Spreadsheet module from the main dashboard.
3. Format Your List Data: Open your exported Microsoft Lists Excel file to format, analyze, and prepare your static data for website display.

100% compatible with Microsoft Excel (.xlsx) and CSV formatsLightweight application with exceptionally fast launch timesFamiliar user interface requiring no steep learning curveBuilt-in formatting tools to easily prepare your list data for web embedding

microsoft office alternative - wps office

Frequently Asked Questions

Can I embed a Microsoft List directly onto an external website using an iframe?

Directly embedding Microsoft Lists via an iframe on external, non-SharePoint websites is generally blocked by cross-origin security policies. You should use the Microsoft Graph API or a public Power Apps portal to pass and display the data securely.

Does exporting a Microsoft List to Excel provide live updates on my website?

No, exporting a list to Excel only creates a static snapshot of the data at that specific moment. If the original list is updated, you will need to manually re-export the data or switch to dynamic methods like the Graph API.

Can I use Power Apps to display list data externally?

Yes, you can build a Power Apps portal or a canvas app that is connected to your Microsoft List. You can then configure external access or embed that specific app to display the required data to your website visitors.

Office Quick Solutions