How to Export Meta Leads: CSV and Excel, Step by Step
Your lead form is live, the leads are coming in, and now someone needs them. The sales rep wants a spreadsheet. The client wants the names emailed over. And you are sitting in Meta’s Business Suite hunting for the download button, which is never quite where you left it. Exporting Meta leads is genuinely simple once you know the three places it can happen, but Meta hides the export behind a Page tool rather than putting it next to your campaigns, which is why the job so often ends with someone copying rows by hand.
This post covers exactly how to get lead data out of Meta as a file you can actually use, what the file contains, what it does not contain, and the timing rules that catch people out.
Where the leads actually live
The first thing to understand is that Instant Form leads do not belong to your ad account. They belong to the Facebook Page that ran the ad. That single fact explains most of the confusion.
It means:
- If you have access to the ad account but not the Page, you cannot download the leads. You will see the lead count in reporting and be unable to open the list.
- Two clients sharing a Page will have their leads mixed in the same download.
- Leads are grouped by form, not by campaign. If you duplicated a form for two campaigns, you get two separate lists.
- Removing someone from the ad account does not remove their access to the leads. Page roles are managed separately.
Before you promise a client a lead export, check you have a Page role with lead access on the Page in question. Doing that first saves the awkward message later.
Method one: download from Meta Business Suite
This is the route most people mean when they ask how to export Meta leads, and it works for any form on a Page you have access to.
- Open Meta Business Suite and switch to the correct Page in the account picker at the top left. Pick the wrong Page here and the download comes back empty.
- Find the All tools menu, then Instant Forms. Depending on your layout it may sit under Leads Center or Lead Ads Forms Library.
- You will see a list of every form on the Page, active and inactive, with a lead count against each.
- Select the form you want. Choose Download and pick your file type.
- Choose the date range. Meta will offer options like all leads or leads since your last download.
- Confirm, and the file lands in your browser downloads.
You get a choice of CSV or XLSX. Pick XLSX if the file is going to a client who will open it in Excel, because CSV files with commas inside a field can render badly depending on the reader’s regional settings. Pick CSV if the file is going into another system.
The “since last download” option is convenient and easy to misuse. It hands you only what has not been pulled before, which is fine right up until you are not the only person pulling. On a Page several people can reach, nothing in the file tells you what a colleague’s earlier download already took. When in doubt, take the full range and deduplicate on the lead id.
Method two: download from the Page directly
If you are working on a Page without full Business Suite access, there is a shorter path. Go to the Page, open Publishing Tools or the Page’s professional dashboard, and find Forms Library. The same download control lives there, with the same file options.
This route is worth knowing because it often works when someone has been granted a Page role but not a Business Manager asset assignment. It is the fastest way to unblock a client’s sales team who just need the names.
Method three: export from your dashboard
If you manage several accounts, the per-Page download becomes a chore. You are switching Pages, remembering which form belongs to which campaign, and repeating the whole thing every Monday.
In DashOps, Instant Forms sit alongside the campaigns that use them, so you can see a form, see which ad sets are running it, and export the leads as CSV or Excel from the same screen. Because the form is shown in the context of the campaign, you do not have to guess which of three similarly named forms is the live one.
The point is not that the file is different. It is the same lead data Meta holds. The point is that you are not leaving the reporting tool to fetch it.
What is actually inside the file
Open the export and you will find one row per lead, with columns that map to your form. Typically:
- A unique lead id. This is the field to deduplicate on, not the email address, because someone can submit twice with the same email.
- A created time for each lead. Check which timezone it is expressed in before you reconcile the file against a report set to the ad account’s own timezone, or the two will not line up and you will go hunting for a problem that is not there.
- Standard fields the user did not type, prefilled from their profile: full name, email, phone number.
- Every custom question you added, one column each, with the exact question text as the header.
- Campaign, ad set and ad ids, plus their names, so you can attribute the lead back to the creative that produced it.
- Any tracking parameters you configured on the form.
Two things are not in the file. There is no lead score or quality rating of any kind. And there is no indication of whether a phone number was typed by hand or prefilled, which matters more than people expect. A prefilled number can be out of date. If phone accuracy matters to your client, the fix belongs in how you build the form, not in what you do at export time.
If your export has fewer columns than you expected, the cause is nearly always the form itself rather than the download. Adding the right fields at build time is covered in the complete guide to Facebook lead gen form best practices, and the specific art of asking a question that filters rather than annoys is covered in qualifying questions in Meta lead forms.
The timing rule nobody mentions until it bites
Meta does not keep lead data on the form forever. There is a retention window after which leads are no longer available to download, and it applies from the moment each lead is submitted. This is not a bug or a setting you can change.
The practical consequence: manual exporting is fine as a workflow only if it actually happens on schedule. A form quietly collecting leads while everyone assumes someone else is downloading them is how a client discovers a gap in their pipeline months later.
Two habits protect you:
- Pick a fixed cadence per client and put it in the same recurring slot as your reporting. If you already run a weekly reporting routine, attach the lead pull to it. There is more on building that habit in how to reduce time spent on Facebook Ads reporting.
- Make someone accountable by name. “The agency downloads them” is not a name.
If leads matter to the client’s revenue, the export is not an admin task. It is delivery.
Consent, permissions and who gets the file
A lead export is a file of real people’s names, email addresses and phone numbers, sitting in your downloads folder and then in an email attachment. Treat it accordingly.
Before you send one:
- Check the recipient is the person the form’s own privacy notice said would receive the data. The form told the user who they were giving their details to. Honour that.
- Send it to a named individual, not a shared inbox that half the client’s office can read.
- Delete your local copy once it has been handed over. The export is a transfer, not an archive.
- If a lead asks to be removed, remember the file you sent is now the client’s copy too, and tell them.
The consent language on the form is what makes all of this legitimate. If you have not looked at it recently, lead form privacy and consent covers what the intro and disclaimer need to say.
What to do next
Open Business Suite, switch to your busiest client’s Page, find their live form and download the full lead history right now. Two things will happen. You will confirm your access works before you need it in a hurry, and you will see whether the columns match what the sales team has been asking for.
If the columns are wrong, fix the form, not the spreadsheet. If the access is wrong, fix the Page roles today rather than the morning a client asks. And if you are managing more than a couple of accounts, move the export next to your reporting so it stops being something you have to remember.
Frequently asked questions
How do I export Meta leads as a CSV or Excel file?
Why can I see my lead count but not download the leads?
What columns are included in a Meta lead export?
How often should I export leads from Meta?
Can I connect Meta leads directly to my CRM instead of downloading files?
See it in your own dashboard
DashOps brings Meta Ads reporting, campaign management, and white-label client portals into one place. Pick the plan that fits how you run ads.