SharePoint HTML pages: build dashboards with Copilot

Key insights

• HTML pages are stored in SharePoint’s Site Pages library.
• Copilot can draft a page from a natural-language description and help revise its content and design.
• You can also upload an existing HTML file or a folder containing an HTML page and its supporting assets.
• The video description says dashboards can be built from a Microsoft List or Excel file, but gives no step-by-step transcript.
• The source material does not specify licensing, tenant availability, or rollout details.

SharePoint HTML pages let users create and publish interactive webpages in a SharePoint site, and Copilot can help draft and refine a dashboard from a plain-language request. This can help people who need to present project or business information in a richer format than a standard page, without hand-authoring the page’s code. Office Skills with Amy presents a dashboard-building demonstration using a Microsoft List or Excel file and Copilot.

What it does

An HTML page is a webpage stored in SharePoint’s Site Pages library. It gives site owners and contributors another format for presenting information alongside modern SharePoint pages and ASPX pages. Rather than assembling every element as a conventional SharePoint page, an HTML page can use HTML and styling to create a more customized experience.

Copilot can generate an initial page based on a natural-language description and help change its content, layout, design, or structure. The research notes describe dashboards and reports as possible uses, including status summaries and data visualizations. The video description specifically says a Microsoft List or Excel file can be turned into an interactive dashboard, but the available transcript does not provide the exact prompt, data connection steps, or finished dashboard details.

HTML pages can also be created by uploading an existing HTML file or an HTML folder with supporting assets. The research notes say uploaded images and videos can be stored in Site Assets. That gives organizations a way to manage a custom HTML experience within SharePoint instead of treating it as a separate webpage outside the site.

Who it is for and what you need

This approach is relevant to people who maintain SharePoint sites and need to present information such as project status or operational summaries. The source material names students, teachers, project managers, and business owners as potential audiences, but does not establish a particular role as a requirement. It also does not state a required Microsoft 365 plan or license for creating HTML pages.

Copilot-assisted creation is part of the scenario described, but the supplied material does not establish which Copilot license or tenant configuration is required for this specific workflow. Nor does it confirm availability by region, tenant, or rollout stage. Check Microsoft’s documentation and your organization’s tenant experience before planning a deployment around the feature.

Any dashboard that uses SharePoint content remains subject to SharePoint access controls. The research notes say users can only access connected content for which they already have permission. A page’s interactive presentation does not grant users additional rights to its data.

How it works

The general process is to create an HTML page, explain what it should contain, review Copilot’s draft, and publish once it is ready. The following workflow reflects the research notes, not a verified click-by-click transcript of the demonstration.

1. Open the SharePoint site where you want the page and start creating an HTML page. The research notes place HTML pages in the Site Pages library.
2. Describe the dashboard you want in natural language. Specify its purpose and the information or layout you need. If relevant, attach files or reference SharePoint content to provide context.
3. Review the draft. Ask Copilot to revise the wording, layout, colors, charts, or interactive elements as needed; the notes describe iterative refinement as part of the workflow.
4. Review the page and publish it when it is ready. The notes describe a review and publish process similar to other SharePoint content.

For a data dashboard, decide which source information should appear and confirm that its intended viewers have permission to access it. The supplied material does not explain the exact steps for connecting a List or workbook, how refresh behavior is configured, or which data formats and interactions the demonstration uses.

Limitations and open questions

The available video transcript is empty, so the demonstration’s exact interface, prompts, and security or troubleshooting advice cannot be independently described here. Its published description says it builds a dashboard from a Microsoft List or Excel file, but does not explain how the connection works. Treat the article’s workflow as a high-level guide rather than a reproduction of the video.

The research notes describe interactive elements and some supported libraries, but the material supplied here does not provide a complete compatibility list or explain technical restrictions in detail. Custom HTML generated for a general website may need adjustment to work within SharePoint’s rendering and security environment. For that reason, do not assume that every script, library, or external resource will work in a SharePoint page.

HTML pages are an additional option, not a claim that standard SharePoint pages, custom development, or business intelligence tools are no longer needed. The source material does not compare the approach’s capabilities or limits with those alternatives in enough detail to make a tool-selection recommendation. It also does not verify the licensing and rollout information mentioned in the research notes.

Sources

• Microsoft documentation on creating, editing, and publishing HTML pages
• Office Skills with Amy’s SharePoint HTML pages demonstration

Frequently asked questions

Can Copilot create an interactive dashboard in SharePoint?

The supplied material describes using Copilot to draft and refine an HTML page for a dashboard. The video description names Microsoft Lists and Excel as possible source material, but does not explain the connection steps.

Where are SharePoint HTML pages stored?

The research notes say HTML pages are stored in the SharePoint Site Pages library.

What license is required for Copilot HTML page creation?

The supplied material does not establish the license required for this specific workflow. Check Microsoft’s documentation and your tenant’s licensing details.

Can I upload an existing HTML page to SharePoint?

The research notes say you can upload an existing HTML file or an HTML folder with supporting assets. They do not detail all supported file types or technical restrictions.