Close lead import file formatter: contacts with semicolon-separated emails
In short: Upload any export (.xlsx or CSV) or paste cells. The tool writes Company, Name, Email and Phone, joins several addresses in one cell with semicolons, writes phones as +country code and merges repeats. Limit: Only Company, Name, Email and Phone are written; add custom fields with the custom. prefix Close's guide describes.
Close's help center says the first row should be a header row it uses to guess field assignments, phone numbers need a + country code, several emails or phones go in one cell separated by semicolons, and a .csv upload is limited to 15 MB. Upload your export here to get that layout.
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
Used only to complete phone numbers.
Sample result
Leo's two addresses stay in one cell joined by a semicolon, and Jane's phone is written as +14155550132.
- Rows
- 2 contacts
- Multiple emails
- Semicolons
- File limit
- 15 MB
What this means for you
Close takes several emails or phones in one cell separated by semicolons.
- Company, Name, Email, Phone
- Several emails per contact
- +country-code phones
- 15 MB warning
- Close
- 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 Close.
- 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 CSV for a Close lead import?
- Upload the export (.xlsx or CSV), or paste the cells with the header row first.
- Choose the country used for phone numbers written without a + country code.
- Check the columns found, the rows left out and any size warning, then download the CSV.
- In Close, import leads from a CSV and confirm each column's assignment in the field dropdowns.
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 contacts under Company, Name, Email and Phone: Northwind, Jane Doe,
jane@example.com,+14155550132, and Leo Martin withleo@example.org;l.martin@example.org. The repeat is merged and the phone-only row is left out. - Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What does Close ask for in an import file?
Close's lead import guide says the first row must be a header row, which Close uses to guess field assignments, and that you can assign any column by hand. Phone numbers need an international + code, or Close falls back to your account country. Multiple emails or phones in one cell are separated by semicolons, and a CSV upload is limited to 15 MB. See Close's lead import guide.
What does the tool write?
Company, Name, Email and Phone. A first and last name column are joined into Name, every valid address in a cell is kept and joined with semicolons, and phone numbers are written with a + and country code. Columns your export has no data for are left out except Company, Name and Email.
Why group contacts in Close?
Each row here is one contact. If several people belong to one company, Close lets you group rows by a column such as Company after you click Next on the import screen. Close also notes that grouped contacts sharing an email or phone number are merged into one contact, so each person needs their own.
Who uses this tool, and for what?
- Sales teams
- Load an enriched prospect list into Close with phones ready to dial.
- Founders
- Move contacts from a spreadsheet into a first CRM.
- Agencies
- Prepare each client's leads the same way.
What can’t this tool tell you?
- Only Company, Name, Email and Phone are written; add custom fields with the custom. prefix Close's guide describes.
- Close guesses fields from headers, so confirm the assignment on its import screen.
- Rows are one contact each; grouping by company happens in Close.
- Phone numbers that can't be read are left blank and counted.
Common questions
- How does Close handle several emails for one contact?
- Separate them with semicolons in one cell. This tool does that for every valid address in a cell.
- What phone format does Close want?
- An international code with a +, for example +18334625673. Without one, Close uses your account's country.
- How big can a Close CSV be?
- Close's guide lists 15 MB per .csv upload; larger files must be split.
- Does Close need exact header names?
- No. It guesses from the header row and lets you assign columns by hand, so confirm the mapping on its screen.
- 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.