How frequently can I sync data from Chargebee 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 Chargebee data during the sync?

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

Do I need to write code to connect Chargebee 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 Chargebee to Excel Online

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

Historical & Dynamic Data

One-way Sync

For Non-technical Users

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

Source: Chargebee

Chargebee is a subscription management system which can help vendors handle all the aspects of the subscription life cycle including recurring billing, invoicing and trial management.

Auth: Basic Authentication

Available datasets

Addons
Comments
Coupons
Coupon Codes
Coupon Sets
Credit Notes-All
Credit Notes-Last X days Date-ranged
Customers
Customers+Contacts Combo
Events-Last90days
Hosted Pages
Invoices-All
Invoices-Last X days Date-ranged
Invoices+Payments-All Combo
Invoices+Payments-Last X days Combo Date-ranged
LineItems of Invoices-All
LineItems of Invoices-Last X days Date-ranged
LineItems of Credit Notes-All
LineItems of Credit Notes-Last X days Date-ranged
Orders-All
Orders-Last X days Date-ranged
Payment Sources
Plans
Promotional Credits
Site Migration Details
Subscriptions
Transactions-All
Transactions-Last X days Date-ranged
Unbilled Charges-All
Unbilled Charges-Last X days Date-ranged
Virtual Bank Accounts

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 Chargebee

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

Pick which Chargebee 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 Chargebee data to Excel Online automatically and refreshes it based on your sync frequency.

What Chargebee Subscriptions look like in Excel Online

Flatly writes a header row to Excel Online, then one row per record. Nested Chargebee fields are flattened into their own columns, so the Subscriptions dataset arrives as 226 columns.

Chargebee Subscriptions

Sample Chargebee Subscriptions rows in Excel Online, showing 8 of 226 columns
	A	B	C	D	E	F	G	H
1	subscription_id	subscription_currency_code	subscription_start_date	subscription_status	subscription_total_dues	subscription_shipping_address_first_name	subscription_shipping_address_email	subscription_shipping_address_company
2	a1b2c3d4	USD	1789000000	future	12950	Jordan	jordan.lee@example.com	Acme Corporation
3	a1b2c3d5	USD	1789000000	future	25900	Priya	priya.patel@example.com	Northwind Traders
4	a1b2c3d6	USD	1789000000	future	38850	Marcus	marcus.okafor@example.com	Globex Ltd

Subscriptions

Example data. Showing 8 of 226 columns.

All 226 Chargebee Subscriptions columns

subscription_id
subscription_currency_code
subscription_billing_period
subscription_billing_period_unit
subscription_start_date
subscription_trial_end
subscription_remaining_billing_cycles
subscription_po_number
subscription_auto_collection
subscription_plan_quantity_in_decimal
subscription_plan_unit_price_in_decimal
subscription_customer_id
subscription_status
subscription_trial_start
subscription_trial_end_action
subscription_current_term_start
subscription_current_term_end
subscription_next_billing_at
subscription_created_at
subscription_started_at
subscription_activated_at
subscription_contract_term_billing_cycle_on_renewal
subscription_override_relationship
subscription_pause_date
subscription_resume_date
subscription_cancelled_at
subscription_cancel_reason
subscription_created_from_ip
subscription_resource_version
subscription_updated_at
subscription_has_scheduled_advance_invoices
subscription_has_scheduled_changes
subscription_payment_source_id
subscription_plan_free_quantity_in_decimal
subscription_plan_amount_in_decimal
subscription_cancel_schedule_created_at
subscription_offline_payment_method
subscription_channel
subscription_net_term_days
subscription_active_id
subscription_due_invoices_count
subscription_due_since
subscription_total_dues
subscription_mrr
subscription_exchange_rate
subscription_base_currency_code
subscription_invoice_notes
subscription_meta_data
subscription_deleted
subscription_changes_scheduled_at
subscription_cancel_reason_code
subscription_free_period
subscription_free_period_unit
subscription_create_pending_invoices
subscription_auto_close_invoices
subscription_business_entity_id
subscription_decommissioned
subscription_brand_id
subscription_subscription_items_1
subscription_item_tiers_1
subscription_charged_items_1
subscription_coupons_1
subscription_shipping_address_first_name
subscription_shipping_address_last_name
subscription_shipping_address_email
subscription_shipping_address_company
subscription_shipping_address_phone
subscription_shipping_address_line1
subscription_shipping_address_line2
subscription_shipping_address_line3
subscription_shipping_address_city
subscription_shipping_address_state_code
subscription_shipping_address_state
subscription_shipping_address_country
subscription_shipping_address_zip
subscription_shipping_address_validation_status
subscription_referral_info_referral_code
subscription_referral_info_coupon_code
subscription_referral_info_referrer_id
subscription_referral_info_external_reference_id
subscription_referral_info_reward_status
subscription_referral_info_referral_system
subscription_referral_info_account_id
subscription_referral_info_campaign_id
subscription_referral_info_external_campaign_id
subscription_referral_info_friend_offer_type
subscription_referral_info_referrer_reward_type
subscription_referral_info_notify_referral_system
subscription_referral_info_destination_url
subscription_referral_info_post_purchase_widget_enabled
subscription_billing_override_max_excess_payment_usage
subscription_billing_override_max_refundable_credits_usage
subscription_contract_term_id
subscription_contract_term_status
subscription_contract_term_contract_start
subscription_contract_term_contract_end
subscription_contract_term_billing_cycle
subscription_contract_term_action_at_term_end
subscription_contract_term_total_contract_value
subscription_contract_term_total_contract_value_before_tax
subscription_contract_term_cancellation_cutoff_period
subscription_contract_term_created_at
subscription_contract_term_subscription_id
subscription_contract_term_remaining_billing_cycles
subscription_discounts_1
customer_id
customer_first_name
customer_last_name
customer_email
customer_phone
customer_company
customer_vat_number
customer_auto_collection
customer_offline_payment_method
customer_net_term_days
customer_vat_number_validated_time
customer_vat_number_status
customer_allow_direct_debit
customer_is_location_valid
customer_created_at
customer_created_from_ip
customer_exemption_details
customer_taxability
customer_entity_code
customer_exempt_number
customer_resource_version
customer_updated_at
customer_locale
customer_billing_date
customer_billing_month
customer_billing_date_mode
customer_billing_day_of_week
customer_billing_day_of_week_mode
customer_pii_cleared
customer_auto_close_invoices
customer_channel
customer_active_id
customer_fraud_flag
customer_primary_payment_source_id
customer_backup_payment_source_id
customer_invoice_notes
customer_business_entity_id
customer_preferred_currency_code
customer_promotional_credits
customer_unbilled_charges
customer_refundable_credits
customer_excess_payments
customer_is_einvoice_enabled
customer_einvoicing_method
customer_meta_data
customer_deleted
customer_registered_for_gst
customer_consolidated_invoicing
customer_customer_type
customer_business_customer_without_vat_number
customer_client_profile_id
customer_use_default_hierarchy_settings
customer_vat_number_prefix
customer_entity_identifier_scheme
customer_entity_identifier_standard
customer_brand_id
customer_billing_address_first_name
customer_billing_address_last_name
customer_billing_address_email
customer_billing_address_company
customer_billing_address_phone
customer_billing_address_line1
customer_billing_address_line2
customer_billing_address_line3
customer_billing_address_city
customer_billing_address_state_code
customer_billing_address_state
customer_billing_address_country
customer_billing_address_zip
customer_billing_address_validation_status
customer_referral_urls_1
customer_contacts_1
customer_payment_method_type
customer_payment_method_gateway
customer_payment_method_gateway_account_id
customer_payment_method_status
customer_payment_method_reference_id
customer_balances_1
customer_entity_identifiers_1
customer_tax_providers_fields_1
customer_relationship_parent_id
customer_relationship_payment_owner_id
customer_relationship_invoice_owner_id
customer_parent_account_access_portal_edit_child_subscriptions
customer_parent_account_access_portal_download_child_invoices
customer_parent_account_access_send_subscription_emails
customer_parent_account_access_send_invoice_emails
customer_parent_account_access_send_payment_emails
customer_child_account_access_portal_edit_subscriptions
customer_child_account_access_portal_download_invoices
customer_child_account_access_send_subscription_emails
customer_child_account_access_send_invoice_emails
customer_child_account_access_send_payment_emails
card_payment_source_id
card_status
card_gateway
card_gateway_account_id
card_ref_tx_id
card_first_name
card_last_name
card_iin
card_last4
card_card_type
card_funding_type
card_expiry_month
card_expiry_year
card_issuing_country
card_billing_addr1
card_billing_addr2
card_billing_city
card_billing_state_code
card_billing_state
card_billing_country
card_billing_zip
card_created_at
card_resource_version
card_updated_at
card_ip_address
card_powered_by
card_customer_id
card_masked_number

FAQ: Chargebee

What is unique about this integration?

Flatly outputs Chargebee data sets in an improved layout, following convention in terms of each row containing an item's values, without the parent envelope key included. This is particularly important for LineItems which are de-nested and presented in individual rows. This makes Chargebee data analysis convenient.

FAQ: Excel Online

Do I need to install anything?

No. There are no plugins, add-ins or downloads to set up. Flatly writes XLSX files to your OneDrive, and you open them in Excel for the web (formerly Excel Online), which runs in the browser. Excel for the web is free with a Microsoft account; a Microsoft 365 subscription is not required.

Where are the files stored?

In your OneDrive, hosted by Microsoft, in the Apps > Flatly folder.

I use a work or school account. Which destination do I pick?

Choose OneDrive for Business. Excel Online connects to the OneDrive of a personal Microsoft account. OneDrive for Business connects to the OneDrive included with a Microsoft 365 work or school account. Files in either open in Excel for the web.

FAQ: Chargebee to Excel Online

How frequently can I sync data from Chargebee 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 Chargebee data during the sync?: No. Flatly provides a strict one-way sync. It extracts your historical and dynamic data from Chargebee and securely loads it into Excel Online without altering your original source data.
Do I need to write code to connect Chargebee 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 Chargebee 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