Turn a Spreadsheet Into an Interactive Project Dashboard with ChatGPT Sites

You can turn a project spreadsheet into a dashboard where colleagues filter by status, check deadlines, and find out who owns each task.

Other uses include a portfolio of your work, a prototype to test a business idea, or a resource page that brings team guides and links together.

For this walkthrough, I used a fictional spreadsheet of six projects to build a dashboard for a department manager.

To test building from existing data, I used a sample spreadsheet of six projects with progress, status, deadlines, owners, and next steps.

The goal was a dashboard a department manager could share, so colleagues could check progress, see what's delayed, and find next steps.

Step 1: Start by adding your data file

I opened a Work conversation in ChatGPT, attached the Excel file, and mentioned @Sites in my request.

In ChatGPT, attach your spreadsheet and type @Sites to start.

Step 2: Describe the site

I gave ChatGPT this prompt:

"Turn this spreadsheet into an interactive team project dashboard website for a department manager. Include an overview of all projects, progress bars, deadlines, and color-coded status indicators. Allow me to filter projects by status and click on individual projects to see their owners, blockers, and next steps. Keep the design clean, professional, and easy for non-technical leaders to understand. Use only the information in my spreadsheet."

Use our CODO prompting framework to structure your request.

Step 3: Preview and test

The dashboard brought all six projects into one view, with progress indicators and status labels. I filtered by status to focus on delayed or at-risk projects, then clicked a project to see its owner and next steps.

The first dashboard shows project progress, deadlines, and color-coded status.

Before publishing, I checked that the project details and progress figures matched the original spreadsheet.

Step 4: Refine the Site

I made one change by asking ChatGPT:

"Add a section called 'Needs Leadership Attention' that highlights projects marked At Risk or Delayed, including their blockers and next steps. Keep all existing project data unchanged."

I reviewed the new preview and tested the section.

The updated dashboard adds a Needs Leadership Attention section for At Risk and Delayed projects.

Step 5: Share the site

When I was happy with the result, I deployed the Site to generate a live URL. It started private, so I opened Share to review who could access it. Depending on your account and workspace permissions, you can share with selected people, make it available within your workspace, or publish it publicly.

Open Share to choose who can view the site. The link starts as Only those invited.

I'd start with a spreadsheet you already know well, so you can spot a wrong number quickly. Some other tips:

1. Build iteratively. Test the first version and add more details as you go.
2. Verify the result. Check figures, links, forms, and interactive features before you share. Our DRAFT Framework gives you a quick way to judge AI output.
3. Consider access and privacy. Only upload and publish information you're authorized to use.

If you already use ChatGPT Work for recurring updates, our walkthrough on building a weekly project report in ChatGPT Slides pairs well with this one.

• Plans: ChatGPT Sites is available on Plus, Pro, Business, and Enterprise, subject to workspace settings and permissions. Free and Go aren't supported. For Edu environments, check with your workspace administrator.
• Usage and cost: Creating or editing Sites counts toward your Codex usage. Hosting is currently included on Plus, Pro, and Enterprise. Hosting charges are currently waived through December 31, 2026. Check future hosting rates here.
• Access: New Sites are private by default, and workspace admins may keep access. Depending on your plan and permissions, you can share with selected people, workspace members, or the public.