How to import Stripe data into HubSpot
Stripe customer exports include a single 'Customer Name' field. This template splits it into first and last name, then maps email, phone, and full billing address to HubSpot properties. The Created date and Description are combined into the Notes property as 'Stripe created: <date> | Stripe note: <text>' so reps see signup timing and internal context anchored to each label.
Field-by-field mapping
This is the complete column mapping from Stripe to HubSpot. The left column is the header in your CSV export. The right column is the HubSpot field it should map to.
| Customer Name | First Namefirstname First word extracted as first name. TransformSplit on first space | |
| Customer Name | Last Namelastname Remaining words used as last name. TransformSplit on first space | |
| Customer Email | Emailemail TransformLowercased and trimmed | |
| Phone | Phone Numberphone TransformStandardized to international format (+1, +44, etc.) | |
| Address Line 1 | Street Addressaddress | |
| Address City | Citycity | |
| Address State | State/Regionstate | |
| Address Postal Code | Postal Codezip | |
| Address Country | Country/Regioncountry | |
| Created (UTC), Description | Notesnotes Each value is prefixed with its label ('Stripe created: <date>', 'Stripe note: <text>') and joined with ' | ', so reps see the source context in HubSpot's Notes property. TransformCombined with ' | ' separator and label prefixes |
Formatting and cleanup
Stripe exports rarely match the format HubSpot expects. Fix these before you import.
- 1.Splits Customer Name into first name and last name (e.g. 'Jane Smith' becomes 'Jane' + 'Smith')
- 2.Lowercases and trims email addresses
- 3.Standardizes phone numbers to international format (+1, +44, etc.)
- 4.Combines Created date and Description into the Notes property as 'Stripe created: <date> | Stripe note: <text>'
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 HubSpot.
Stripe to HubSpot 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.
How does the name splitting work?
Stripe exports a single 'Customer Name' field. The template takes the first word as the first name and everything after as the last name. For example, 'Jane Smith' becomes 'Jane' + 'Smith'. A single-word name (e.g. 'Madonna') goes to First Name and leaves Last Name empty. HubSpot doesn't require Last Name, so the contact still imports.
What about subscription and payment data?
This template maps contact fields, Created date, and Description only. The customer export doesn't include subscription details, payment history, or invoice data.
Where does Created (UTC) end up?
Created (UTC) lands in the Notes property as 'Stripe created: <date>', combined with the Stripe Description using a ' | ' separator. HubSpot's own createdate field is set by HubSpot when the contact is imported, so we don't overwrite it. If you want the Stripe signup date as a sortable property, create a custom date property in HubSpot called Stripe Created and re-run this template.
What happens to the Description field?
Stripe descriptions are internal notes about each customer. They land in the Notes property as 'Stripe note: <text>' alongside the Stripe Created date, so reps see them when reviewing the contact.
Will this create duplicates in HubSpot?
HubSpot uses email as the unique identifier. Contacts with matching emails update the existing record. New emails create new contacts.