Smartlead lead CSV formatter: email, names and company in one clean file
In short: Upload any export (.xlsx or CSV) or paste cells. The tool writes email, first_name, last_name and company with lower-case emails, splits full names, merges repeats and drops rows with no valid email. Limit: Only email, first_name, last_name and company are written; add other variables as columns.
Smartlead's API says each lead needs at minimum an email, plus fields such as first_name, last_name and company, and its help center says other columns map to custom variables, up to 40 per lead. Upload your export here to get email, first_name, last_name and company, cleaned and de-duplicated.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. Check your list free nowSee pricing
Sample result
Jane Doe at Northwind becomes one row with email, first_name, last_name and company; the phone-only row is left out.
- Rows
- 2 leads
- Required
- Repeats merged
- 1
What this means for you
Email is the one required field, so rows without a valid address are counted and dropped.
- Snake-case headers
- Names split, emails cleaned
- Repeats merged
- CSV for the upload
- Smartlead
- Leads
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Check the addresses before they go into Smartlead.
- Export the email column from the file you just made, or use the check button under the result.
- Upload or paste it at /verify. Every address gets a live mailbox check, and the first 100 email checks are free with a Google sign-in, no card.
How do I prepare a lead file for a Smartlead campaign?
- Upload the export (.xlsx or CSV), or paste the cells with the header row first.
- Check the columns found and how many rows were left out for having no valid email.
- Download the CSV.
- In Smartlead, add leads to the campaign from a CSV and confirm how each column maps on the upload screen.
Example
- You enter
- A sheet with Full Name, Work Email, Mobile, Country, Company and Website:
Jane Doe,Jane@Example.com,(415) 555-0132,United States,Northwind,https://www.northwind.example/about;Leo Martinwithleo@example.org; l.martin@example.org; a repeat row forjane@example.com; and a row with only a phone,(212) 555-0100. - You get
- Two leads under email, first_name, last_name and company:
jane@example.com, Jane, Doe, Northwind, andleo@example.org, Leo, Martin. The repeat is merged, the second address in Leo's cell is dropped and counted, and the phone-only row is left out. - Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What does Smartlead need in a lead file?
Smartlead's lead-import API reference says each lead should contain at minimum an email field, plus fields such as first_name, last_name and company. Its help center says Name, Email and Location are matched automatically and that other columns can be mapped to custom variables, up to 40 per lead. See Smartlead's column mapping guide.
What does the tool write?
email, first_name, last_name and company, with emails lower-cased and trimmed and a full-name column split into first and last name. Columns with no data in your export are left out except the identity columns.
What is left out or changed?
Rows with no valid email are counted and left out. Repeats of an address are merged. If a cell holds several addresses the first is kept and the rest are counted. Variables in your email copy must match the names you map on upload, so check the mapping screen before you start a campaign.
Who uses this tool, and for what?
- Cold email teams
- Standardise exports from different enrichment tools before they hit a campaign.
- Agencies
- Give every client's campaign the same column names.
- Founders
- Clean a prospect sheet before the first sequence.
What can’t this tool tell you?
- Only email, first_name, last_name and company are written; add other variables as columns.
- Smartlead's own page doesn't list every accepted header, so confirm the column mapping on its upload screen.
- Name splitting follows Western name order.
- Campaign settings, block lists and sending limits are set in Smartlead, not here.
Common questions
- What does Smartlead require for a lead?
- An email. Its API reference says each lead should contain at minimum an email field.
- Which header names does Smartlead use?
- Its API example uses email, first_name, last_name and company. The upload screen lets you map any column, so confirm the mapping there.
- How many custom variables can a lead have?
- Smartlead's help center says up to 40 per lead.
- What happens to blank cells?
- Smartlead's guide says a blank cell leaves that value out of the email.
- Is my list uploaded to SimpleVerifier?
- No. The file is read and rewritten in your browser.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.