How to export the Meta Ad Library to CSV or Excel
Updated 2026-11-21 · AdHarvest guides
The Meta Ad Library (facebook.com/ads/library) shows every active ad a Facebook or Instagram page is running — but there is no export or download button. If you want ads in a spreadsheet to sort, filter or share with your team, you have three options.
Option 1: Copy ads by hand (free, slow)
Search the Ad Library
Open facebook.com/ads/library, choose a country and All ads, then search a brand name or keyword.
Set up your spreadsheet
Create columns for the details you care about — for example: brand, ad copy, start date ("Started running on"), number of versions, format (video/image/carousel), call-to-action and landing page.
Copy each ad's details
For every ad, copy the text, note the start date, and click the ad's link to find the landing page. Repeat for each ad you want to keep.
Save as CSV
In Excel or Google Sheets, use File → Save as / Download → CSV.
This works for a handful of ads. For 50+ ads it takes hours, and you miss details the page doesn't show plainly (like the real landing page behind Facebook's redirect links).
Option 2: The official Ad Library API (technical, limited)
Meta offers an Ad Library API. It requires a developer account and identity verification, and its coverage is mainly ads about social issues, elections or politics (plus ads shown in the EU). For most commercial ads you'd research as a marketer, it won't return what you see on the website — and you'd need to write code to turn the results into a CSV.
Option 3: Export in one click with a Chrome extension
A browser extension can read the ads the Ad Library page has already loaded and write them to a file. With AdHarvest:
Install AdHarvest
Add it to Chrome (free) and pin it to your toolbar.
Search the Ad Library as usual
Ads are captured as the page loads. Use Auto-Scroll to collect more without scrolling yourself.
Click CSV
You get an Excel-safe UTF-8 CSV with 41 named columns — winner score, hook tags, days running, active ad sets, start/end date, ad copy, headline, CTA, unwrapped destination URL, landing domain, HD media links and more.
AdHarvest exports the ads you're viewing in the Meta Ad Library to CSV, Google Sheets or Airtable in one click — 41 columns including winner score, hook tags, days running, ad sets and the real landing page. Free for 25 rows per export.
Which columns are worth exporting?
- Days running — the best single signal of a profitable ad. Brands don't keep paying for losers.
- Active variants / ad sets — an ad duplicated across many ad sets is being scaled.
- Landing page (unwrapped) — the real URL, not Facebook's redirect, so you can study the funnel.
- Media URL — links to the video or image (note: these links expire after a while; see how to save ads permanently).
FAQ
Is it allowed to export the Ad Library?
The Ad Library is public, and copying information you can see is common practice for research. Respect Meta's terms, don't reuse other brands' creatives as your own, and use the data for analysis.
Why does my CSV look broken in Excel?
Ad copy often contains emojis and commas. Use a UTF-8 CSV (AdHarvest's export includes the marker Excel needs) and open it via Data → From Text/CSV if characters look wrong.
Can I export to Google Sheets instead?
Yes — see how to get the Ad Library into Google Sheets.