Stripe Customers CSV Mapper — SchemaMap

SchemaMap/Stripe Customers CSV Mapper

Quick Start

Skip the reading and start mapping your customer CSV right now:

Try Sample Customers CSV

Step-by-step process

1. Export your customer CSV or prepare your source file

You can map any CSV with customer data. Common sources include:

Existing Stripe customer export (Dashboard → Customers → Export)
CRM system exports (Salesforce, HubSpot, etc.)
E-commerce platform customer data
Manual customer spreadsheets

💡 Pro tip

Don't have a CSV to test? Download our sample file:

Download sample customers CSV

2. Open the mapper

Open the Stripe Customers mapper and upload your CSV. The tool will:

Parse your file in the browser (never uploaded to our servers)
Auto-detect column mappings using smart fuzzy matching
Show you a preview of mapped fields

3. Check the auto-mapped fields; fix any unmapped ones

Review the mapping table. Required fields are highlighted in red if unmapped. Common mappings our tool recognizes:

Target Field	Common Source Names
Email	e-mail, email address
Name	full name, customer name, display name
Phone	telephone, phone number, mobile
Address Line 1	addr1, address1, street address, address

4. Review errors (invalid email formats, missing required fields)

The validator will check for common issues:

Required fields missing: Email (the only required field)
Invalid email format: Must be valid email addresses
Postal code formatting: Will be automatically uppercased
Country formatting: Will be automatically uppercased

⚠️ Common fixes

Email must be in valid format ([email protected]).
Country should be 2-letter code (US, CA) or full name.
Names will be properly capitalized automatically.
All address fields are optional except email.

5. Download the validated CSV and import to Stripe

Once validation passes, download your clean CSV. You can then:

Import directly to Stripe via Dashboard → Customers → Import
Use it with payment processing integrations
Save the mapping.json file to reuse with similar data

Advanced usage

Save and reuse mappings

If you regularly import similar CSV files, download the mapping.json file. You can then use our CLI tool for automated processing:

schemamap map --schema stripe-customers --mapping mapping.json < input.csv > output.csv

Bulk processing

For files larger than 2,000 rows, use the CLI tool which has no size limits and processes files locally.

Need help?

Check out these community discussions about CSV import issues: