Supermetrics for Excel
Connect Facebook Ads to Microsoft Excel — Desktop Reporting Powerhouse
Excel is where serious number-crunching happens. Connect Facebook Ads to Microsoft Excel and put the full power of pivot tables, XLOOKUP, conditional formatting, and Power Query behind your ad data. Build workbooks that refresh on schedule, crunch thousands of rows without breaking a sweat, and email polished reports to stakeholders automatically.
Why Connect Facebook Ads to Microsoft Excel?
Ditch the Ads Manager exports. Pull live Facebook Ads data into Excel and unleash pivot tables, Power Query, and desktop-grade analysis on your campaigns.
Desktop performance for heavy data
Excel Desktop handles massive datasets without flinching. Pull tens of thousands of Facebook Ads rows and slice them with pivot tables faster than any browser-based tool.
Learn more
Desktop performance for heavy data
Excel Desktop handles massive datasets without flinching. Pull tens of thousands of Facebook Ads rows and slice them with pivot tables faster than any browser-based tool.
Pivot tables built for ad analysis
Drag campaign, ad set, and placement fields into a pivot table and instantly see spend, ROAS, and CPA breakdowns — no formulas needed.
Learn more
Pivot tables built for ad analysis
Drag campaign, ad set, and placement fields into a pivot table and instantly see spend, ROAS, and CPA breakdowns — no formulas needed.
Advanced formulas and conditional formatting
Use XLOOKUP, SUMIFS, dynamic arrays, and conditional formatting to build self-updating reports that highlight what matters.
Learn more
Advanced formulas and conditional formatting
Use XLOOKUP, SUMIFS, dynamic arrays, and conditional formatting to build self-updating reports that highlight what matters.
Email reports as polished Excel files
Schedule automatic refreshes and email delivery through Supermetrics Hub. Stakeholders get a ready-to-open .xlsx in their inbox.
Learn more
Email reports as polished Excel files
Schedule automatic refreshes and email delivery through Supermetrics Hub. Stakeholders get a ready-to-open .xlsx in their inbox.
Cross-channel reporting in one workbook
Pull Facebook Ads alongside Google Ads, TikTok Ads, and LinkedIn Ads into separate worksheets. Blend them with XLOOKUP and pivot tables for a unified view.
Learn more
Cross-channel reporting in one workbook
Pull Facebook Ads alongside Google Ads, TikTok Ads, and LinkedIn Ads into separate worksheets. Blend them with XLOOKUP and pivot tables for a unified view.
Work in the tool you already know
No new dashboards to learn. Your Facebook Ads data shows up in the same Excel you have been using for years — complete with your shortcuts, templates, and muscle memory.
Learn more
Work in the tool you already know
No new dashboards to learn. Your Facebook Ads data shows up in the same Excel you have been using for years — complete with your shortcuts, templates, and muscle memory.
How to Connect Facebook Ads to Microsoft Excel
Three steps. Under two minutes. Zero code.
- 1
Install the Supermetrics add-in
Get Supermetrics from the Microsoft AppSource store or search for it inside Excel's Add-ins menu. You can also use Supermetrics Hub for Excel Online.
- 2
Select your data source
Open the Supermetrics panel, choose your data source, and authorize your account through a quick OAuth sign-in.
- 3
Build your query and get data
Pick your metrics, dimensions, date range, and filters. Click "Get data" — results appear directly in your Excel cells, ready for pivot tables and charts.
Report Templates for Facebook Ads in Microsoft Excel
Pre-built spreadsheet reports you can use as starting points. Customize with your own metrics, filters, and formatting.
Pivot Table Campaign Dashboard
A pivot table workbook that lets you slice Facebook Ads performance by campaign, ad set, placement, and device. Add slicers for interactive filtering and timeline controls for date range selection.
Executive Summary with Charts
A polished one-page summary with Excel charts showing monthly spend trends, conversion volume, and ROAS. Conditional formatting highlights campaigns that exceed or miss targets.
Ad Creative Performance Scorecard
Rank every active ad by conversion rate and cost per result using XLOOKUP-driven scorecards. Conditional formatting with icon sets gives instant visual ranking without reading a single number.
Budget Pacing Tracker with Alerts
Track daily spend against monthly budget targets using SUMIFS and dynamic formulas. Data bars show pacing visually, and conditional formatting flags campaigns that are over or under pace.
Multi-Account Comparison Workbook
Pull data from multiple Facebook Ads accounts into separate sheets and use a Power Query merge or XLOOKUP to build a unified comparison view with cross-account totals and averages.
Automate Your Facebook Ads Reports
Set up scheduled refreshes and automatic email delivery so your Facebook Ads reports stay current without any manual work.
Morning refresh for desktop analysis
Schedule a daily refresh at 6 AM through Supermetrics Hub so your Excel workbook has fresh Facebook Ads data waiting when you open it. Facebook Ads data typically finalizes within a few hours of the previous day's end.
Weekly email delivery for stakeholders
Set up a Monday morning refresh with automatic email delivery via Supermetrics Hub. Stakeholders receive the workbook as an .xlsx attachment with last week's data already loaded — ready to open, filter, and pivot.
Monthly append for historical trend analysis
Use append mode on a monthly schedule to build a running historical log of campaign performance. Feed this growing dataset into a pivot table with a timeline slicer to spot seasonal patterns and long-term trends.
What Facebook Ads Data Can You Pull into Microsoft Excel?
Supermetrics gives Microsoft Excel access to your full Facebook Ads reporting data — metrics and dimensions you already know from the Facebook Ads interface.
Key Metrics
- Impressions
- Clicks
- Spend
- ROAS
- CPA
- CTR
- CPM
- Conversions
- Reach
- Frequency
- Video views
- Link clicks
- Cost per action
- Purchase value
- Add to cart
Key Dimensions
- Campaign name
- Ad set name
- Ad name
- Age
- Gender
- Placement
- Device
- Country
- Region
- Platform (Facebook / Instagram / Audience Network)
- Objective
- Delivery status
- Instagram placement (Feed / Stories / Reels / Explore)
Resources & Guides
Why Supermetrics for Microsoft Excel?
The trusted marketing data platform since 2009. 200,000+ companies use Supermetrics — 15% of global ad spend flows through our connectors.
Reliability & Depth
The most trusted marketing data connector for Excel — used by 200,000+ companies. Supermetrics covers more metrics and dimensions per source than any alternative, with the scheduling reliability enterprises depend on.
170+ Data Sources, One Workbook
Connect Facebook Ads alongside 170+ other platforms in the same Excel workbook. Blend data across sources with built-in joins, currency conversion, and campaign name normalization — no manual copy-paste, no formula errors.
Pre-Built Templates
Start with expert-designed Microsoft Excel report templates for Facebook Ads. Customize columns, add charts, and apply your brand — a polished report in minutes, not hours.
Enterprise Security
SOC 2 Type II certified. GDPR compliant. OAuth authentication. Your data is encrypted at rest and in transit.
Scheduled Refreshes
Set up automatic data refreshes — hourly, daily, or weekly. Your Facebook Ads reports stay current without anyone clicking a button. Add email delivery to distribute reports automatically.
No Data Limits
Query any date range, any number of campaigns, any level of granularity. No row limits, no sampling, no restrictions on the data you can pull.
Frequently Asked Questions
How do I connect Facebook Ads to Microsoft Excel?
Install the Supermetrics add-in from the Microsoft AppSource store, open it in Excel, select Facebook Ads as your data source, authorize your account, and click "Get data." Your data lands directly in your worksheet cells — no CSV downloads or copy-pasting required. The add-in works in both Excel Desktop (Windows) and Excel Online via Supermetrics Hub.
Is my Facebook Ads data secure in Excel?
Yes. Supermetrics uses OAuth authentication for Facebook Ads — your credentials are never stored in the workbook file. All data transfers are encrypted in transit, and Supermetrics is SOC 2 Type II certified and GDPR compliant. Workbook-level security and SharePoint permissions give you full control over who can view the data.
Can I combine Facebook Ads data with other data sources in the same workbook?
Absolutely. Supermetrics connects 170+ data sources to Excel. Pull Facebook Ads data into one worksheet and Google Ads data into another, then use XLOOKUP, SUMIFS, pivot tables, or Power Query to blend and compare across sources — all inside the same workbook.
What Facebook Ads metrics can I pull into Excel?
You can access all standard Facebook Ads reporting metrics through Supermetrics, including Impressions, Clicks, Spend, ROAS, CPA, and more. Both metrics and dimensions are available, and the data drops into regular Excel cells so you can immediately use pivot tables, charts, and formulas on it.
Can I schedule automatic data refreshes for Facebook Ads in Excel?
Yes. Through Supermetrics Hub, you can schedule automatic refreshes — daily, weekly, or monthly — so your Facebook Ads data stays current without manual work. You can also set up automatic email delivery to send refreshed workbooks to stakeholders as Excel files or PDFs.
Does the Supermetrics Excel add-in work on Mac?
The Supermetrics desktop add-in is currently available for Excel on Windows. Mac users can access the same Facebook Ads data through Supermetrics Hub, which works with Excel Online in any browser. Hub delivers the same query builder, scheduling, and automatic refresh capabilities regardless of operating system.
Can I use Power Query with Facebook Ads data from Supermetrics?
Yes. Once Supermetrics pulls Facebook Ads data into your worksheet, Power Query can pick it up as a data source for further transformation. Use Power Query to clean, reshape, merge with other datasets, and load into your data model — all without modifying the original Supermetrics data pull.
Can I pull Facebook Ads data for multiple ad accounts into one Excel workbook?
Yes. Create separate Supermetrics queries for each account on different worksheets, or pull all accounts into a single query with the account name as a dimension. Then use a pivot table or SUMIFS to compare performance across accounts in one view.
Does the Facebook Ads connector include Instagram Ads data in Excel?
Yes. Facebook Ads and Instagram Ads are managed through the same Meta Ads platform. When you connect Facebook Ads in Supermetrics, Instagram Ads data is included automatically. Filter by placement dimension to separate Facebook and Instagram performance in your Excel reports.
Will my existing VBA macros still work with Supermetrics data?
Yes. Supermetrics writes data into standard Excel cells, so any VBA macros that reference those cells or ranges continue to work as expected. You can even trigger macros after a data refresh to automate post-processing steps like formatting, calculations, or exporting specific sheets.
What Excel file formats are supported?
Supermetrics works with .xlsx workbooks in Excel Desktop and Excel Online. When emailing reports through Supermetrics Hub, you can deliver the workbook as .xlsx or export specific sheets as PDF. The data is always written into standard Excel cells, so you retain full compatibility with formulas, pivot tables, and charts.
Also Connect to Microsoft Excel
Ready to Connect Facebook Ads to Microsoft Excel?
Join 200,000+ companies that use Supermetrics to connect their marketing data. Set up in under two minutes.