How to import Stripe data into Pipedrive
Stripe customer exports include a single 'Customer Name' field that lines up nicely with Pipedrive's single Name field. This template maps Customer Name directly to name, then maps email and phone. Stripe's billing address, internal description, and creation timestamp don't have a default Pipedrive home. The section below explains what to do with each one if you need it.
Field-by-field mapping
This is the complete column mapping from Stripe to Pipedrive. The left column is the header in your CSV export. The right column is the Pipedrive field it should map to.
| Customer Name | Name*name Pipedrive uses a single Name field. Stripe's Customer Name maps directly into it. | |
| Customer Email | Emailemail TransformLowercased and trimmed | |
| Phone | Phonephone TransformStandardized to international format (+1, +44, etc.) |
Required by Pipedrive.
Columns we don't use
Your Stripe export includes 7 columns this template doesn't map. Each one below explains why, plus the workaround if you want the data in Pipedrive.
- Address Line 1, Address City, Address State, Address Postal Code, Address Country
Pipedrive contacts don't store address fields by default. Billing addresses live on organizations.
If you need it. If you need the address on the contact, add custom address fields in Pipedrive and re-run this template. Otherwise create a Pipedrive organization for the customer and let the organization address handle it.
- Description
Stripe descriptions are free-text internal notes on each customer. Pipedrive Notes attach as separate records on the contact, not as a field value.
If you need it. Add a custom multi-line text field on the Pipedrive contact called Imported Description, then re-run this template to map Description. Or import descriptions as separate Notes in Pipedrive after the contacts are in.
- Created (UTC)
Pipedrive sets the contact's Add Date on import. The Stripe signup timestamp doesn't carry over.
If you need it. If you want to preserve the original Stripe signup date, add a custom date field on the Pipedrive contact called Stripe Created, then re-run this template to map it.
Formatting and cleanup
Stripe exports rarely match the format Pipedrive expects. Fix these before you import.
- 1.Maps Stripe's Customer Name directly to Pipedrive's name field (no split needed)
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
Or skip the manual work
Operelio runs this cleanup and mapping for you. Upload your Stripe export and download a clean, import-ready file for Pipedrive.
Stripe to Pipedrive FAQ
How do I export customers from Stripe?
In your Stripe Dashboard, go to Customers, then click the Export button at the top-right of the customer list. You can filter by date range or status before exporting.
Why is name a direct map and not split?
Both Stripe and Pipedrive use a single name field for the contact, so the data lines up directly. No splitting needed.
Where does the billing address go?
Stripe billing addresses don't map to Pipedrive contacts by default. See 'Columns we don't use' below for two options: add custom fields on the contact, or create a Pipedrive organization that holds the address.
Will this create duplicate contacts in Pipedrive?
Pipedrive's import dedupes on Name plus one of email, phone, or organization. A Stripe customer matches an existing Pipedrive contact when the name and either email or organization align. Customers whose Stripe Name field differs from the Pipedrive contact's Name create a new contact even when the email matches.
Where do I import the CSV into Pipedrive?
In Pipedrive, go to Tools > Import data > From a spreadsheet, and upload the file Operelio produces. The import wizard matches the column headers to Pipedrive fields.