---
title: "How to add leads from Facebook Lead Ads to Excel"
description: "Keep your lead data organized by automatically moving new leads from Facebook Lead Ads to an Excel spreadsheet."
image: "https://images.ctfassets.net/lzny33ho1g45/61MH1qzk1ymPpaoQuWMPYY/48725563c7da5c05d138ea98f1a4eb8f/add-facebook-lead-ads-leads-to-excel-00-hero.jpg"
---

# How to add leads from Facebook Lead Ads to Excel

Keep your lead data organized by automatically moving new leads from Facebook Lead Ads to an Excel spreadsheet.

Just like an over-enthusiastic squirrel collects nuts for winter, I eagerly collect Facebook Lead Ads data with no idea how to efficiently organize it. 

If you're a marketer like me, you've probably had your share of spreadsheet chaos, too. 

Fortunately, you don't have to use a fuzzy rodent as a role model for your marketing workflows. Instead, you can use a Zap—Zapier's automated workflows—to automatically move your lead data from Facebook Lead Ads to an Excel spreadsheet. Let's get cracking.

## Before you begin

After setting up your Facebook Lead Ads campaign, you should create an Excel spreadsheet to collect your lead data. 

Create a new spreadsheet and give column headings for the info you're collecting. Facebook Lead Ads lets you collect everything from email addresses to phone numbers to company details. 

For this example, we added column headers for** Full Name**, **Email Address**, **Page Name**, and **Form Name**. 

## How to add new Facebook Lead Ads leads to Excel

Now, you're ready to set up your workflow. Zapier lets you create automated workflows called Zaps, which send your information from one app to another. You can [create your own Zap](https://zapier.com/editor) from scratch without any coding knowledge, but we also offer quick templates to get you started. 

If you'd like to start with a template, click on the Zap template to go to the Zap editor. You'll need to create a Zapier account if you don't already have one. Then, follow the directions below to set up your Zap.

### Set up your Facebook Lead Ads trigger

Let's start with the trigger—the event that starts your Zap. If you're using the Zap template, this will be selected for you. Otherwise, search for and select **Facebook Lead Ads** as the trigger app and **New Lead** as the trigger event, then click **Continue**.

Next, connect your Facebook account, if you haven't already, then click **Continue**.

To set up the trigger, select the _Facebook Page_ and _Form_ you'd like to use in this Zap. Then, click **Continue**. 

Now, it's time to test your trigger step. This will gather information from the Facebook Lead Ads form that will be used to set up the rest of your Zap. Before clicking **Test trigger**, make sure there's at least one submission in the form (you can [add a sample lead](https://help.zapier.com/hc/en-us/articles/8496061345805-Use-the-Facebook-Lead-Ads-testing-tool-to-create-sample-leads) if you don't have any submissions). 

Zapier will show you the most recent data from Facebook Lead Ads. Select which data you'd like to use to set up your Zap, then click **Continue with selected record**. 

### Set up your Microsoft Excel action

Now, it's time to set up the action, the event your Zap will perform once it's triggered. In this case, that's adding your Facebook Lead Ads data to Excel.

If you're using the Zap template, these will already be selected for you. Otherwise, search for and select **Microsoft Excel** as your action app and **Add Row** as your action event. Click **Continue**.

Next, connect your Microsoft Excel account, if you haven't already, then click **Continue**. 

Now, it's time to customize your action step. By default, Zapier will select your OneDrive account in the _Storage Source_ field. But, if you're a business customer, you can switch to **Sharepoint**.

Next, select the _Folder_ where your Excel spreadsheet is saved. If this is in the root OneDrive folder, you don't need to select anything here. 

In the _Spreadsheet_ field, select the spreadsheet you made to collect your lead data. Then select the appropriate worksheet in the _Worksheet_ field. By default, this will be **Sheet1**, but you can select a different worksheet if you need.

Once you've selected your spreadsheet and worksheet, the Zap will add fields for the columns you added earlier. Now, you can map the data you receive from Facebook Lead Ads to these columns so your spreadsheet is properly filled out each time a new lead comes in.

For our example, we'll map the **Email** data from Facebook Lead Ads to the _Email Address_ field, **Full Name** to the _Full Name _field, etc.

Once you've mapped all your fields, click **Continue**. 

Now, click **Test step** to run your Zap using the sample data you selected earlier. Open the Excel spreadsheet you created, and you'll find the sample data in a new row. 

Here's what our sample data looked like.

If everything looks right, you're ready to use your Zap. Now, every time you get a new lead in Facebook Lead Ads, it will go to your new Excel spreadsheet.