Stripe to Excel Online for Business

Automatically Export & Sync Stripe Data to Excel Online for Business

Stripe
a black arrow pointing to the right
Excel Online for Business
Full data sets
No instructions needed
No code
No complicated flow charts
No triggers
Set up in under 3 minutes
Flat pricing starting at $19 /month

Data sets

ApplicationFees-All
ApplicationFees-Last365days
Date Rangable
Balance
BalanceTransactions-All
BalanceTransactions-Last X days
Date Rangable
Charges-All
Charges-Last X days
Date Rangable
Coupons
Credit Notes
Customers-All
Customers-Last X days
Date Rangable
Customers+Charges-All
Pre-blended combo set CHARGES
Customers+Charges-Last X days
Date Rangable
Pre-blended combo set CHARGES
Customers+Invoices-All
Pre-blended combo set INVOICES
Customers+Invoices-Last X days
Date Rangable
Pre-blended combo set INVOICES
Disputes-All
Disputes-Last X days
Date Rangable
EarlyFraudWarnings
Events-All
Events-Last X days
Date Rangable
File Uploads
Invoices-All
Invoices-Last X days
Date Rangable
Invoices-ChargeAutoOnly
Invoices-ChargeAutoOnly-Last X
Date Rangable
Invoices-SendInvoiceOnly
Invoices-SendInvoiceOnly-Last X
Date Rangable
Invoices+LineItems Alltime
Pre-blended combo set SELF-LEFT-JOINED
Invoices+LineItems Last X days
Date Rangable
Pre-blended combo set SELF-LEFT-JOINED
InvoiceItems-All
IssuingAuthorizations
IssuingCards
IssuingCardholders
IssuingDisputes
IssuingTransactions
Orders
Orders-Last X days
Date Rangable
Order Returns
PaymentIntents-All
PaymentIntents-Last X days
Date Rangable
Payouts-All
Payouts-Last X days
Date Rangable
Plans-All
Plans-ActiveOnly
Plans-InactiveOnly
Products-All
Products-ActiveOnly
Products-PhysicalOnly
Refunds-All
Refunds-Last X days
Date Rangable
SetupIntents-All
SetupIntents-Last X days
Date Rangable
SKUs
Subscriptions-All
Subscriptions-Last X days
Date Rangable
Subscriptions-ChargeAutoOnly
Subscriptions-ChargeAutoOnly-Last X
Date Rangable
Subscriptions-SendInvoiceOnly
Subscriptions-SendInvoiceOnly-Last X
Date Rangable
Transfers-All

Built for Synchronization

This service is designed to help anyone continuously export (i.e. "sync") bulk data from Stripe.

If you only need to export your data one time, check the website of Stripe to see if their service offers a one-time export feature natively. Sometimes a Data Source's native export feature may provide not as much data as its API does, in which case Flatly is the solution.

Additional Information

Flatly uses official API channels to provide an integration with Stripe.
Stripe is a global online payment processor that is trusted by thousands of businesses across the globe.
Difference: Stripe versus Stripe Connect

Flatly offers a conventional Stripe integration for merchants, labeled in the data source selection drop-down as Stripe. This integration uses conventional OAuth authorization and is designed to power analytics for non-technical merchants who want to track revenue, invoices, transactions and customer records, etc.

Separately, Flatly offers an integration for Stripe developers and platforms, labeled Stripe Connect, which uses API Key based authorization. This integration is for developers who want to analyze data related to transfers and connections, as opposed to conventional commerce. As of today, API Key based authorization is the only available option for Stripe Connect in the ETL analytics context.

Scopes

Flatly's access to Plaid and Plaid's downstream connected financial institutions is read-only access to text. It is limited to account data (words, numbers, dates). It does not include any money-movement, transfer capabilities or account holder profiles/identities.

Plaid alone interfaces directly with financial institutions, caches data from those institutions on Plaid infrastructure, and then makes the appropriate scoped subset of that data available to partners like Flatly using secure connections called client libraries.

PowerBI reads CSV or XLSX files directly from OneDrive for Business.

File Formats

XLSX (Parsed)
XLSX (Raw)
CSV File

Integration Flow

Setup

Step 1

Select Stripe from the Data Source dropdown and Excel Online for Business from the Data Destination dropdown.

Step 2

Authorize Stripe with your credentials using the OAuth flow.

Step 3

Authorize Excel Online for Business with your credentials using the OAuth flow.

Step 4

Select your Data Set from the 60 Data Sets available using the dropdown.

Step 5

Click Flatten to sync your data.

Walkthrough Video

Extended Data Sources

Get started with your data pipelines

Connect your data with our turnkey data integration solution so you can focus on running your business.