Exporting data

GrowPanel allows you to export data from reports and from the dedicated Settings → Exports page. This guide covers all the export options available, the file formats, and how to use exported data for analysis, reporting, or integration with other tools.

Export options overview

Full data exports

The Settings → Exports page provides two bulk export options that download your complete dataset:

• All customers - Every customer with their status, MRR, country, payment totals, and custom metadata
• All MRR movements - Every individual MRR movement event (new, expansion, contraction, churn, reactivation) with details

These exports include your full history, not just the current view. See the Exports settings page for the complete list of columns included in each export.

Exporting from reports

Most reports include an export button in the top-right area of the page.

How to export

1. Navigate to any report (MRR, ARR, Churn, etc.)
2. Apply any filters you want (date range, plan, currency, etc.)
3. Click the Export button
4. Choose the export format (CSV)
5. Your browser downloads the file

What's included in the export

The exported file includes:

• All data matching your current filters - If you've filtered by date range, plan, or other criteria, only that subset is exported
• All columns visible in the report - The same data you see on screen
• Time series data - Each row represents one period (day, week, or month depending on your view)

Export with different time granularities

If a report supports different time views (daily, weekly, monthly), your export will match your current selection:

Exporting chart data

When viewing charts, you can export the underlying data:

1. Click on any chart to expand it (if applicable)
2. Look for an export or download icon near the chart
3. Click to download the chart data as CSV

Chart exports include:

• The x-axis values (dates/periods)
• The y-axis values (metric values)
• Any series shown in the chart (e.g., New, Expansion, Churn for MRR bar charts)

Exporting from the Customers page

You can also export a filtered customer list directly from the Customers page:

1. Go to Customers in the main menu
2. Apply any filters (status, plan, date range, custom variables, etc.)
3. Click the Export button

This exports only the customers matching your current filters, which is useful when you need a specific subset rather than the full customer list.

Export file format

All exports use CSV (Comma-Separated Values) format:

• Compatible with Excel, Google Sheets, and most data tools
• UTF-8 encoding for international characters
• First row contains column headers
• Dates formatted as YYYY-MM-DD
• Currency amounts in the reporting currency (unless exporting original currencies)

Opening exports in Excel

1. Download the CSV file
2. Open Excel
3. Go to File → Open and select the CSV
4. Excel automatically parses the columns

Opening exports in Google Sheets

1. Download the CSV file
2. Open Google Sheets
3. Go to File → Import
4. Upload the CSV file
5. Choose "Replace spreadsheet" or "Insert new sheet"

Currency in exports

Exports include currency information based on your settings:

Single currency exports

If you have one currency or use a single reporting currency:

• All amounts are in your reporting currency
• No separate currency column needed

Multi-currency exports

If you have multiple currencies:

• Reporting currency column - Amounts converted to your reporting currency
• Original currency column - The currency the customer pays in
• Original amount column - The amount in the original currency

Fix FX in exports

If you've enabled "Fix FX" (fixed exchange rates) in a report:

• Exports use the same fixed rates
• This ensures consistency between what you see and what you export

Scheduled exports

GrowPanel supports scheduled email reports that automatically send exports on a recurring basis.

Setting up scheduled exports

1. Go to Settings → Notifications
2. Click Add scheduled report
3. Choose the report type
4. Select the frequency (daily, weekly, monthly)
5. Choose recipients
6. Save the schedule

What scheduled exports include

• The same data as manual exports
• Matching the configured filters and date range
• Attached as a CSV file to the email

See Notifications for detailed setup instructions.

API access for exports

For programmatic access to your data, use the REST API instead of manual exports.

Benefits of API access

• Automation - Schedule data pulls without manual downloads
• Integration - Feed data directly into your systems
• Real-time - Access current data without waiting for exports
• Customization - Query exactly the data you need

See the REST API documentation for endpoint details.

Tips for working with exports

Combining exports

For comprehensive analysis, export both customers and MRR movements from Settings → Exports, then join them on Customer ID in your spreadsheet or data tool.

Troubleshooting exports

Related pages

• Exports settings - Download all customers and MRR movements
• Filters - Filtering data before export
• Notifications - Scheduled email reports
• REST API - Programmatic data access