Project Management Dashboard – Interactive HTML + Excel Template

Overview

A ready-to-use Project Management Dashboard that runs directly in your web browser. Open one HTML file, load your own project list from the included Excel workbook, and get an interactive view of your portfolio: budgets, delivery stages, statuses, finance numbers and project-level detail.

There is nothing to install and no account to create. The dashboard runs locally on your own computer, and your workbook is read on your machine rather than uploaded anywhere. No Power BI, no subscription and no server are required.

How it works

1. Download the ZIP and extract it to a folder on your computer.
2. Open the included Excel file, Project-Data.xlsx.
3. Replace the sample projects with your own, keeping the column headings in row 1. Save the file.
4. Open Dashboard.html in your browser and click Load / Update Excel at the top of the page.
5. Choose your saved workbook. The KPIs, charts, filters and tables rebuild around your data straight away.

Whenever your projects change, edit the workbook, save it, and import it again. The dashboard reads your file at the moment you import it; refreshing the page does not re-read it from disk, because a browser cannot open a file on your computer without you choosing it. Most browsers remember your last import, so your data is still there when you reopen the dashboard.

What's included

• Dashboard.html - the complete dashboard in a single self-contained file.
• Project-Data.xlsx - a formatted Excel workbook with sample project data, a status dropdown and an Instructions tab.
• START-HERE.txt - step-by-step setup, spreadsheet rules and troubleshooting in plain English.
• LICENCE.txt - the licence terms for using the template.

Key features

• KPI summary: total budget, project count, highest-value project and unique finance numbers.
• Active Pipeline view showing each delivery stage with counts, value and share of budget.
• An All Projects view plus a separate view for every status in your data.
• Charts for projects by status, budget by status, projects by year, budget by type, top projects, top finance numbers and project size bands.
• Comment analysis that groups your notes into themes using built-in keyword rules.
• Filters for year and budget type, a search box, and click-through filtering from the charts.
• Sortable, paginated project table with a detail panel for each project, including its Excel row number.
• CSV export of the visible table, plus print or save to PDF.
• A currency label setting, so amounts read in your own currency.
• Clear reporting of any spreadsheet cell it cannot read, naming the exact cell rather than guessing a number.

Requirements and compatibility

• This is a digital download. No physical item is shipped.
• You need Microsoft Excel, or another spreadsheet application that can save a standard .xlsx file, to edit the supplied data.
• The dashboard is viewed in a current desktop browser: Chrome, Edge, Firefox, or Safari 16.4 or newer.
• Designed for desktop and laptop screens. It will open on a tablet or phone, but it is built for larger displays.
• No Power BI licence, subscription, hosted server or internet connection is required for normal use.
• Your data is updated by importing the workbook yourself. The dashboard does not sync automatically with a file on disk.
• Formulas are supported through the result Excel saves in the file. The dashboard reads that saved result and does not recalculate your spreadsheet, so press F9 and save in Excel before importing if you use formulas.
• Comment themes are grouped using a fixed list of English keywords. This is not AI, and notes in other languages fall into the Other group.
• Tested with workbooks of up to 20,000 project rows.