How to Export Meta Ads Data to CSV (2026)

To export Meta Ads data to CSV, open Ads Manager, choose the level you want (Campaigns, Ad Sets or Ads), set the date range and columns, then use the Reports menu or the Export button to download the table as CSV or XLSX. The file contains exactly what your table shows, so the columns and date range you set before exporting decide what you get.

That is the short version. The rest of this guide covers the details that decide whether the file is actually usable for a client report: which columns to include, the export limits Meta does not make obvious, and what to do when the CSV opens as a mess in Excel.

The five-step version

1. Open Ads Manager and confirm you are in the right ad account.
2. Choose the level: Campaigns for a headline report, Ads for creative comparison.
3. Set exact start and end dates.
4. Apply your saved reporting columns.
5. Export the table as CSV (or XLSX).

Step 1: Open the right ad account

Agencies often manage many ad accounts, and exporting from the wrong one is the most common avoidable mistake. Check the account name in the selector before you export anything. You also need access to the ad account: if the Export option is missing or greyed out, ask the account owner to check your permissions.

Step 2: Choose the level

• Campaigns is the right level for a headline client report.
• Ad sets helps when you want to compare audiences or placements.
• Ads is for creative comparison, for example which video or image did the work.

If you only export once, export at the campaign level. If you need creative detail, export a second file at the ad level rather than mixing levels in one.

Step 3: Set the date range

Use exact calendar boundaries, such as the 1st to the last day of the month, instead of presets like "Last 30 days". A rolling preset moves every day, which makes last month's report impossible to reproduce later. Also remember that Meta reports by the ad account's time zone, so a client in another time zone may see day boundaries differ slightly from their own analytics.

Step 4: Set the columns

Build a reporting preset once, save it, and reuse it every period. The export contains only the columns visible in your table, so anything missing here will be missing from the file. A solid starting set for client reports:

Two details are worth knowing:

• Link clicks are not the same as clicks (all). "Clicks (all)" includes reactions, comments, shares and other interactions, while link clicks count only clicks that lead to the destination. For traffic and conversion reporting, link clicks and the link click-through rate are usually the cleaner numbers.
• Exports normally include "Reporting starts" and "Reporting ends" columns. They record the period the file covers, which helps when you archive files or load them into another tool.

Step 5: Export

In Ads Manager, open the Reports menu above the table and choose the export option, or use the Export button and pick the format. Meta's labels change slightly between accounts and over time, but the choice is always the same: CSV or XLSX.

• CSV is plain text and opens almost anywhere: Excel, Google Sheets, reporting tools and scripts. It is the safer choice for anything you plan to upload or process.
• XLSX opens directly in Excel with formatting intact and suits people who work only in Excel.

Ads Manager export vs Ads Reporting export

Meta has two export surfaces, and they behave differently.

If a template of yours feeds formulas, use the raw XLSX from Ads Reporting: its column names stay stable between exports, while the formatted version uses friendlier labels that can shift.

Limits and gotchas that trip people up

The details below come from Meta's export help page as summarized in a 2026 guide from Ads Uploader. Meta updates these rules, so check the help page if something behaves differently in your account.

• 37-month window. The start date of an export cannot be more than 37 months before today. If you want long trend lines, keep your own archive of monthly files.
• One breakdown per export. You cannot combine, say, age and placement in a single file. Each breakdown needs its own export.
• Some columns cannot be exported. Descriptive columns such as ad text, headline, destination URLs and targeting columns like age, gender and location cannot be exported to a spreadsheet. For performance by age, gender or placement, apply a Breakdown before exporting instead.
• Only visible columns export. If a metric is missing from the file, add it to your columns and export again.
• Large exports can time out. Shorten the date range or export campaign by campaign.
• Dynamic creative adds columns. Ads that use dynamic creative can add extra columns for each asset variant, which breaks formulas that expect a fixed layout.
• Scheduled emails only reach people with account access. For clients without access, send the file yourself.

If the CSV looks broken in Excel

If you double-click a CSV and see garbled characters or everything crammed into one column, do not edit it there. Open a blank workbook and use Data, then From Text/CSV, and set the delimiter and file encoding in the import wizard. That usually fixes accented characters, currency symbols and non-English campaign names.

Why the numbers may not match your other tools

Meta's export shows conversions under the attribution setting used for the report. Google Analytics, your store or your CRM count differently, so gaps are normal. In 2026 the gap changed shape, because Meta redefined how clicks and view-throughs are attributed. Read Meta attribution changes 2026 before you explain a mismatch to a client.

Turn the export into a client report

Once you have the file, you can build the report by hand, or let a tool do the assembly. The free MetriQuill tool reads the standard Meta export columns: campaign, ad set or ad name, amount spent, impressions, link clicks, CTR, CPC, CPM, results, purchase ROAS, reach, frequency and cost per result. If CTR, CPC, CPM, frequency or cost per result are missing, it calculates them from the other columns. If the file contains columns it does not recognize, it lists them rather than quietly ignoring them. No account is needed for the free tool. Its source code is on GitHub.

Two habits make this smoother:

• Name campaigns with the objective. MetriQuill infers the campaign type (traffic, lead, conversion, awareness, retargeting) from words in the campaign name and grades each campaign against benchmarks for that type. Campaigns with no recognizable word are graded against general defaults.
• Export one objective at a time when results differ. "Results" means something different for a lead campaign than for a traffic campaign, so mixing them in one report blends unlike numbers. See Meta Ads "Results" and cost per result explained.

Frequently asked questions

Can I export Meta Ads data to Google Sheets automatically? Meta has no built-in "send to Google Sheets" button. The manual route is to download a CSV and import it. Third-party connectors can sync on a schedule, but they add a monthly cost.

Should I export CSV or XLSX? CSV for anything you will upload or process, XLSX if you only ever open the file in Excel.

Why is there no age or gender column in my export? Meta does not export those descriptive columns to spreadsheets. Apply an age or gender breakdown before exporting and the values appear as rows.

How far back can I export? Up to 37 months from today, according to Meta's documentation as summarized above.

Do I need the API to export Meta Ads data? Not for one-off or monthly reports. The API and connectors matter for live dashboards, automation and fields that spreadsheet exports leave out.

Related reading

• Meta Ads Reporting for Agencies: 2026 Guide
• Facebook Ads report template for clients
• Meta Ads "Results" and cost per result explained

Last reviewed September 2026. Meta changes its export options from time to time, so confirm details in Meta's own help pages.