Microsoft Ads to Excel
Spend, clicks and impressions from Microsoft Advertising, by account, campaign, ad group or keyword, in a worksheet in your own OneDrive.
- Each report writes to a worksheet you choose, in a workbook in your OneDrive.
- Refreshes every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
- Up to 100,000 rows a report.
Your first scheduled report starts 30 days of Plus, free. No card needed.
Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.
Your Microsoft Advertising account can be personal or work.
How to connect Microsoft Ads to Excel
To get Microsoft Advertising to Excel you need a work or school Microsoft account with OneDrive, and access to the advertising account.
- 01On the Sources page, choose Connect Microsoft Advertising and sign in with the Microsoft account that has access to your advertising account.
- 02In Fresh Sheets, go to Destinations, choose Connect Microsoft Excel and sign in with your work or school Microsoft account.
- 03Choose New report, pick Microsoft Advertising and the account, then the level, fields and date range.
- 04Under Destination, pick the workbook and worksheet. Under Schedule, pick how often. Then Save and run.
Columns Microsoft Advertising writes to Microsoft Excel
Row one holds the column names. Money shows its currency symbol when a report has only one currency.
| Column | Format | Available at |
|---|---|---|
| Day | Date | Every level |
| Account | Text | Every level |
| Account number | Text | Every level |
| Account ID | Text | Every level |
| Campaign | Text | Campaign, Ad group, Keyword |
| Campaign ID | Text | Campaign, Ad group, Keyword |
| Campaign status | Text | Campaign, Ad group, Keyword |
| Campaign type | Text | Campaign, Ad group |
| Ad group | Text | Ad group, Keyword |
| Ad group ID | Text | Ad group, Keyword |
| Ad group status | Text | Ad group, Keyword |
| Keyword | Text | Keyword |
| Keyword ID | Text | Keyword |
| Keyword status | Text | Keyword |
| Match type | Text | Keyword |
| Delivered match type | Text | Keyword |
| Impressions | Whole number | Every level |
| Clicks | Whole number | Every level |
| Spend | Money | Every level |
| Average CPC | Money | Every level |
| Average CPM | Money | Every level |
| Quality score | Whole number | Keyword |
Fresh Sheets requests days in your advertising 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 Spend in Values.
Scheduling and refresh
How often depends on your plan: every week on Free, every day on Plus, every 6 hours on Pro and every hour on Max.
Each run that succeeds counts once towards your plan, wherever it sends.
Each run replaces the worksheet with the latest figures.
Other ways to do it
Microsoft Advertising can download a report as a file, and email one to you on a schedule.
Source: Microsoft Advertising Help: Create and schedule reports
Either way that's a new file each time. Fresh Sheets writes the figures straight into your worksheet instead, and it works the same for Bing Ads to Excel: Bing Ads is Microsoft Advertising's old name.
Only the worksheets your reports use
While you choose where a report goes, Fresh Sheets reads the names of the files and folders in your OneDrive and shows you only folders and workbooks. When a report refreshes, it reads and replaces that report's own worksheet. It creates a new workbook only when you ask it to, and doesn't change or delete anything else in your OneDrive.
Other sources to Microsoft Excel
Analytics
Advertising
Last checked 22 October 2026
Send Microsoft Advertising to Excel
Excel is on every plan, Free included. Sign in on the web with Google or a work or school Microsoft account, connect Microsoft Excel and build your first report.
Your first scheduled report starts 30 days of Plus, free. No card needed.
Sign in with Google or a work or school Microsoft account, then connect Excel. You only need Google for a Google source such as GA4.
Your Microsoft Advertising account can be personal or work.
Paid plans from £12 a month, billed annually. After 30 days, choose a plan or stay free: one report keeps refreshing weekly, the rest pause, and nothing is deleted.