No-code pipeline · Mercado Libre → Excel

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

From Mercado Libre to Excel: managed, scheduled, no code.

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.

Connect Mercado Libre now →

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.

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

Replicated to Excel

Mercado Libre data available for Excel

Tables Kondado writes into your Excel, on a schedule you control.

available pipelines

716

extractable fields

Excel

Destination

Available integrations

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 → Send Mercado Libre to Excel →

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

Hundreds of data-driven companies trust Kondado

Why Kondado?

Focus on extracting value from your data and leave the rest to us

Wherever you need

With the same platform, you send data to AI (Claude/ChatGPT via MCP), reports, spreadsheets, databases, data warehouses, and data lakes. ETL and ELT

Learn More About Our Platform →

From wherever you need

Data from over 80 sources for Marketing, Ecommerce, ERPs, Customer Service, Finance, Databases, and much more

Learn More About Our Data Sources →

Predictable pricing

No surprise invoices, pick a plan and change it anytime

Check out our plans →

Send data from Mercado Libre to other destinations

Mercado Libre > Looker Studio

Mercado Libre > Power BI

Other visualizations

Mercado Libre > Amazon S3

Mercado Libre > BigQuery

Mercado Libre > Excel

Mercado Libre > Google Sheets

Mercado Libre > MySQL

Mercado Libre > PostgreSQL

Mercado Libre > Redshift

Mercado Libre > SQL Server

Choose a tool to visualize your Mercado Libre data

If the software you need is not listed, drop us a messagem. You can use almost every tool

Mercado Libre > Airtable

Mercado Libre > Alteryx

Mercado Libre > Amazon Quicksight

Mercado Libre > BIMachine

Mercado Libre > Cortex

Mercado Libre > Data Studio

Mercado Libre > Geckoboard

Mercado Libre > Grafana

Mercado Libre > IBM Cognos Analytics

Mercado Libre > Klipfolio

Mercado Libre > Looker Studio

Mercado Libre > Looker

Mercado Libre > Looqbox

Mercado Libre > Metabase

Mercado Libre > Microstrategy

Mercado Libre > Pentaho

Mercado Libre > Power BI

Mercado Libre > Qlik Cloud Analytics

Mercado Libre > Qlik Sense

Mercado Libre > Qlik

Mercado Libre > QlikView

Mercado Libre > Redash

Mercado Libre > Superset

Mercado Libre > Tableau

Mercado Libre > BI TOTVS

Mercado Libre > Zoho Analytics

Frequently Asked Questions (FAQ)

Answers about sending Mercado Libre data to Excel automatically

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.

Try out all the features for free for 14 days

Related on Kondado

Try out all the features for free for 14 days