How does Kondado replicate Hotmart data to Excel?

Kondado connects directly to your Hotmart account using your API credentials and pulls data through dedicated pipelines. The platform then loads this information into your Excel workbooks automatically on your chosen schedule, populating columns and rows with your sales and subscriber information without requiring manual CSV uploads or copy-pasting.

What Hotmart data can I import into Excel using Kondado?

You can replicate information from eleven available pipelines including Subscribers, Sales Commissions, Sales History, and all Hotmart Club modules. This covers subscription records, transaction details, student progress metrics, and product pricing data, giving you comprehensive access to your digital product business metrics within your spreadsheets.

How often does Hotmart data update in Excel spreadsheets?

You configure the replication schedule based on your operational needs, selecting intervals from every 5 minutes up to daily updates. This near-real-time capability ensures your Excel dashboards reflect recent transactions and subscriber changes while maintaining spreadsheet performance.

Can I combine Hotmart data with other sources in the same Excel file?

Yes, you can replicate data from additional platforms alongside Hotmart into the same Excel workbook, or send your Hotmart data to Google Sheets or BigQuery for broader analysis. This allows you to create unified reports that correlate your digital product sales with advertising spend from marketing platforms or financial data from accounting systems.

What format does Hotmart data arrive in within Excel?

Data arrives as structured datasets with clearly labeled columns corresponding to Hotmart fields such as subscriber_code, commission_value, and completion_percentage. Each pipeline populates a distinct worksheet or data range, preserving data types and relationships so you can immediately apply Excel formulas, pivot tables, and charting tools.

Do I need technical skills to connect Hotmart to Excel?

No coding or API expertise is required to establish the connection. You simply authenticate your Hotmart account within Kondado, select your desired pipelines, and specify your Excel destination using a straightforward interface that handles the technical replication process automatically.

Can I track Hotmart Club student progress in Excel?

Yes, through dedicated pipelines including Hotmart Club: Student Progress, Hotmart Club: Modules, and Hotmart Club: Students, you receive detailed learning analytics. You can monitor completion percentages, module access patterns, and student engagement metrics to optimize your course content and identify at-risk learners.

How do I analyze Hotmart sales commissions in Excel?

The Sales Commissions pipeline delivers transaction-level commission data including commission_value and user_name fields into your spreadsheets. You can then create pivot tables summarizing affiliate performance, calculate total payouts using SUM formulas, and filter by date ranges to manage your monthly financial reconciliations.

Send data from Hotmart to Excel

Get started for free

No credit card required | 14 days | 10 million records | 30 pipelines

or sign up with your email

By signing up, you agree to Kondado’s Terms of service and Privacy policy

Send Hotmart Data to Excel Automatically

Connecting your Hotmart account to Excel requires no coding or technical expertise when you use Kondado. Our platform establishes a direct connection to your Hotmart data source and replicates information directly into your Excel workbooks on a configurable schedule that you control. You choose the update frequency that matches your business needs, whether that is every 5 minutes for active monitoring or daily for periodic reviews, ensuring your spreadsheets always reflect current performance.

Once your data arrives in Excel, you can build custom financial models, create pivot tables analyzing course sales performance, and combine Hotmart metrics with data from other platforms to generate comprehensive business intelligence. This automated workflow eliminates manual data exports while keeping your spreadsheets current with the latest transaction records, commission details, and subscriber information.

Kondado provides a direct integration between Hotmart and Excel, replicating your digital product sales data, subscriber information, and Hotmart Club metrics into spreadsheets on a configurable schedule ranging from every 5 minutes to daily, without requiring technical setup or API management.

Our prices start from $19 USD/month, and you can try Kondado for free for 14 days with no credit card required

Available Hotmart Pipelines for Excel

Kondado replicates data through specialized pipelines including Subscribers, Sales Commissions, and Hotmart Club: Student Progress. The Subscribers pipeline delivers detailed subscription records with status indicators and subscriber codes directly into your spreadsheets, enabling you to segment active members from canceled accounts using Excel filtering tools. Sales Commissions data flows into separate columns showing transaction details and commission values, allowing you to calculate affiliate payouts and revenue sharing using familiar spreadsheet formulas.

With the Hotmart Club: Student Progress pipeline, you receive completion percentages and module tracking data that transforms into visual progress charts within Excel. You can monitor student engagement across your digital courses, identify learners who may need additional support, and correlate educational completion rates with your Sales History data to measure the true impact of your course content on revenue generation.

Try out all the features for free for 14 days

Hotmart data available for Excel

available pipelines

202

extractable fields

Available integrations

Integration	Description
Subscribers	Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.
Sales Commissions	Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.
Subscriber Purchases	Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.
Sales Price Breakdown	Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.
Sales History	Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.
Hotmart Club: Students	Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.
Hotmart Club: Modules	Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.
Hotmart Club: Student Progress	Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.
Hotmart Club: Pages	Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.
Products	Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.
Subscription Transactions	Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

Subscribers

Records of subscriptions include subscriber_code, subscriber_name, and status, allowing detailed analysis of active and canceled subscriptions.

Sales Commissions

Commission details include transaction, commission_value, and user_name, providing a clear view of commissions generated by each transaction.

Subscriber Purchases

Data on purchases includes subscriber_code, product_id, and price_value, allowing tracking of acquisitions made by subscribers.

Sales Price Breakdown

Detailed pricing information includes product_id, price_value, and price_currency_code, facilitating analysis of sales prices.

Sales History

Sales records include purchase_transaction, product_id, and request_date, allowing analysis of transaction history.

Hotmart Club: Students

Information about students includes subscriber_name, product_id, and status, allowing tracking of students' progress in the club.

Hotmart Club: Modules

Data on modules includes product_id, module_name, and completion_status, allowing analysis of students' progress in each module.

Hotmart Club: Student Progress

Progress records include subscriber_code, module_id, and completion_percentage, facilitating monitoring of students' performance.

Hotmart Club: Pages

Information about pages includes page_id, access_count, and last_access_date, allowing analysis of student engagement.

Products

Product data includes product_id, product_name, and price_value, allowing detailed analysis of the available product portfolio.

Subscription Transactions

Records of subscription transactions, including fields such as transaction code, product ID, and commission value.

See all available data →

Try out all the features for free for 14 days

How to send Hotmart data to Excel

Sync data automatically — no code, no manual exports.

Connect Your Hotmart Account

Authenticate your Hotmart data source in Kondado by entering your API credentials, which establishes the direct connection to your digital product sales and subscription information.

Set Up Excel Destination

Configure Excel as your destination by connecting your Microsoft account and selecting the specific workbook where you want your Hotmart data to populate with each automated update.

Choose Pipelines and Schedule

Select from the eleven available pipelines such as Subscribers or Sales Commissions, then set your preferred update frequency ranging from every 5 minutes to daily intervals.

Try out all the features for free for 14 days