Lead Ads CSV Cleaner for Facebook: Make Your Leads Download CRM-Ready

How to clean your Facebook leads download

A Facebook leads download is built for Meta, not for your CRM. IDs carry letter labels, dates come with a time zone offset, phone numbers often arrive with a “p:” stuck to the front, and your custom questions become column names with underscores. This cleaner fixes all of that in your browser, using the columns Meta lists on its information included in your leads data page.

1. Download your leads from Meta. In Ads Manager, click the number in the Results column, choose On-Facebook leads, set your filters and download a CSV or XLS. The Instant forms page in Meta Business Suite gives the same file. Then drop it here, or click Try sample data.
2. Check the matched columns. The tool finds Meta's standard columns and the usual contact questions (full name, email, phone number, city, ZIP code). Every other question stays as its own column.
3. Pick your settings. Choose the default country for phone numbers without a country code, the time zone your sales team works in, and the column names your CRM import expects.
4. Read the problems. Invalid emails and phones, typos and leads you can't contact are listed by row, each with a fix.
5. Download the clean file. Get the file for your CRM, plus a file with the duplicates that were merged. Every row taken out is also listed in the problems.

What gets fixed

• Phones: a leading “p:” is removed when your file has one (Meta's help pages don't mention it), and numbers are written as E.164, like +16175550132.
• IDs: labels like ag: and c: are stripped. Because a bare 16-digit ID gets rounded by Excel, the main download is then an Excel file with IDs stored as text.
• Names and answers: full names are split, “MIA” becomes “Mia”, and within_1_month reads “within 1 month”.

What to do next with your leads

1. Import the file into your CRM. Map Email, Phone, First Name and Last Name to contact fields and the question columns to custom fields. Keep the Lead ID column.
2. Keep the lead ID for later. If you send lead stages such as qualified or converted back to Meta, they are matched by lead ID (How to find the Meta lead ID).
3. Set a download routine. Leads expire from the download after 90 days, so download at least monthly, or weekly while a campaign runs.
4. Stop paying for the same people. Upload your leads as a Meta customer list and exclude it from your lead campaigns.
5. Plan a CRM integration. For ongoing use, Meta recommends the API or a CRM integration over the manual download. Either one removes the 90-day risk, because leads reach your CRM without anyone having to download them.

Common problems with Facebook lead downloads

The download has fewer leads than the Results column

Meta only lets you download leads from the last 90 days, even when Ads Manager shows Lifetime results. Older leads can't be recovered from Meta.

Blank ad ID, ad set ID or campaign ID

These leads were organic, came from an ad preview, or were downloaded by someone without a role on the ad account. The cleaner keeps and counts them. Leads made with Meta's lead ads testing tool are organic too and hold dummy data, so delete those before you import.

Whole columns are empty or the download button is missing

You need leads access. Meta asks for Page admin with full control plus a role on the ad account to see all lead data. Ask the Page owner or business admin to give you that access.

Leads Center CSV without your custom questions

The Leads Center download is limited to date, name, email, phone, stage, source and owner, and to 10,000 leads per file. For ad, form and question columns, download from Ads Manager or the Instant forms page.

facebook lead export phone number prefix (“p:”)

Many lead files show phone numbers as p:+16175550132. A CRM stores that as text, and many dialers and SMS tools can't use it. The cleaner removes the prefix and checks each number for its country.

Long IDs turned into 1.20E+17

Meta lead IDs are 15 to 17 digits long. With the label in front they stay text, but a bare ID in any CSV, including the clean one, is rounded when Excel opens it, and saving loses the last digits. Use the Excel download, Google Sheets or your CRM's importer instead.

The same person appears twice

People often send a form twice, from another device or another ad. The cleaner matches by lead ID, email and phone, keeps the first submission and fills its blanks. If the second one has a different email, phone or answer, both rows stay and you are told why.