company logo

Help center

Go to Smartlead.ai
API Documentation
All collectionsAll Leads & Troubleshooting How to map CSV columns when importing leads

How to map CSV columns when importing leads

Match each column in your CSV to a Smartlead lead field or custom field when you upload leads to a campaign, so every variable fills in correctly.

When you upload a CSV of leads to a campaign, you match each column in the file to a Smartlead field. Mapped columns become lead fields and custom fields you can use as variables in your emails.

Before you start

Your CSV needs a column of email addresses. Every lead needs an email address, so you can't import until one column is mapped to Email.

Step 1: Open the lead upload

  1. In the left menu, click Email Campaigns and open your campaign.

  2. Open the Leads tab.

  3. Click Upload New CSV. If the campaign has no leads yet, click Add Leads.

Step 2: Choose your file

  1. Select Upload CSV File and choose your CSV.

  2. Click Continue.

Step 3: Choose your upload settings

On Upload Settings, each toggle, when on, lets a group of leads through that would otherwise be skipped:

  • Global Block List: leads on your block list are still imported. Keep it off.

  • Unsubscribe List: leads who unsubscribed are still imported. Keep it off.

  • Community Bounce List: leads that bounced for any Smartlead user are still imported.

  • Existing Campaign Leads: when on, leads that are already in other campaigns are not imported.

Community Bounce List is on by default. We recommend turning it off to reduce bounce rates.

Click Continue when you're done.

Step 4: Map your fields

On Map Your Fields, each CSV column has a dropdown. Smartlead pre-fills the columns it recognises.

  1. Check the columns that were matched automatically.

  2. Map your email column to Email.

  3. Map other columns to a standard field, or choose Custom Field to keep them as custom variables. The column header becomes the field name.

  4. Leave columns you don't need as Ignore Field.

  5. Click Import Leads.

When the upload finishes, you see a summary of the import.

Good to know

  • Custom fields belong to the lead, not the campaign. A lead has one record across your account.

  • Uploading a lead that already exists updates its saved fields, even if the row is skipped as a duplicate.

  • An empty cell in a mapped column blanks that field on an existing lead. Set columns you don't want to change to Ignore Field.

  • A variable in your email must match the field name exactly, including case and underscores.

If something goes wrong

  • Import Leads is greyed out: no column is mapped to Email. Map your email column to Email.

  • A variable shows up blank in an email: the lead's cell was empty, or the variable name doesn't match the column header exactly. Fix the CSV or the variable, then upload again.

Still stuck? Contact support from the chat in your Smartlead dashboard.

Related articles

  • How do I remove duplicates from different campaigns?

  • What is Global Block List? Your Comprehensive Cold Outreach Guide

Did this answer your question?
😞
😐
😁