Pipedrive people import file formatter: rows that import, names included
In short: Upload any export (.xlsx or CSV) or paste cells. The tool writes First name, Last name, Email and Phone, splits full names, merges repeats and counts the rows Pipedrive would skip for having no name. Limit: Only First name, Last name, Email and Phone are written; map organizations, titles and custom fields in Pipedrive.
Pipedrive says people need a name, or a first and last name, and won't import items missing it; the file needs a header row, one tab, and stays under 200,000 rows and 50 MB. Upload your export here and it writes First name, Last name, Email and Phone, splits full names and counts rows with no name.
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 and Leo Martin become two people; the row with no name is counted, since Pipedrive won't import it.
- People
- 2 people
- Limit
- 200,000 rows, 50 MB
- Repeats merged
- 1
What this means for you
A person needs a name, so every row in the file has one, with its email and phone alongside.
- Full names split
- Rows with no name counted
- Size and row limit warnings
- Repeats merged
- Pipedrive
- People
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Check the addresses before they go into Pipedrive.
- 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 spreadsheet for a Pipedrive people import?
- 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 name.
- Download the CSV.
- In Pipedrive, open Import data, choose a spreadsheet, upload the file and check the column mapping before you start.
Example
- You enter
- A sheet with Full Name, Work Email, Mobile, Country and Company:
Jane Doe,[email protected],(415) 555-0132,United States,Northwind;Leo Martinwith[email protected]; [email protected]; a repeat row for[email protected]; and a row with only a phone,(212) 555-0100. - You get
- Two people under First name, Last name, Email and Phone: Jane Doe with
[email protected]and(415) 555-0132, and Leo Martin with[email protected]. The repeat is merged and the row with no name is counted as left out. - Limits
- Runs in your browser; nothing is uploaded. Files up to 25 MB.
What does Pipedrive require for people?
Pipedrive's spreadsheet import page says people require a name, or a first and last name, and that items missing mandatory fields won't be imported. The file should be XLS, XLSX or CSV with a header row, one tab per import, no more than 200,000 rows and under 50 MB. See Pipedrive's import guide.
How are columns matched?
Pipedrive maps spreadsheet columns to fields by column name and lets you assign any that don't match by hand, so the mapping screen is where you confirm the result. This tool writes First name, Last name, Email and Phone; fields such as organization or job title can be mapped from your own columns there.
Why include an email?
Pipedrive advises adding identifiers such as email or phone to reduce duplicates. The tool lower-cases and validates each address, and merges rows with the same address, so a re-import doesn't create two records for one person.
Who uses this tool, and for what?
- Sales reps
- Load a prospect list into Pipedrive without rows being skipped for missing names.
- Founders
- Move contacts from a spreadsheet to a first CRM with clean emails and phones.
- Sales ops
- Normalise exports from several sources before one import.
What can’t this tool tell you?
- Only First name, Last name, Email and Phone are written; map organizations, titles and custom fields in Pipedrive.
- Phone numbers are passed through as written, trimmed of extra spaces.
- Header names are matched by Pipedrive on its own mapping screen; confirm them there.
- Name splitting follows Western name order.
Common questions
- What is required to import a person into Pipedrive?
- A name, or a first name and a last name. Items without a name aren't imported.
- How large can a Pipedrive import file be?
- Pipedrive's page lists no more than 200,000 rows and a file under 50 MB.
- Which file types does Pipedrive import?
- XLS, XLSX or CSV, with one tab per import.
- Does Pipedrive match columns automatically?
- Yes, by column name, and you can assign unmatched columns yourself.
- 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.