How does Kondado replicate Mercado Livre data to Excel?

Kondado connects to the Mercado Livre API and extracts data from your selected pipelines, then loads it directly into Excel files stored in your Microsoft 365 environment. The platform runs on your chosen schedule, automatically refreshing the data without requiring manual exports or copy-paste operations.

What Mercado Livre data can I replicate to Excel?

You can choose from 19 available pipelines including Ads, Items, Orders, Payments Mercado Pago, Order Shipments, and Complaints. Each pipeline contains specific fields such as item prices, stock quantities, buyer details, and shipment tracking numbers, giving you access to 716 total fields across all datasets.

How often does the data update in Excel?

You configure the update frequency based on your operational needs, with options ranging from every 5 minutes to daily intervals. This configurable schedule ensures your Excel workbooks reflect recent marketplace activity without overwhelming your system with unnecessary API calls.

Does the data arrive in Excel as raw tables or formatted reports?

Data replicates as structured tables within your Excel workbooks, preserving the original field names and data types from Mercado Livre. This raw format allows you to apply your own Excel formulas, pivot tables, and conditional formatting rules to create customized views tailored to your specific analysis requirements.

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

Yes, you can replicate data from multiple sources into the same workbook or separate sheets. Consider blending your marketplace data with Google Sheets information, PostgreSQL warehouse metrics, or advertising data from other platforms to create unified business dashboards.

Are there pre-built dashboards available for Mercado Livre data?

Yes, Kondado offers ready-made report templates including the Mercado Libre Looker Studio Report and Mercado Libre Power BI Report. These templates provide immediate visualization capabilities for users who prefer Looker Studio or Power BI over Excel, though you can also build equivalent analyses using Excel's native charting features.

What Excel formats does Kondado support?

The platform delivers data to Excel Online and desktop versions through Microsoft 365 integration, creating standard XLSX files that support all Excel functions including Power Query connections, VLOOKUP operations, and macro-enabled automation for advanced users.

Do I need technical skills to set up the Mercado Livre to Excel connection?

No coding is required to establish the connection. You simply authenticate your Mercado Livre account, select your desired pipelines from the available 19 options, and specify your Excel destination. The entire setup process takes minutes and requires no API configuration or database management knowledge.

Send data from Mercado Libre 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 Mercado Livre Data to Excel Automatically

Kondado enables you to replicate data from Mercado Livre directly into Excel without writing code or managing complex APIs. By selecting your desired pipelines from the Mercado Livre data source, you configure exactly which information flows into your spreadsheets on a schedule that fits your business needs. Whether you require near-real-time updates every five minutes for inventory tracking or daily summaries for financial reconciliation, the platform automates the entire replication process while maintaining data consistency.

Kondado provides a direct integration between Mercado Livre and Excel, replicating 19 different pipelines including Ads, Orders, Items, and Payments data on a configurable schedule ranging from every 5 minutes to daily intervals, with no coding required.

Once your data arrives in Excel, you can immediately apply familiar formulas, create pivot tables, and build custom charts using your Mercado Livre metrics. This seamless workflow eliminates manual data entry and ensures your spreadsheets always reflect the latest marketplace performance, allowing analysts to focus on deriving insights rather than copying data between systems. You can also combine this data with information from other sources to create comprehensive business views within your existing Excel environment.

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

With access to 19 distinct pipelines, you can pull specific datasets that drive your analysis. The Items: daily performance pipeline delivers granular sales metrics directly into your worksheets, enabling you to track velocity trends and identify top-performing SKUs using Excel’s built-in visualization tools. Meanwhile, the Orders pipeline provides comprehensive transaction details including buyer information and payment status, perfect for building automated sales reports that update as new marketplace activity occurs.

For financial teams, the Payments Mercado Pago pipeline streams transaction data into Excel where you can reconcile settlements, analyze cash flow patterns, and calculate fees using standard spreadsheet formulas. This automated data flow transforms Excel from a static documentation tool into a dynamic command center for your Mercado Livre operations, ensuring every department works with current information without switching between platforms.

Try out all the features for free for 14 days

Mercado Libre data available for Excel

available pipelines

716

extractable fields

Available integrations

Integration	Description
Ads	Table presents published ads with fields such as id, title, price, and description, along with metrics like total_visits_last_90_days.
Items	Table contains item details, including id, catalog_product_id, and attributes such as brand and model, along with pricing information.
Items: stock	Table provides information on available stock, including user_product_id, item_id, and quantity, along with availability type.
Items: daily performance	Table presents daily performance metrics of items, allowing analysis of sales and interactions over time.
Items: prices	Table displays pricing information for items, including id, selling price, and sale conditions, essential for marketing strategies.
Items: selling prices	Table provides details on the selling prices of items, including id and values, fundamental for market analysis.
Items: variations	Table presents variations of items, including attributes such as color and size, allowing better customer segmentation.
Store: daily performance	Table provides daily performance metrics of the store, including total sales and interactions, essential for evaluating results.
Payments Mercado Pago	Table contains information on payments, including id, status, and values, fundamental for financial management.
Orders	Table presents order details, including id, status, and information about buyers, essential for sales management.
Order Invoices	Includes fields such as id, seller_id, and total_amount, allowing detailed analysis of transactions and billed amounts.
Order Reviews	Contains information such as order_id, rating, and comment, facilitating the assessment of customer satisfaction and feedback on orders.
Order Buyers	Presents data such as buyer_id, buyer_email, and buyer_name, allowing analysis of buyer profiles and their contact information.
Order Context	Includes fields such as order_id, context_type, and context_value, providing insights into the conditions and circumstances of orders.
Order Shipments	Contains information such as shipment_id, tracking_number, and shipping_status, allowing tracking and management of shipments made.
Order Items	Includes data such as item_id, quantity, and price, facilitating the analysis of purchased products and their quantities.
Order Payments	Presents fields such as payment_id, payment_method, and payment_status, allowing analysis of payment methods and statuses for orders.
Order Sellers	Includes information such as seller_id, seller_name, and seller_rating, allowing analysis of seller performance and reputation.
Complaints	Contains fields such as complaint_id, order_id, and resolution_status, facilitating tracking and management of customer complaints.

Ads

Table presents published ads with fields such as id, title, price, and description, along with metrics like total_visits_last_90_days.

Items

Table contains item details, including id, catalog_product_id, and attributes such as brand and model, along with pricing information.

Items: stock

Table provides information on available stock, including user_product_id, item_id, and quantity, along with availability type.

Items: daily performance

Table presents daily performance metrics of items, allowing analysis of sales and interactions over time.

Items: prices

Table displays pricing information for items, including id, selling price, and sale conditions, essential for marketing strategies.

Items: selling prices

Table provides details on the selling prices of items, including id and values, fundamental for market analysis.

Items: variations

Table presents variations of items, including attributes such as color and size, allowing better customer segmentation.

Store: daily performance

Table provides daily performance metrics of the store, including total sales and interactions, essential for evaluating results.

Payments Mercado Pago

Table contains information on payments, including id, status, and values, fundamental for financial management.

Orders

Table presents order details, including id, status, and information about buyers, essential for sales management.

Order Invoices

Includes fields such as id, seller_id, and total_amount, allowing detailed analysis of transactions and billed amounts.

Order Reviews

Contains information such as order_id, rating, and comment, facilitating the assessment of customer satisfaction and feedback on orders.

Order Buyers

Presents data such as buyer_id, buyer_email, and buyer_name, allowing analysis of buyer profiles and their contact information.

Order Context

Includes fields such as order_id, context_type, and context_value, providing insights into the conditions and circumstances of orders.

Order Shipments

Contains information such as shipment_id, tracking_number, and shipping_status, allowing tracking and management of shipments made.

Order Items

Includes data such as item_id, quantity, and price, facilitating the analysis of purchased products and their quantities.

Order Payments

Presents fields such as payment_id, payment_method, and payment_status, allowing analysis of payment methods and statuses for orders.

Order Sellers

Includes information such as seller_id, seller_name, and seller_rating, allowing analysis of seller performance and reputation.

Complaints

Contains fields such as complaint_id, order_id, and resolution_status, facilitating tracking and management of customer complaints.

See all available data →

Try out all the features for free for 14 days

How to send Mercado Libre data to Excel

Sync data automatically — no code, no manual exports.

Connect Your Mercado Livre Account

Authenticate your Mercado Livre seller credentials through Kondado's interface to establish the data source connection and enable access to all 19 available pipelines.

Configure Excel as Your Destination

Specify your Microsoft 365 Excel environment as the target location, selecting the specific workbook and sheet where you want your Mercado Livre data to populate automatically.

Select Pipelines and Schedule Updates

Choose which data pipelines to replicate from the 19 available options, then set your preferred update frequency ranging from every 5 minutes to daily intervals to keep your spreadsheets current.

Try out all the features for free for 14 days