File Sharing Problems

Can a Microsoft List Be Shared with the General Public?

Amos Gikunda Oct 10, 2026 869 views

Question details

The user is trying to find out if it is possible to share a Microsoft List or SharePoint Online list with the general public for anonymous viewing and filtering.

Can a Microsoft List Be Shared with the General Public?

Product: Microsoft Lists / SharePoint Online
Device & OS: not provided
Scenario: Attempting to grant anonymous public access to an entire Microsoft List without requiring external users to sign in.
Observed behavior: Microsoft Lists and SharePoint Online do not natively support anonymous public viewing for entire lists; access typically requires sign-in based on tenant policies.

Before you start

Before attempting to share any internal data externally, confirm with your IT administrator that your organization's SharePoint tenant policies permit external or anonymous sharing.

Solution 1Recommended

Share Individual List Items Using Anonymous Links

While entire lists cannot be shared publicly, you may be able to share individual list items using an 'Anyone with the link' setting if your tenant allows it.

By default, out-of-the-box Microsoft Lists do not support publishing the full list for anonymous access. However, item-level sharing can often bypass the need for external users to log in, provided your SharePoint administrator has enabled this feature.

Open your Microsoft List

Navigate to Microsoft Lists or your SharePoint Online site and open the specific list containing the items you wish to share.

Select the list item

Hover over the individual item you want to share, and click the 'Share' icon (an arrow pointing right) that appears next to the title.

Adjust sharing permissions

In the sharing dialogue box, click the gear icon or current permission level, and select 'Anyone with the link'. If this is greyed out, your organization has disabled anonymous sharing.

Copy and distribute the link

Click 'Apply', then click 'Copy link'. You can now share this URL with the general public for anonymous viewing of that specific item.

Share Individual List Items Using Anonymous Links

Limitation Note: This method only shares individual records. To request full public list support, submit a feature request through Microsoft's official feedback portals.

Solution 2

Export List Data to Excel for Public Sharing

Since live public lists are not natively supported, the best workaround is to export your data to an Excel spreadsheet and share that file publicly.

Free Microsoft Office alternative

Easily Manage and Share Spreadsheets with WPS Office

If Microsoft's restrictive tenant policies make data sharing difficult, consider using WPS Office. As a free and lightweight alternative, it allows you to manage spreadsheet data effortlessly and create public sharing links without navigating complex admin settings.

1. Open exported data in WPS Spreadsheet: Launch WPS Office and open the Excel or CSV file you exported from your Microsoft List.
2. Save to WPS Cloud: Click 'Save As' and choose your WPS Cloud drive to easily manage the file online.
3. Share with the public: Click the 'Share' button in the top right corner, set the permission to 'Anyone with the link can view', and copy the URL to share your data instantly.

Seamlessly open and edit Microsoft Excel (.xlsx) formats exported from Microsoft ListsEasily generate public sharing links for your documents via WPS CloudLightweight software that runs quickly on Windows, Mac, and mobile devicesFamiliar user interface requires no steep learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I publish a SharePoint list to a public website?

No, out-of-the-box SharePoint Online and Microsoft Lists do not support anonymous public embedding or publishing. External users must typically be invited as guests and sign in to view list content.

Why is the 'Anyone with the link' option greyed out for my list items?

This option is controlled by your IT administrator at the tenant level. If it is greyed out or missing, your organization's security policies have restricted anonymous external sharing.

Is there any way to share dynamic list data with external users?

To share dynamic data, you can invite external users as Azure AD B2B guests. They will be required to authenticate (log in) to view and interact with the live list, but this ensures your data remains secure.

Document & File Issues