Importing your Chargebee Subscriptions data into Excel enables deeper analysis of recurring revenue metrics, subscription growth, and churn patterns beyond what Chargebee’s native reporting provides.
Using Coefficient, you can create a live connection that keeps your subscription data current in Excel without manual exports, ensuring your metrics are always up-to-date.
TLDR
-
Step 1:
Install Coefficient from the Office Add-ins store
-
Step 2:
Connect to your Chargebee account
-
Step 3:
Select and import Subscriptions data
-
Step 4:
Set up auto-refresh to keep data current
Step-by-Step Guide to Importing Chargebee Subscriptions into Excel
Step 1: Install Coefficient in Excel
First, add the Coefficient add-in to Excel:
- Open Excel
- Click on the “Insert” tab in the ribbon
- Select “Get Add-ins”
- Search for “Coefficient” in the Office Add-ins store
- Click “Add” to install the Coefficient add-in

Step 2: Connect to Chargebee and Import Subscriptions Data
After installing Coefficient, follow these steps to import your Subscriptions data:
- Open the Coefficient sidebar in Excel
- Click “Import” to see available data sources
- Select “Chargebee” from the finance connectors list
- Log in with your Chargebee credentials when prompted
- From the object list, select “Subscriptions”
- Choose which subscription fields you want to import (e.g., plan, status, start date, MRR)
- Apply any filters if needed (e.g., active subscriptions only)
- Click “Import” to bring the data into your spreadsheet

Step 3: Set Up Auto-Refresh (Optional)
To ensure your Subscriptions data remains up-to-date:
- Select your imported Subscriptions data in Excel
- In the Coefficient sidebar, click “Refresh”
- Choose “Set up auto-refresh”
- Select your preferred refresh schedule (hourly, daily, or weekly)
- Configure any notification settings
- Click “Save” to enable automatic updates

Available Chargebee Data
Available Objects
- Customers
- Subscriptions
- Invoices
- Credit Notes
- Gifts
- Hosted Pages
- Orders
- Payment Sources
- Promotional Credits
- Quotes
- Transactions
- Unbilled Charges
Frequently Asked Questions
Trusted By Over 50,000 Companies