How to Create a Social Media Dashboard in Excel

Tracking your social media performance doesn't have to require a fancy, expensive tool. With a bit of setup, you can build a powerful and custom social media dashboard right in Microsoft Excel. This article will guide you step-by-step through the process, from gathering your data from different platforms to visualizing it in a way that provides clear, actionable insights.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Choose Your Social Media KPIs First

Before you even open a spreadsheet, you need to know what you want to measure. Your goals determine your metrics. A dashboard full of vanity metrics won't help you make better decisions. Start by asking, "What does success on social media look like for my business?"

Here are some common goals and the key performance indicators (KPIs) that map to them:

• Goal: Increase Brand Awareness. This is all about getting your content in front of more eyes.
• Goal: Boost Community Engagement. This measures how your audience interacts with your content.
• Goal: Drive Website Traffic. This focuses on getting people to leave the social platform and visit your site.
• Goal: Generate Leads or Sales. This connects social media activity directly to revenue.

Once you’ve defined your goals and picked your KPIs, you're ready to start collecting the data.

Gathering and Exporting Your Data

The most time-consuming part of using Excel for dashboards is the manual data collection. Each social platform has its own analytics section where you can export data, typically as a .csv file which opens perfectly in Excel.

Let’s cover how to find this data on the major platforms:

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Facebook and Instagram

Since both are owned by Meta, you can get data for both platforms from the Meta Business Suite.

1. Navigate to your Meta Business Suite and click on the "Insights" tab.
2. In the left menu, select the type of data you want to review, such as "Results," "Audience," or "Content."
3. In the top right corner of most reports, you'll see a button labeled "Export Data."
4. Choose your desired date range and the file format (CSV). You can export overview data, post-level data, or video data. For a dashboard, post-level data is usually the most useful.

LinkedIn

For your company page, LinkedIn provides detailed analytics you can export.

1. Go to your LinkedIn Company Page, and click the "Analytics" dropdown. You can choose from Visitors, Updates, Followers, Competitors, or Employee Advocacy.
2. For content performance, select "Updates."
3. Set your desired date range (up to the last year).
4. Click the "Export" button in the top right corner. You'll get a detailed Excel file with metrics for each post, including impressions, clicks, shares, and engagement rate.

X (formerly Twitter)

X Analytics offers a simple way to export your Tweet activity.

1. Log in to your X account and go to analytics.twitter.com.
2. In the top navigation, click on "Tweets."
3. Here you can adjust the date range and then click the "Export data" button.
4. Choose "By Tweet" to get a detailed CSV report of individual tweet performance.

Structuring Your Excel Workbook

Organization is everything. A well-structured workbook makes the dashboard easier to build, update, and understand. We recommend a three-tab structure:

• Tab 1: Raw Data. This is where you'll paste your exported CSV data. It's a good practice to have a separate section or tab for each platform's raw data to keep things clean. For example, have sheets named FB Raw Data, IG Raw Data, LI Raw Data.
• Tab 2: Summary Tables / PivotTables. This tab will be your calculation engine. You'll use formulas and PivotTables here to summarize the raw data into clean tables that will power your charts.
• Tab 3: Dashboard. This is the final, front-facing tab. It will only contain your charts, scorecards, and filters (slicers). No raw data or messy calculations live here - just the clean visualizations.

To start, copy the data from each exported CSV and paste it into its respective "Raw Data" sheet. Don’t worry about formatting it perfectly just yet.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using PivotTables to Summarize Your Data

PivotTables are your best friend for building an Excel dashboard. They allow you to quickly summarize large datasets without writing complex formulas. We'll use them to create summary tables on your "Summary Tables" tab that our charts will reference.

Let's create a summary of your key metrics by platform:

1. Go to your "Raw Data" tab where you have all your post data consolidated. First, you'll need a single master table. A simple method is to create a new sheet called 'All Raw Data' and copy-paste the data from each platform here, adding a 'Platform' column manually to identify each row (e.g., "Facebook", "Instagram").
2. Click anywhere inside your master data table.
3. Go to the Insert tab on the Excel ribbon and click PivotTable.
4. In the pop-up window, ensure your data range is correct and choose to place the PivotTable in your existing "Summary Tables" worksheet.
5. The PivotTable Fields pane will appear. Now you can build your summary:

You now have a clean table summarizing your performance by platform! You can repeat this process to create other summaries, such as performance over time (drag "Date" to the Rows area) or engagement by post type (drag "Post Type" to the Rows area).

Calculating Custom Metrics

What about metrics like Engagement Rate that aren't in your raw data? You can use a PivotTable feature called "Calculated Fields."

1. Click on your PivotTable.
2. Go to the PivotTable Analyze tab on the ribbon.
3. Click on Fields, Items, & Sets, then select Calculated Field.
4. Name your field "Engagement_Rate".
5. For the formula, enter something like this (your column names might differ):
6. Click OK. The new Engagement Rate will be added to your PivotTable. Make sure to format this column as a percentage.

Visualizing Your Data on the Dashboard

This is the fun part. Go to your "Dashboard" tab and start creating your charts. All charts will be based on the summary data and PivotTables on your "Summary Tables" sheet.

KPI Scorecards

For top-level metrics like total followers or total engagement, simple "scorecards" are very effective.

1. On your Dashboard tab, select a cell where you want a scorecard to appear.
2. In the formula bar, type = and then navigate to your "Summary Tables" sheet and click on the cell containing the total you want to display (e.g., the grand total for Impressions). Press Enter.
3. Now, just format the cell to make it stand out. Increase the font size, make it bold, and give it a label above or below.

Performance Over Time (Line Chart)

Line charts are perfect for showing trends. Let's create one for impressions over time.

1. On your "Summary Tables" sheet, create a PivotTable with "Date" in the Rows (grouped by month or week) and "Sum of Impressions" in the Values.
2. Select this PivotTable.
3. Go to the Insert tab and choose a Line Chart.
4. Cut the chart (Ctrl+X or Cmd+X) and paste it (Ctrl+V or Cmd+V) into your "Dashboard" tab.
5. Clean up the chart: give it a clear title, remove unnecessary gridlines, and format the colors to match your brand.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Comparing Platforms (Bar Chart)

Bar charts are ideal for comparing performance between categories, like different social media platforms.

1. On your "Summary Tables" tab, select the data in your "Metrics by Platform" PivotTable (don't include the grand total).
2. Go to the Insert tab and choose a Column or Bar Chart.
3. Cut and paste the chart onto your "Dashboard" tab and style it as needed.

Making Your Dashboard Interactive with Slicers

Slicers are user-friendly filter buttons that make your dashboard dynamic. Instead of manually changing date ranges in a PivotTable, you can just click a button.

1. Click on any of the PivotTable-based charts on your dashboard.
2. Go to the PivotChart Analyze tab and click Insert Slicer.
3. A box will pop up with all your data fields. Check the boxes for the fields you want to filter by - "Platform" and "Date" are great choices.
4. Click OK. The slicers will appear on your sheet. You can move and resize them to fit your dashboard layout.
5. To make one slicer control all your charts, right-click the slicer, choose "Report Connections," and check the boxes for all the PivotTables in your workbook. Now, when you select "Facebook" on the slicer, all of your charts will update to show only Facebook data.

Final Thoughts

Building a social media dashboard in Excel empowers you to own your analytics, tracking the specific KPIs that matter to your business. While it requires manual exports and updates, it’s a flexible and cost-effective method to transform raw data into a clear performance narrative, helping you understand what’s working and what isn't.

Of course, the biggest challenge with Excel dashboards is the time spent manually downloading CSVs and updating your sheets each week. That’s why we built Graphed. We connect directly to your social media platforms and other data sources, automating the entire process. Instead of tedious manual work, you can just ask in plain language, "Build me a dashboard showing my social media engagement rate by platform for this quarter," and get a live, auto-updating dashboard in seconds.