How does Kondado replicate Tray data to Excel?

Kondado connects directly to your Tray store using your API credentials to extract data from selected pipelines. The platform then structures this information into clean columns and rows before delivering it to your Excel workbooks on your chosen schedule. You maintain full control over which data endpoints replicate and how frequently updates occur.

What Tray data can I replicate to Excel?

You can replicate 14 different pipelines including Orders, Customers, Products, Sold Products, and Payments, covering 328 total fields. This includes detailed transaction information, customer contact details, product variants, and discount coupon usage. Each pipeline delivers specific datasets like order IDs, billing addresses, and sales quantities directly into your spreadsheets.

How often does Tray data update in Excel?

Kondado updates your Excel workbooks on a configurable schedule that you set during setup, with options ranging from every 5 minutes to daily intervals. You select the frequency based on your business needs, whether you need near-real-time sales tracking or daily summary reports. The automated schedule ensures your data refreshes consistently without manual intervention.

What format does Tray data take in Excel?

Data arrives in Excel as structured datasets with clear column headers corresponding to Tray fields, making it immediately usable for analysis. Each pipeline becomes a separate worksheet within your workbook, preserving data relationships between orders, customers, and products. You can apply Excel's native formulas, pivot tables, and charting tools directly to this organized information.

Can I combine Tray data with other sources in Excel?

Yes, Kondado enables you to replicate data from over 80 additional sources into the same Excel workbooks alongside your Tray information. This allows you to merge marketing campaign data from advertising platforms, inventory details from ERP systems, or financial metrics from accounting software with your eCommerce transactions. You can build unified reports that correlate customer behavior across multiple touchpoints using Excel's familiar analysis tools.

Do I need technical skills to set up the Tray to Excel replication?

No coding or technical expertise is required to connect Tray to Excel using Kondado's visual interface. You simply authenticate your Tray account through the authentication process, select your desired pipelines from the 14 available options, and specify your update schedule. The platform handles API connections, data transformation, and delivery automatically.

Can I send Tray data to destinations other than Excel?

Absolutely, Kondado enables you to replicate your Tray data to multiple destinations including Power BI , Looker Studio , Google Sheets , BigQuery , and PostgreSQL . You can configure different pipelines to route to different destinations simultaneously, such as sending Orders to Excel for daily reporting while streaming inventory data to BigQuery for warehouse analysis.

Send data from Tray 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

Connect Tray to Excel for Automated Data Replication

Connect your Tray store to Excel effortlessly using Kondado’s no-code data platform. You can replicate your eCommerce data automatically on a configurable schedule, ensuring your spreadsheets always reflect the latest transactions and customer activity without manual exports or CSV downloads. Simply authenticate your Tray account, select the specific pipelines you want to replicate from the 14 available options covering 328 fields, and configure your preferred update frequency from every 5 minutes to daily. Kondado handles the technical complexity, delivering clean, structured data directly to your Excel workbooks so you can focus on analysis rather than data preparation.

Kondado replicates data from Tray to Excel automatically on a user-configured schedule, supporting intervals from every 5 minutes to daily updates, with 14 available pipelines including Orders, Customers, and Products covering 328 fields.

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

Once your data arrives in Excel, you can immediately start building custom reports and pivot tables using the replicated information from your Tray store. The Orders pipeline delivers comprehensive transaction details including order IDs and delivery status, perfect for tracking sales performance and fulfillment metrics using familiar spreadsheet formulas and chart tools. Combine this with the Customers pipeline containing registration dates and contact information to segment your audience and calculate customer lifetime value. You can also analyze the Sold Products pipeline to identify top-performing items by correlating order quantities with specific product variants, enabling precise inventory planning and revenue forecasting directly in your workbooks.

Try out all the features for free for 14 days

Tray data available for Excel

available pipelines

328

extractable fields

Available integrations

Integration	Description
Customers	Includes information such as name, email, and registration date, along with modification date and last visit.
Discount Coupons	Contains details such as coupon code, creation date, and discount value, along with usage restrictions.
Newsletters	Presents information about the customer's email, newsletter status, and creation and modification dates.
Payments	Includes data on payment methods, status, and values of transactions made by customers.
Orders	Provides information such as order ID, order date, and delivery status, along with customer details.
Order Details	Includes detailed information such as order ID, billing address, and additional cart values.
Order Details: Mercado Livre	Presents data such as customer ID, estimated delivery date, and information about the purchased product.
Additional Product Information for Orders	Contains additional information such as product ID and product name related to each order.
Order Invoices	Includes data such as invoice ID and product CFOP, essential for accounting.
Order Transactions	Provides information on transaction status and values associated with each order made.
Products	Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.
Products (Kits)	Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.
Sold Products	Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.
Products: Variants	Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

Customers

Includes information such as name, email, and registration date, along with modification date and last visit.

Discount Coupons

Contains details such as coupon code, creation date, and discount value, along with usage restrictions.

Newsletters

Presents information about the customer's email, newsletter status, and creation and modification dates.

Payments

Includes data on payment methods, status, and values of transactions made by customers.

Orders

Provides information such as order ID, order date, and delivery status, along with customer details.

Order Details

Includes detailed information such as order ID, billing address, and additional cart values.

Order Details: Mercado Livre

Presents data such as customer ID, estimated delivery date, and information about the purchased product.

Additional Product Information for Orders

Contains additional information such as product ID and product name related to each order.

Order Invoices

Includes data such as invoice ID and product CFOP, essential for accounting.

Order Transactions

Provides information on transaction status and values associated with each order made.

Products

Table contains information about products, including id, name, and variants. Fields such as attributes_id and attributes_value provide additional details.

Products (Kits)

Table presents product kits, detailing id and attributes. Fields such as attributes_customer_attribute_id provide information about the characteristics of the kits.

Sold Products

Table displays sold products, including id and sales information. Fields such as order_id and order_item_quantity help understand sales performance.

Products: Variants

Table details product variants, including id and attributes. Fields such as additionalproductinfo_product_id and additionalproductinfo_variant_id provide specific information about each variant.

See all available data →

Try out all the features for free for 14 days

How to send Tray data to Excel

Sync data automatically — no code, no manual exports.

Connect Your Tray Store

Authenticate your Tray account in Kondado by providing your API credentials, allowing the platform to access your eCommerce data for replication.

Set Up Excel Destination

Configure Excel as your destination by specifying your Microsoft 365 account details and selecting whether to create new workbooks or update existing ones with your Tray data.

Select Pipelines and Schedule

Choose from the 14 available pipelines such as Orders, Customers, and Products, then set your preferred update frequency from every 5 minutes to daily. You can simultaneously replicate this data to additional destinations like Google Sheets or BigQuery for different analytical needs.

Try out all the features for free for 14 days