How frequently can I sync data from Stripe to Excel Online?

Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.

Does Flatly modify my Stripe data during the sync?

No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Stripe and securely loads it into Excel Online without altering your original source data.

Do I need to write code to connect Stripe to Excel Online?

No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

Payments Cloud Drives

Sync Stripe to Excel Online

Automatically sync your Stripe data into Excel Online with Flatly's no-code, triggerless, turnkey integration service.

Historical & Dynamic Data

One-way Sync

For Non-technical Users

Connect Stripe to Excel Online Which Stripe API does Flatly use?

Source: Stripe

Stripe is a global online payment processor that is trusted by thousands of businesses across the globe.

Auth: OAuth

Available datasets

ApplicationFees-All
ApplicationFees-Last365days
Balance
BalanceTransactions-All
BalanceTransactions-Last X days Date-ranged
Charges-All
Charges-Last X days Date-ranged
Coupons
Credit Notes
Customers-All
Customers-Last X days Date-ranged
Customers+Charges-All Combo
Customers+Charges-Last X days Combo Date-ranged
Customers+Invoices-All Combo
Customers+Invoices-Last X days Combo Date-ranged
Disputes-All
Disputes-Last X days Date-ranged
EarlyFraudWarnings
Events-All
Events-Last X days Date-ranged
File Uploads
Invoices-All
Invoices-Last X days Date-ranged
Invoices-ChargeAutoOnly
Invoices-ChargeAutoOnly-Last X Date-ranged
Invoices-SendInvoiceOnly
Invoices-SendInvoiceOnly-Last X Date-ranged
Invoices+LineItems Alltime Combo
Invoices+LineItems Last X days Combo Date-ranged
InvoiceItems-All
IssuingAuthorizations
IssuingCards
IssuingCardholders
IssuingDisputes
IssuingTransactions
Orders
Orders-Last X days Date-ranged
Order Returns
PaymentIntents-All
PaymentIntents-Last X days Date-ranged
Payouts-All
Payouts-Last X days Date-ranged
Plans-All
Plans-ActiveOnly
Plans-InactiveOnly
Products-All
Products-ActiveOnly
Products-PhysicalOnly
Refunds-All
Refunds-Last X days Date-ranged
SetupIntents-All
SetupIntents-Last X days Date-ranged
SKUs
Subscriptions-All
Subscriptions-Last X days Date-ranged
Subscriptions-ChargeAutoOnly
Subscriptions-ChargeAutoOnly-Last X Date-ranged
Subscriptions-SendInvoiceOnly
Subscriptions-SendInvoiceOnly-Last X Date-ranged
Transfers-All

Destination: Excel Online

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

Auth: OAuth

Supported file formats

XLSX (Parsed)
XLSX (Raw)
CSV (Parsed)
CSV (Raw)
NDJSON
Markdown (Table)
Markdown (Key-Value)

How it works

1
Connect Stripe

Authenticate Stripe (OAuth) and Excel Online (OAuth) in the Flatly dashboard. You only have to do this once.
2
Choose your datasets

Pick which Stripe datasets to sync and set your sync frequency. The frequencies available to you depend on your Flatly plan.
3
Data lands in Excel Online

Flatly uploads your Stripe data to Excel Online automatically and refreshes it based on your sync frequency.

What Stripe Charges look like in Excel Online

Flatly writes a header row to Excel Online, then one row per record. Nested Stripe fields are flattened into their own columns, so the Charges-All dataset arrives as 130 columns.

Stripe Charges-All

Sample Stripe Charges-All rows in Excel Online, showing 8 of 130 columns
	A	B	C	D	E	F	G	H
1	amount	amount_captured	amount_refunded	billing_details_name	created	currency	id	payment_method_details_card_extended_authorization_status
2	100	0	0	Jenny Rosen	1234567890	usd	ch_1PgafuB7WZ01zgkWXYmPNZs8	disabled
3	200	0	0	Priya Patel	1234567890	usd	ch_1PgafuB7WZ01zgkWXYmPNZs9	disabled
4	300	0	0	Marcus Okafor	1234567890	usd	ch_1PgafuB7WZ01zgkWXYmPNZs0	disabled

Charges

Example data. Showing 8 of 130 columns.

All 130 Stripe Charges-All columns

amount
amount_captured
amount_refunded
application
application_fee
application_fee_amount
balance_transaction
billing_details_address_city
billing_details_address_country
billing_details_address_line1
billing_details_address_line2
billing_details_address_postal_code
billing_details_address_state
billing_details_email
billing_details_name
billing_details_phone
billing_details_tax_id
calculated_statement_descriptor
captured
created
currency
customer
description
disputed
failure_balance_transaction
failure_code
failure_message
fraud_details
id
livemode
metadata
object
on_behalf_of
outcome_advice_code
outcome_network_advice_code
outcome_network_decline_code
outcome_network_status
outcome_reason
outcome_seller_message
outcome_type
paid
payment_intent
payment_method
payment_method_details_card_amount_authorized
payment_method_details_card_brand
payment_method_details_card_checks_address_line1_check
payment_method_details_card_checks_address_postal_code_check
payment_method_details_card_checks_cvc_check
payment_method_details_card_country
payment_method_details_card_exp_month
payment_method_details_card_exp_year
payment_method_details_card_extended_authorization_status
payment_method_details_card_fingerprint
payment_method_details_card_funding
payment_method_details_card_incremental_authorization_status
payment_method_details_card_installments_plan_count
payment_method_details_card_installments_plan_interval
payment_method_details_card_installments_plan_type
payment_method_details_card_last4
payment_method_details_card_mandate
payment_method_details_card_multicapture_status
payment_method_details_card_network
payment_method_details_card_network_token_used
payment_method_details_card_overcapture_maximum_amount_capturable
payment_method_details_card_overcapture_status
payment_method_details_card_three_d_secure_authentication_flow
payment_method_details_card_three_d_secure_electronic_commerce_indicator
payment_method_details_card_three_d_secure_exemption_indicator
payment_method_details_card_three_d_secure_result
payment_method_details_card_three_d_secure_result_reason
payment_method_details_card_three_d_secure_transaction_id
payment_method_details_card_three_d_secure_version
payment_method_details_card_wallet_dynamic_last4
payment_method_details_card_wallet_type
payment_method_details_card_authorization_code
payment_method_details_card_regulated_status
payment_method_details_card_network_transaction_id
payment_method_details_card_transaction_link_id
payment_method_details_card_electronic_commerce_indicator
payment_method_details_type
receipt_email
receipt_number
receipt_url
refunded
refunds_data
refunds_has_more
refunds_object
refunds_url
review
shipping
source_transfer
statement_descriptor
statement_descriptor_suffix
status
transfer_data_amount
transfer_data_destination_id
transfer_data_destination_object
transfer_group
source_allow_redisplay
source_amount
source_client_secret
source_created
source_currency
source_flow
source_id
source_livemode
source_metadata
source_object
source_owner_address_city
source_owner_address_country
source_owner_address_line1
source_owner_address_line2
source_owner_address_postal_code
source_owner_address_state
source_owner_email
source_owner_name
source_owner_phone
source_owner_verified_address_city
source_owner_verified_address_country
source_owner_verified_address_line1
source_owner_verified_address_line2
source_owner_verified_address_postal_code
source_owner_verified_address_state
source_owner_verified_email
source_owner_verified_name
source_owner_verified_phone
source_statement_descriptor
source_status
source_type
source_usage

FAQ: Stripe

Is this integration with Stripe or Stripe Connect?

Both. 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.

FAQ: Stripe to Excel Online

How frequently can I sync data from Stripe to Excel Online?: Flatly allows you to set custom sync frequencies ranging from every 10 minutes to once daily, depending on your Flatly pricing plan.
Does Flatly modify my Stripe data during the sync?: No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Stripe and securely loads it into Excel Online without altering your original source data.
Do I need to write code to connect Stripe to Excel Online?: No code is required. Flatly is a turnkey, no-code integration platform designed for non-technical users to securely connect their data sources and destinations in minutes.

“The interface is unbelievable. Flatly is so easy to use. After years of struggling with Zapier this is life changing.”

Melissa Cable

Project Manager, Aeolidia

Full data refresh

Maintain up-to-date flat files when any nested or bundled data changes in your source app.

Connection Management

Manage multiple tenants, with connection health monitoring.

Bulk Job Management

Control multiple jobs at the same time, with live progress monitoring.

Merged datasets

Export left-joined combo objects like deals+products.

Write options

Refresh one flat file or create a stack of timestamped versions.

Filterability

Include only the columns or views essential for your reporting.

Notifications

Get alerts about your syncs via email, webhooks or Slack notifications.

Logging

Access up to one thousand log entries for your sync operations.

Custom Field Enrichment

Get useful values in your data instead of identifiers or definitions.

Metadata Attachment

See file statistics alongside your flat files to keep track of their origins.

Dark UI Mode

Reduce eye strain and save energy by using our built in dark mode.

Programmatic Jobs

Queue jobs by making API calls or agent requests.

Time Stamp Enrichment

Get human-readable dates and times from UNIX timestamps.

High frequency

10-minute refresh cycles mean your data store is near real-time.

High capacity

Reliably flatten billions of cells to CSV files without hiccups.

Advanced Security

Two-factor authentication and Destination Lock controls.

Stripe-powered Billing

Reliable payments provider with automatic, familiar invoicing and 1% of Sales to Stripe Climate.

Mobile access

Manage your sync operations from your phone if you are traveling.

Connect Stripe to Excel Online

Get started today with a 14-day free trial. No credit card required. Both human and AI support are available.

Get started Compare pricing