CSV Template

Pipedrive peoplewithout the spreadsheet.

Collect contacts with a form that checks every row, and download a CSV named after Pipedrive's person fields, so matching columns during import takes seconds.

Pipedrive field namesNo duplicate emailsTry it free

Pipedrive People

Try the template with up to 3 people

What You'll Collect

Name

String
*Required

The person's full name. Pipedrive needs one for every person.

First Name / Last Name

String

Optional, for personalised emails and sorting.

Email

Email
Unique

Checked as a real email format. Each can appear only once, so nobody is imported twice.

Phone

Phone

Any common layout. Letters, Excel's scientific notation and too few digits are flagged.

Organization

String

The company they work for. Pipedrive links the person to an organization with this name.

Job Title

String

Their role at the organization.

Label

String

One of your Pipedrive labels, such as Customer or Hot lead.

Owner

String

The Pipedrive user who owns this person.

Postal Address

String

The full address in one cell.

Note

String

Anything worth knowing, added to the person as a note.

Need more than three people?

Collect up to a thousand people instead.

The free template is limited to three rows so you can try the workflow. Create your own Import Builder form when you need a colleague, partner or event organiser to send you their full list.

Create your own form

Up to 1,000 rows

Take a whole lead list, event attendee list or old CRM export in one go.

Pipedrive field names

Columns are named after Pipedrive's person fields, so mapping them is quick.

Checked as they type

Missing names, repeated emails and bad phone numbers are fixed before you get the file.

Reusable forms

Send the same form whenever new contacts need adding.

How it works

From contact list to Pipedrive import in three steps.

01

Collect

Send the form to whoever has the contacts: a sales rep, a partner or an event organiser.

02

Complete

They type, paste or import their list. Problems are highlighted until every row is fixed.

03

Download

Download the CSV and upload it with Pipedrive's Import data, matching each column to its field.

Why use a form?

A clean import starts with a clean list.

Contact lists arrive from everywhere: trade show scanners, spreadsheets from colleagues, exports from an old CRM. They come with blank names, broken emails and the same person three times.

A form fixes those problems where they start, with the person who knows the right answer.

Missing names

Pipedrive needs a name for every person. The form won't export until every row has one.

Duplicates

The same email twice means the same person twice. Repeats are highlighted before export.

Bad emails and phones

Typos are caught as they're entered, while the person who knows the right value is still there.

Pipedrive CSV template

Importing people into Pipedrive

Pipedrive imports people, organizations, deals and more from a spreadsheet. During the import you match each column in your file to a Pipedrive field. This template names its columns after Pipedrive's person fields (Name, Email, Phone, Organization and so on) so that step is quick.

The quality of the import depends on the list you start with. This form checks every email and phone number as it's entered, makes sure every person has a name, and highlights any email that appears more than once, so you don't end up with the same contact twice.

Use it when someone else holds the contacts: a sales rep joining from another company, a partner sharing leads, or an event organiser sending attendees. They can paste or import their existing spreadsheet and fix what's highlighted, rather than you cleaning it up afterwards.

Need custom fields, deals or organizations as well? Create your own form with the columns you use in Pipedrive. The export uses whatever headers you set, so they can match your field names exactly.

Need a CSV form of your own?

Create a custom Import Builder form with your own fields, validation and row limits.

Get started
Import Builder is an independent product and is not affiliated with, endorsed by, or sponsored by Pipedrive. Pipedrive is a trademark of its owner.