Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Developer tools
Get started
Payments
Finance automation
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Overview
Billing
Tax
Reporting
Data
    Overview
    Schema
    Custom reports
    Sigma API
    Create custom reports
    Write queries using Sigma
    Query data across an organization
    Sync Stripe data
    Access data within a data warehouse
    Export data to a data warehouse
    Export data to cloud storage
    Data management
    Data freshness
    Business and product data use cases
    Import external data
      Amazon S3 Stripe Connector
      Apple App Store Stripe Connector
      Google Play Store Stripe Connector
      Transform data using Data Templates
Startup incorporation
HomeFinance automationDataImport external data

Transform external data using Data TemplatesPrivate preview

Define rules in templates to map external data files to Stripe objects.

Copy page

You can use Data Templates to upload and transform external data into Destination records to make it compatible with Stripe products. Data Templates are a set of data processing instructions that you can use to transform external data into Destination records.

Data template settings include:

  • Specifying the row in the file where the header is present
  • Data types that the uploaded fields convert to
  • Conditions to error out certain rows
  • How the columns of an uploaded file map to the fields of the Destination Records

Create a Data template

To create your Data Template:

  1. Go to the Stripe Dashboard > Data Management page.
  2. Select Data Template.
  3. Click Add Data Template and follow the steps in the details drawer to create the Data template.
  4. In the Data template details step, enter a name for your template and upload a CSV file with sample data.

Note

The header names and rows in your sample file must be the same as the CSV files you plan to transform using the Data template.

Configure your CSV data

Configure how Stripe processes your external data using Stripe data types.

  1. In the Header location field, select your file’s header row number.
  2. Next, in the Data types section, verify or choose a data type for each column.
  3. Click CSV settings to verify or adjust how your file is parsed.

Select the destination Record Type

Configure how Stripe processes your external data using Stripe data types. You can map user-uploaded data to Stripe using predefined destination record types. Choose the appropriate record type and verify the columns in the uploaded sample file to generate the selected destination record type.

In the Select destination record type step, choose how your data uploads and maps to Stripe by selecting a Destination record type.

Clean up and validation

In the Clean up and validate step, you can use conditions to ignore or validate records. There are two types of conditions:

  • Clean up conditions: Add a clean up condition to ignore any records that meet the condition.
  • Validation checks: Add a validation check to identify errors or issues with records and prevent those records from creating Stripe objects.

Map columns

Associate the columns in your file to Stripe object attributes.

Mapping options include:

  • Mapping a column from the file directly to the attribute
  • Manually entering a string value in a text box to assign a hardcoded value to a specific Stripe object attribute
  • Using custom formulas, such as SUM, CONCAT, and FIND, for data transformation

To add data mappings:

  1. In the Mandatory columns section, add data mappings for each attribute.
  2. (Optional) In the Optional columns section, add a mapping for each data column that maps to an optional Stripe object attribute.
  3. (Optional) In the Custom columns section, add any data columns that don’t map directly to a Stripe object attribute.
  4. Click Save and Activate and view your Data template in the Data Template List page.
  5. Go to the Import Set page, and upload data using your template.
Was this page helpful?
YesNo
Need help? Contact Support.
Join our early access program.
Check out our changelog.
Questions? Contact Sales.
LLM? Read llms.txt.
Powered by Markdoc