Prepare Your CSV or Excel File: Deals
Here's what you need to know about formatting your list of deals. To download an example CSV for deals, click here.
All files need to have column headers in the first row. Your headers do not need to match the names of fields in Pipeline exactly, but they should be descriptive enough to use for your own reference.
System and custom fields
To see what default fields are available for companies in Pipeline, view the list here.
If you have data that doesn't fit into one of the default fields, you will need to create custom fields before importing your data.
Associating to companies
To associate deals to companies, include a column for the company name and make sure the name matches what exists in Pipeline exactly.
Associating to People
To associate deals to people, you'll include a column for one of the following:
- Person Full Name
- Person Email
- Person ID
The Person Full Name must be unique.
The Person ID can be found by exporting people records from Pipeline, or by copying the number at the end of the URL of the person profile page.
In the mapping step of the import, map this column to 'Person (Full name, email, ID)'. Please note that you can associate more than one person to a deal. The first person that you associate to the deal will be the primary contact.