How to export Google Ads Transparency Center to Excel or CSV
Google Ads Transparency Center (adstransparency.google.com) shows the ads any verified advertiser runs on Google Search, YouTube, Display, Shopping and other Google surfaces. It is free and public, but it shows a grid of ads a few at a time and has no export or download button. Here are the ways to get that data into a spreadsheet.
What data the Transparency Center has
| Field | Where you see it |
|---|---|
| Advertiser name, verified ID (starts with AR) and country | Advertiser page header |
| Ad format: text, image or video | Format filter and each ad card |
| First shown and last shown dates | Ad detail page |
| Regions and impression ranges (when Google reports them) | Ad detail page, region filter |
| The creative itself (image, text preview or video) | Ad card |
Option 1: copy by hand
- Open adstransparency.google.com and search for the advertiser or website.
- Set the region and format filters, then scroll the grid until every ad has loaded.
- Open each ad to read its dates and regions, and copy them into a sheet.
Fine for 10 ads. For an advertiser with hundreds of ads it takes hours, and the dates and regions are only on each ad's own page.
Option 2: aska Ads (one click)
- Install aska Ads and click its icon. The exporter opens in a tab.
- Type a domain such as
nike.com, an advertiser name, an AR… ID, or paste an advertiser link. - Pick CSV or Excel (and the creatives ZIP if you want images), then press Export.
You get one row per ad with advertiser, domain, creative ID, format, first and last shown, days running, impressions, regions, image link and a link back to the ad. In our tests on 16 November 2026 aska Ads exported 600 ads for nike.com in under 4 seconds. The free version exports up to 100 ads per run as CSV; Pro removes the limit.
Option 3: write a script
The Transparency Center page loads its data from internal requests that are not a documented public API, so a script can break when Google changes them. If you go this way, keep the request rate low and back off when Google returns errors or a “sorry” page. aska Ads does both for you.
Tips for a useful export
- Search by domain to catch ads run by agencies and resellers for the same site; use the AR ID for one exact advertiser account.
- Sort by days running: ads that run for months are usually the ones that convert.
- Export the same advertiser every month and compare creative IDs to see what is new.