Instantly lead CSV formatter: a clean file for the upload screen
In short: Upload any export (.xlsx or CSV) or paste cells. The tool writes Email, First Name, Last Name and Company Name 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 Name are written; add custom variables yourself.
Instantly's guide says the Email column is mandatory, the first row holds column names that start with a capital letter and run to 20 characters at most, and the file should be UTF-8 with no more than 50 variables. Upload your export here to get Email, First Name, Last Name and Company Name, 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 Name; the phone-only row is left out.
- Rows
- 2 leads
- Required
- Repeats merged
- 1
What this means for you
Email is the one mandatory column, so rows without a valid address are counted and dropped.
- Capitalised headers
- Names split, emails cleaned
- Repeats merged
- UTF-8 CSV
- Instantly
- 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 Instantly.
- 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 an Instantly upload?
- 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 Instantly, open the campaign, go to Leads, choose Upload CSV and confirm each column maps to the variable you expect before you upload.
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 Name:
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 Instantly require in a lead file?
Instantly's help center says the Email column is mandatory and must be mapped correctly. Column names go in the first row, start with a capital letter, are unique and run to 20 characters at most. The file should be UTF-8, with empty columns removed, extra whitespace trimmed and no more than 50 variables per upload. See Instantly's CSV import guide.
What does the tool write?
Email, First Name, Last Name and Company Name, in that order, with emails lower-cased and trimmed. A full-name column is split into first and last name. Columns your export has no data for are left out, except the three identity columns, so the upload screen has less to map.
What is left out or changed?
Rows with no valid email are counted and left out, because every Instantly row needs one. Repeats of an address are merged into one row. If a cell holds several addresses, the first is kept and the rest are counted; put each in its own row if you want them all loaded. Custom variables are not written; add them as extra columns after the download.
Who uses this tool, and for what?
- Cold email teams
- Turn an enrichment export into a file the upload screen maps on the first try.
- Agencies
- Prepare each client's list the same way before it goes into a campaign.
- Founders
- Clean a spreadsheet of prospects before the first send.
What can’t this tool tell you?
- Only Email, First Name, Last Name and Company Name are written; add custom variables yourself.
- Instantly maps columns on its own upload screen; confirm the mapping there, since this page can't see your workspace.
- Name splitting follows Western name order.
- Instantly's upload settings, duplicate checks and verification credits are set in the app, not here.
Common questions
- Which column does Instantly require?
- Email. Its guide says the Email column is mandatory and must be mapped correctly.
- Do Instantly column names need a certain format?
- The guide asks for names that start with a capital letter, are unique and run to 20 characters at most. The headers written here follow that.
- What encoding should the file use?
- UTF-8. The guide suggests exporting Excel files as CSV UTF-8.
- Can I add custom variables?
- Yes. Add columns after downloading; Instantly's guide says a custom variable name must match your column header, with up to 50 variables per upload.
- 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.