How to export ads manager data to CSV

The ads manager can export whatever you're currently looking at to a CSV file, ready to open in Excel, Google Sheets or Numbers. The export is a snapshot of your current view — the same rows, columns and order you see on screen — so it's worth setting up the table first. If you're new to the table itself, start with How to view and navigate the ads manager.

Export the current view

The Export button sits in the toolbar above the table, next to the Columns button.

1. Open the Ads Manager and choose the tab you want to export — Campaigns, Ad sets or Ads.
2. Set your date range, search filter and any breakdown so the table shows exactly the rows you care about.
3. Click Export. A CSV downloads immediately to your browser's downloads folder.

The file is named ads-manager-<level>-<date>.csv (for example ads-manager-campaigns-2026-06-10.csv), so exports from different tabs and days won't overwrite each other. The CSV includes a UTF-8 byte-order mark, which keeps accented characters and currency symbols intact when you open it in Excel.

What the export contains

The export mirrors your table, not a fixed report:

• Every visible column becomes a column in the CSV, in the same left-to-right order you've arranged them.
• A Name and ID column are always added at the front, so each row is identifiable.
• Values are exported as raw numbers — spend, CPM, ROAS and the like come through without currency symbols or thousands separators, which is what you want for further math in a spreadsheet.

A couple of things to keep in mind:

• The export covers the rows currently loaded into the table, across all pages — not just the page you're viewing. The page-size selector at the bottom doesn't limit the export.
• If the table shows "more available" (Meta still has additional rows behind a cursor), the Export button's tooltip tells you it will only export the loaded rows. Click Next to load more pages first if you want everything included.
• The Export button is disabled when there are no rows to export — for example when a search filter matches nothing.

Customize the columns before you export

Because the CSV follows your visible columns, the Columns button is where you shape the export. Open it to pick a preset or build a custom column set.

• Presets apply a curated column set in one tap — for example Meta default, Shop, Performance, Clicks, Conversions or Video.
• Visible columns are a draggable list. Drag the handle to reorder them, or click Hide to remove one. The order here is exactly the order they'll appear in the CSV.
• Hidden columns are grouped by category (Settings, Performance & reach, Engagement, Clicks, Conversions, Video). Click Add on any of them to bring it into the view.
• Save a column set you like with Save current as preset… so you can reapply it later. Saved presets sync to your account, so they follow you across devices.

For more on shaping the table — including metric breakdowns — see How to preview ads and view metric breakdowns.

Columns are remembered per level

Each level keeps its own column setup. The columns, their order and their widths you choose on Campaigns are remembered separately from Ad sets and Ads, just like Meta's own ads manager. Switch tabs and the table restores the layout you last used there.

Your preferences are stored both locally (for instant display) and on your account, so they persist across sessions and devices. In practice this means you can set up a clean export layout once per level and it'll be ready every time you come back to export.