Facebook Ads to Excel
Spend, reach and clicks from Meta Ads, by ad account, campaign, ad set or ad, in a worksheet in your own OneDrive.
- Refreshes every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
- Up to 10,000 rows a report.
30 days of Plus, free from sign-up. No card needed.
No Google account needed: sign in with a work or school Microsoft account.
How to connect Facebook Ads to Excel
To get Facebook Ads to Excel you need a work or school Microsoft account with OneDrive, and a Facebook account with access to an ad account.
- On the Sources page, choose Connect Meta and sign in with the Facebook account you use in Meta Ads Manager.
- In Fresh Sheets, connect Excel on the Destinations page.
- Choose New report, pick Meta Ads and the account, then the level, fields and date range.
- Under Destination, pick the workbook and worksheet. Under Schedule, pick how often. Then Save and run.
Columns Meta Ads writes to Microsoft Excel
| Column | Format | Available at |
|---|---|---|
| Day | Date | Every level |
| Ad account | Text | Every level |
| Ad account ID | Text | Every level |
| Campaign | Text | Campaign, Ad set, Ad |
| Campaign ID | Text | Campaign, Ad set, Ad |
| Ad set | Text | Ad set, Ad |
| Ad set ID | Text | Ad set, Ad |
| Ad | Text | Ad |
| Ad ID | Text | Ad |
| Impressions | Whole number | Every level |
| Reach | Whole number | Every level |
| Frequency | Number | Every level |
| Clicks (all) | Whole number | Every level |
| Amount spent | Money | Every level |
| CPC (all) | Money | Every level |
| CPM (cost per 1,000 impressions) | Money | Every level |
Days are in your ad account's time zone.
An example
Insert a PivotTable on a separate worksheet that reads from the Spend by campaign worksheet, with Campaign in Rows and Amount spent in Values.
Scheduling and refresh
Each run replaces the worksheet with the latest figures.
Try it with your own Meta Ads data in Excel.
Other ways to do it
Meta Ads Manager can export your reporting table as a CSV or Excel file, and email it on a schedule to people who have access to the ad account.
Source: Meta Business Help: Export performance data in Meta Ads Manager; Meta Business Help: Export and share data
Fresh Sheets writes the figures straight into your worksheet instead, on a schedule.
What this doesn't cover
Lead form submissions and organic posts aren't included. This reads Meta Ads reporting only.
Only the worksheets your reports use
It reads file, folder and worksheet names so you can choose where a report goes, replaces only each report's own worksheet, and creates a workbook only when you ask. Nothing else in your OneDrive changes.
Questions
How is this different from Meta Ads Manager for Excel?
Meta Ads Manager for Excel is Meta's own add-in: you sign in with Facebook inside Excel, then run and refresh reports from the workbook. Fresh Sheets runs on our servers instead, so the worksheet updates on your schedule without the workbook being open.
Do I need a work or school Microsoft account?
Yes. Fresh Sheets writes to workbooks in OneDrive through a work or school Microsoft account. The Facebook account you connect for Meta Ads can be any account with access to the ad account.
Other sources to Microsoft Excel
Analytics
Advertising
Last checked 25 October 2026
Send your Facebook Ads reports to Excel
Excel is on every plan, Free included.
30 days of Plus, free from sign-up. No card needed.
Paid plans from £12 a month, billed annually. After 30 days, one report keeps refreshing weekly for free; the rest pause, and nothing is deleted.