Graphed LogoGraphed
Graphed LogoGraphed
How It WorksAgentsIntegrationsPricing

How to Create a Website Dashboard in Excel

Cody Schneider••8 min read

Building a website dashboard in Excel is a fantastic way to pull all your key performance indicators into one customizable view. Instead of logging into multiple platforms to monitor performance, you can create a single source of truth for your website's analytics. This article will guide you step-by-step through setting up your data, choosing the right tools in Excel, and building a dynamic, interactive dashboard from scratch.

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Why Use Excel for Your Website Dashboard?

While dedicated business intelligence tools are powerful, Excel remains a go-to for many marketers and business owners for several solid reasons. You probably already have it, you're likely familiar with it, and its flexibility is unmatched for creating something truly custom without a steep learning curve. The main goal is to consolidate data from sources like Google Analytics, your email platform, and your ad accounts into one place so you can see the full picture and make better decisions faster.

Step 1: Gather and Organize Your Website Data

A dashboard is only as good as the data feeding it, so your first step is gathering the necessary information. There are three primary ways to get your website analytics into Excel.

Exporting Data Manually (CSV Method)

This is the most common starting point. You log into your analytics platform, export the data you need as a CSV file, and then open it in Excel.

Here’s a common example using Google Analytics 4:

  • Log into your GA4 property.
  • Navigate to Reports > Engagement > Pages and screens or Acquisition > Traffic acquisition.
  • Adjust the date range to what you need (e.g., last 30 days, last quarter).
  • In the top right corner of the report, you'll see a 'Share' icon. Click it and then select 'Download File' > 'Download CSV'.

You can repeat this process for different reports (e.g., demographic data, conversions) and other platforms like Facebook Ads, Shopify, or HubSpot. For now, let’s stick with a single marketing traffic report to build our basic dashboard.

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Automating Data Imports with Power Query

If you're tired of the manual export/import cycle, Excel's built-in Power Query tool is your best friend. It can connect directly to various data sources (including a file on your computer, a web page, or enterprise databases) and create a refreshable connection. When you update the source file (e.g., replace last week's CSV with this week's), you can just click 'Refresh All' in Excel to update your entire dashboard.

Power Query is beyond the scope of this initial tutorial, but know that it's the next step to a more automated process within Excel.

Step 2: Structure Your Data into an Excel Table

Now that you have your data in an Excel sheet, the single most important thing you can do is format it as an official Excel Table. Do not skip this step! It’s what makes your dashboard dynamic and easy to update.

Here's how:

  1. Open your CSV data in Excel. Ensure your data is in a simple tabular format with a single header row at the top and your data in the rows below it.
  2. Click on any cell within your data range.
  3. Press Ctrl + T (or go to the 'Insert' tab and click 'Table').
  4. A small dialog box will appear. Make sure the 'My table has headers' box is checked, and click 'OK'.

Your data will instantly be formatted with colored bands and filter buttons. But the benefits are more than just cosmetic:

  • Automatic Expansion: When you add new rows of data to the bottom, the table automatically expands to include them. This means any charts or PivotTables connected to it will update instantly upon refresh.
  • Structured References: Instead of using cell references like C2:C100, you can use easy-to-read column names, like Table1[Sessions].
  • Easy Naming: With your table selected, go to the 'Table Design' tab that appears in the top ribbon and give your table a descriptive name in the 'Table Name' box (e.g., "WebsiteData").

Step 3: Build Your Dashboard with PivotTables and Charts

With our data correctly structured, we can now start building the visual components of our dashboard. We'll create two separate worksheets: your Dashboard sheet (which will be the polished final view) and your PivotCache sheet (which will house the PivotTables that power your charts behind the scenes).

GraphedGraphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Watch Graphed demo video

Creating KPI Summary Cards

Your dashboard should feature a few main key performance indicators (KPIs) at the top for an at-a-glance summary. Let's create cards for Total Sessions, Total Users, and Total Conversions.

  1. Go to your Dashboard sheet. Create a few nice-looking text boxes or framed cells for your KPIs.
  2. In the cell for 'Total Sessions', type the following formula. This formula sums up every number in the 'Sessions' column of your table, no matter how many rows you add later.

=SUM(WebsiteData[Sessions])

  1. Repeat this for other KPIs:
  • Total Users: =SUM(WebsiteData[Users])
  • Total Conversions: =SUM(WebsiteData[Conversions])

Now you have clean, dynamic summary numbers that will update automatically whenever your raw data changes.

Creating Your First Chart: Sessions by Channel

PivotTables are the engine for summarizing data in Excel. Let's use one to create a bar chart showing where your traffic comes from.

  1. Click anywhere inside your WebsiteData table.
  2. Go to the 'Insert' tab and click 'PivotTable'.
  3. In the dialog that appears, choose to place the PivotTable in your existing PivotCache worksheet, then click 'OK'.
  4. The PivotTable Fields pane will appear on the right. This is where you build the report:
  5. You now have a clean summary table showing total sessions for each traffic channel.

Now, let's turn this into a chart:

  1. Click on any cell inside your new PivotTable.
  2. Go to the 'PivotTable Analyze' tab and click 'PivotChart'.
  3. Choose a Bar chart and click 'OK'.
  4. A linked chart will appear. It's time to clean it up: remove the legend, hide the field buttons (right-click and select 'Hide All Field Buttons on Chart'), and give it a clear title like "Sessions by Channel".
  5. Finally, press Ctrl + X to cut the chart. Go to your Dashboard sheet and press Ctrl + V to paste it.

Creating Your Second Chart: Users Over Time

Repeat the process to create a line chart showing daily user trends. Go back to your WebsiteData table, insert a new PivotTable into your PivotCache sheet, and configure it:

  • Drag 'Date' into the Rows area.
  • Drag 'Users' into the Values area.

Create a PivotChart from this data, choosing a Line chart this time. Clean it up, cut it, and paste it onto your Dashboard sheet. You now have two distinct visualizations that give an overview of your website traffic.

Step 4: Make Your Dashboard Interactive with Slicers

This is where the magic happens. Slicers are user-friendly filter buttons that can control multiple PivotTables (and their charts) at once.

  1. Click on your "Sessions by Channel" chart on the dashboard.
  2. Go to the 'PivotTable Analyze' tab and click 'Insert Slicer'.
  3. A checklist of your data columns will appear. Check the box for 'Device category' and click 'OK'.
  4. A slicer with buttons for 'desktop', 'mobile', and 'tablet' will appear. Move it to a convenient spot on your dashboard.

Right now, this slicer only controls the first chart. To connect it to your other chart:

  1. Right-click on the slicer and select 'Report Connections'.
  2. In the pop-up, you will see a list of all the PivotTables in your workbook. Check the box for your second PivotTable (the one powering the users over time chart).
  3. Click 'OK'.

Now, when you click 'mobile' on the slicer, both charts will instantly update to show data for mobile users only. You’ve just created a dynamic, interactive dashboard!

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Step 5: Design and Professional Polish

Nobody wants to look at a messy dashboard. Spend a few minutes on design to make it highly readable and visually appealing.

  • Use a Grid Layout: Organize your KPIs, charts, and slicers logically. Align elements to create a sense of order.
  • Consistent Colors: Use your brand's color palette or pick a simple, consistent color scheme for all your charts.
  • Remove Chart Junk: Delete unnecessary gridlines, borders, and labels that don't add value. The cleaner, the better.
  • Hide Gridlines: Go to the 'View' tab and uncheck the 'Gridlines' box to give your entire dashboard a clean, report-like background.

The Limits of Excel Dashboards

While powerful, building dashboards in Excel isn't without its challenges. The biggest one is the manual upkeep. Your dashboard is only as current as your last CSV export. Remembering to download fresh data, paste it in, and refresh your tables every day or week is time-consuming and prone to human error.

Furthermore, Excel can become slow and cumbersome when dealing with truly massive datasets over six figures in rows. And sharing an Excel file can quickly lead to version control headaches, where different team members are looking at different, out-of-date reports.

Final Thoughts

By following these steps - gathering data, structuring it in Excel Tables, summarizing it with PivotTables, and adding interactivity with Slicers - you can build a seriously impressive website dashboard. It’s a fantastic skill to have and puts the power of tailored reporting right at your fingertips without the need for expensive software.

The manual data updates in Excel are often the most tedious part, and it's the main reason we built Graphed. Our platform connects directly to all your data sources like Google Analytics, Shopify, Facebook Ads, and Salesforce. Instead of exporting CSVs, you just tell us what you want to see in plain English, and we build a real-time, interactive dashboard for you that updates automatically. It gives you all the analytical power without any of the manual data wrangling.

Related Articles