How does Kondado replicate VTEX data to Excel?

Kondado connects directly to your VTEX account using secure authentication, then extracts data from your selected pipelines on a configurable schedule. The platform automatically structures the information into Excel workbooks, preserving data types and relationships so your formulas and pivot tables function correctly with each automated refresh.

What VTEX data can I replicate to Excel?

You can replicate data from 17 available pipelines including Orders, Stock, Products, SKUs, Coupons, and Master Data, encompassing 432 total fields. This covers everything from order details and payment transactions to inventory levels by warehouse and promotional campaign performance.

How often does VTEX data update in Excel?

You configure the replication frequency based on your business needs, with options ranging from every 5 minutes to daily intervals. This automated schedule ensures your Excel reports reflect current ecommerce activity without requiring manual data exports.

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

Data arrives as structured tables within Excel workbooks, maintaining proper column headers and data types for immediate analysis. You retain full control to apply conditional formatting, create charts, and build custom calculations using standard Excel functions while the underlying data refreshes automatically.

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

Yes, Kondado allows you to replicate data from multiple sources such as VTEX , advertising platforms, or PostgreSQL into separate tabs within the same Excel workbook. This enables unified analysis where you can correlate ecommerce metrics with advertising spend or financial records using VLOOKUP and Power Query.

Are there pre-built dashboards available for VTEX data?

Yes, Kondado offers ready-made report templates including the VTEX Power BI Report and VTEX Looker Studio Report for users who prefer dashboard visualization. If you choose to work in Excel instead, these report templates demonstrate best practices for organizing your data that you can adapt for spreadsheet analysis.

What Excel features work best with replicated VTEX data?

Replicated data supports Excel's full analytical capabilities including pivot tables for order analysis, Power Query for data transformation, and XLOOKUP functions for inventory matching. Since updates preserve your existing workbook structure, scheduled refreshes maintain your charts and calculated columns without breaking references.

Send data from VTEX 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 VTEX Data to Excel Automatically

Connect VTEX as a data source in Kondado, select your desired pipelines from the 17 available options, and designate Excel as your destination. The platform handles the replication automatically on your chosen schedule, delivering fresh ecommerce data directly to your spreadsheets without manual CSV exports or copy-paste routines. Once configured, your Excel workbooks populate with current order details, inventory levels, and promotional metrics, ready for immediate analysis using familiar formulas and pivot tables.

Kondado provides a direct connection between VTEX and Excel, replicating 17 data pipelines including Orders, Stock, and Products on a configurable schedule ranging from every 5 minutes to daily. The service automatically structures 432 fields of ecommerce data into Excel workbooks, enabling analysts to build inventory forecasts, sales reports, and financial summaries using familiar spreadsheet formulas.

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

Available VTEX Pipelines for Excel

With the Orders pipeline feeding into Excel, you can build dynamic sales dashboards that track order status, total value, and shipping timelines across all channels, enabling rapid identification of fulfillment bottlenecks before they impact customer satisfaction. The Stock pipeline powers automated inventory forecasting by warehouse location, helping procurement teams maintain optimal SKU levels and prevent stockouts during peak seasons. Meanwhile, marketing analysts leverage the Marketing Data of Orders pipeline to attribute revenue to specific UTM campaigns and affiliate IDs directly within pivot tables, calculating true ROI on promotional spend and coupon effectiveness without ever leaving their familiar spreadsheet environment.

Try out all the features for free for 14 days

VTEX data available for Excel

available pipelines

432

extractable fields

Available integrations

Integration	Description
Coupons	Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.
Stock	Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.
Master Data	Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.
Orders	Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.
Shipping Data of Orders	Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.
Marketing Data of Orders	Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.
Order Details	Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.
Logistics Information of Orders	Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.
Order Items	Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.
Payments: Order Transactions	Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.
Orders: Fees and Benefits	Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.
Orders: Totals	Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.
Products	Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.
Promotions	Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.
SKUs	Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.
SKUs: Kits	Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.
SKUs: Prices	Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

Coupons

Includes fields like coupon_id, expirationintervalperuse, and isarchived, allowing management of promotions and their reuse intervals.

Stock

Presents data such as skuid, warehouseid, and totalquantity, providing information on the stock position of SKUs by warehouse.

Master Data

Contains fields like id, updatedin, and createdin, allowing management of entities and their dynamic properties.

Orders

Includes information such as orderid, status, and totalvalue, allowing detailed tracking of orders and their status.

Shipping Data of Orders

Provides shipping details including shippingestimateddate and shippingestimateddatemax, essential for logistical management.

Marketing Data of Orders

Includes information such as affiliateid and utmcampaign, allowing analysis of marketing campaigns associated with orders.

Order Details

Presents fields like lastmessageunread and callcenteroperatorname, offering insights into customer communication and service.

Logistics Information of Orders

Includes data such as invoiceinput and invoiceoutput, essential for managing fiscal and logistical documents.

Order Items

Contains information about each order item, such as totalitems and paymentnames, allowing detailed analysis of purchased products.

Payments: Order Transactions

Includes details about payment transactions, such as paymentnames and totalvalue, essential for financial control of orders.

Orders: Fees and Benefits

Includes information about fees and benefits associated with orders, such as totalvalue, shippingestimateddate, and paymentnames.

Orders: Totals

Presents the totals of orders, including orderid, totalvalue, and totalitems, along with details about the creation date.

Products

Contains data about available products, including skuid, warehousename, and totalquantity, along with pricing information.

Promotions

Provides details about promotions, including coupon_id, expirationintervalperuse, and maxitemsperclient, along with campaign information.

SKUs

Presents information about SKUs, such as skuid, totalquantity, and reservedquantity, along with data on stock availability.

SKUs: Kits

Includes data about SKU kits, allowing the visualization of product combinations along with their respective quantities and prices.

SKUs: Prices

Provides information about SKU prices, including skuid and pricing details, allowing for cost and promotion analysis.

See all available data →

Try out all the features for free for 14 days

How to send VTEX data to Excel

Sync data automatically — no code, no manual exports.

Connect Your VTEX Account

Log into Kondado and add VTEX as a new data source by entering your API credentials. This establishes the direct connection needed to access your ecommerce pipelines.

Configure Excel Destination

Select Excel as your destination and specify the workbook location where Kondado should deliver the replicated data. You can send data to existing files or create new workbooks automatically.

Select Pipelines and Schedule

Choose from the 17 available VTEX pipelines such as Orders, Stock, or Products, then set your preferred update frequency from every 5 minutes to daily. Kondado will begin replicating the selected fields immediately according to your schedule.

Try out all the features for free for 14 days