By the end of this guide, you'll know how to export all leads or specific segments from your campaigns, use filters to select exactly which leads to export, understand what data is included in the CSV file, and learn when to export versus push leads directly to another campaign.

Exporting leads is essential for:

Having clean, exportable data gives you flexibility and control over your lead information beyond lemlist's interface.

Before exporting leads:

When you export leads to CSV, the file includes:

✅ Basic lead information:

✅ Custom variables:

The CSV file can be opened in Excel, Google Sheets, or imported into other tools.

Step 1: Open your campaign

Go to Campaigns → Select the campaign you want to export leads from.

Step 2: Navigate to the Lead list section

Click the Lead list tab.

This shows all leads currently in the campaign.

Step 3: Select all leads and export

Click the checkbox at the top of the lead list to select all leads, then click Export as .CSV in the bulk actions toolbar.

Step 4: Download the file

The CSV file downloads to your computer (usually to your Downloads folder).

The file name typically includes the campaign name (e.g., Campaign_Name_Leads.csv).

Step 5: Open and verify the export

Open the CSV file in Excel, Google Sheets, or a text editor.

Verify that all expected leads and columns are present.

Step 1: Open your campaign and go to Lead list

Go to Campaigns → Select your campaign

Select Lead list tab.

Step 2: Open the filters and configure your criteria

Click the Filter icon near the search bar, select the criteria you want (for example: Status → Deliverable), then click Apply.

Step 3: Select all filtered leads and export

Click the Select All checkbox to select all leads currently visible (matching your filter), then click Export as .CSV in the bulk actions toolbar.

Step 4: Download and verify

The CSV file downloads contain only the filtered segment.

Open to verify that only the expected leads are included.

Step 1: Open your campaign and go to the Lead list

Go to Campaigns → Select your campaign → Lead list tab.

Go to the Lead list tab.

Step 2: Select individual leads and export

Check the boxes next to the specific leads you want to export, then click Export as .CSV in the bulk actions toolbar.

Goal: Get a list of all leads who replied so you can pass them to your sales team.

Steps:

Goal: Build a clean lead list with only verified, deliverable emails for a follow-up campaign.

Steps:

💡 Alternatively: Use "Push leads to new campaign" feature (faster than export + re-import). Learn more here.

Goal: Archive a complete backup of your campaign before making major edits.

Steps:

Goal: Identify and remove bounced emails from your master lead database.

Steps:

Marketing Agency Segments Leads for Client Reporting

A marketing agency runs a lead generation campaign for a B2B client. At the end of the month, the client requests a breakdown of lead quality.

Their workflow:

Export 1: All leads

Export 2: Deliverable leads

Export 3: Replied leads

Export 4: Bounced leads

Client report:

Result: Client has full visibility into lead quality and campaign performance. The agency used filters and exports to create segmented reports in under 10 minutes.

Export to CSV when:

✅ You need to analyze data outside lemlist (Excel, Google Sheets, CRM)

✅ You're sharing leads with someone who doesn't use lemlist

✅ You want to back up data before making changes

✅ You're migrating to a different tool or workspace

Push to new campaign when:

✅ You want to move leads to another lemlist campaign

✅ You're segmenting leads for different sequences (e.g., engaged leads get a demo sequence)

✅ You want to avoid the export → re-import process

💡 Faster workflow: If your goal is to get leads into another campaign, use "Push to campaign" instead of export + import. Learn more here.

Issue: The export file is empty or missing leads

Root cause: Filters may be too restrictive, or no leads match the criteria

Fix:

Issue: The CSV file won't open or shows garbled text

Root cause: Character encoding issue or file corruption

Fix:

Issue: Custom variables are missing from the export

Root cause: Custom variables may not have been populated for those leads, or export doesn't include empty columns

Fix:

Issue: I can't find the "Export" button

Root cause: No leads are selected

Fix:

Issue: The export includes leads I didn't want

Root cause: Filter wasn't applied correctly, or "Select All" selected more than expected

Fix:

Export regularly for backups: Set a monthly reminder to export all leads from active campaigns as a backup. Store these CSVs securely in case of accidental deletions or data issues.

Use descriptive filters: When exporting segments, name your export files clearly (e.g., Campaign_X_Replied_Leads_Dec2024.csv). This makes it easy to find the right file later.

Clean data before exporting: If you're sharing the export with others, review lead data in lemlist first. Fix obvious errors (misspelled names, incorrect companies) so the export looks professional.

Combine exports for analysis: Export multiple segments (replied, bounced, deliverable) and combine them in a master spreadsheet for comprehensive campaign analysis.

Export before major changes: Before editing sequences, deleting steps, or making bulk updates, export all leads as a safety net. If something goes wrong, you can re-import from the backup.

Use filters to find high-value segments: Export leads who replied AND clicked a link AND are from target accounts. Use multiple filters to isolate your hottest prospects.

Integrate with your CRM: Export replied leads weekly and import them to your CRM for sales team follow-up. Automate this with Zapier if possible.

Track export history: Keep a log (in a spreadsheet or doc) of what you exported and when. This helps with audits and ensures you don't duplicate work.

Export for A/B test analysis: Export leads from each A/B test variation separately (filter by tag or campaign) to compare performance in Excel or Google Sheets.