→

Sync Google Ads to Microsoft Excel automatically

Build Google Ads reporting in Excel with the report types, segments, and metrics you choose per tab. SyncRange refreshes worksheets in OneDrive or SharePoint on your schedule so spend and conversion tables stay current.

Google Sheets Microsoft Excel BigQuery Looker Studio Power BI

Start free Watch demo

Free plan · No credit card · From $19/mo

Overview: all destinations for Google Ads

How it works

Connect, choose data, open the report

Connect Google Ads securely with OAuth so SyncRange can read only the access your team approves.
Pick the fields your model needs and map them to Microsoft Excel, including deep store data basic extractors skip when available.
Open the report in a destination on the schedule you set, from daily to as often as every 15 minutes by plan.

SyncRange connects Google Ads to Microsoft Excel workbooks stored in OneDrive or SharePoint after you link your Microsoft account. Each export tab maps to a worksheet in the file you choose, with scheduled refreshes and append-or-replace behavior per tab.

Excel is a natural fit when your finance or ops team already standardizes on Microsoft 365. You get familiar formulas, pivot tables, and Power Query on data that stays current without repeating manual exports from each platform.

Export to Microsoft Excel

OneDrive or SharePoint workbooks that refresh on a schedule

Sync your Google Ads data into Excel workbooks stored in OneDrive or SharePoint. Each export tab maps to a worksheet in your file, with scheduled refreshes so your team always has up-to-date data in the spreadsheet tool they already use.

OneDrive and SharePoint: Create a new workbook or connect an existing .xlsx file from your Microsoft account
Worksheet per tab: Each export tab lands in its own worksheet with clean header rows
Familiar analysis: Use formulas, pivot tables, and Power Query without manual CSV downloads

Export schema

What we can export, and how it lands

Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination(worksheets in Google Sheets or Excel, or BigQuery columns) when you choose Microsoft Excel.

Campaign Performance

Google Ads export tab using report type 'campaign'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Campaign ID
Campaign Name
Campaign Status
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Ad Group Performance

Google Ads export tab using report type 'ad_group'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Ad Group Status
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Keyword Performance

Google Ads export tab using report type 'keyword_view'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Keyword ID
Keyword Text
Match Type
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Ad Performance

Google Ads export tab using report type 'ad_group_ad'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Ad ID
Ad Type
Final URL
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Shopping Performance

Google Ads export tab using report type 'shopping_performance_view'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Product ID
Product Title
Product Type (Level 1)
Product Type (Level 2)
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Date Exported

Geographic Performance

Google Ads export tab using report type 'geographic_view'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Country
Location Type
Region
State
City
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Search Term Performance (Search campaigns only)

Google Ads export tab using report type 'search_term_view'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Search Term
Status
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Performance Max Search Terms

Google Ads export tab using report type 'campaign_search_term_view'. Choose segments and metrics from the lists below; time grain and optional campaign filters are set per tab in SyncRange.

Columns
Date
Week
Month
Device
Search Term
Campaign ID
Campaign Name
Search Term Status
Impressions
Clicks
Cost
Conversions
Conversion Value
CTR
Average CPC
Cost per Conversion
All Conversions
All Conversion Value
Date Exported

Built for ecommerce teams and multi-brand operators

See how teams export clean ecommerce and marketing data to BigQuery, Google Sheets, or Excel without manual work.

SML Cakes

Shopify Store and Food delivery

★★★★★

Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.

Emma L.

Multi-brand Shopify Plus Operator

★★★★★

We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.

UPlay

Large marketplace

★★★★★

We struggled to find a Shopify extraction tool that went beyond basic product, order, and customer data until we found SyncRange. It effortlessly pulls everything we require, including metaobjects and custom fields. SyncRange's hands-on guidance has given us complete confidence.

Hydro Power

Large Shopify Store

★★★★★

SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.