From Olist Tiny to Excel: managed, scheduled, no code.
Kondado replicates 15 Olist Tiny pipelines including Orders, Invoices, Accounts Receivable, and Product Stock to Excel on a configurable schedule ranging from 5 minutes to daily, enabling automated financial tracking and inventory management without manual data entry.
Kondado enables automatic replication of your Olist Tiny ERP data directly into Excel workbooks on a configurable schedule that matches your business needs. Whether you require consolidated financial reports each morning or inventory updates every 15 minutes, our platform handles the complete data extraction and delivery process without manual CSV exports. Simply authenticate your account, select the pipelines containing your ecommerce transactions, payment records, and operational data, set your preferred frequency, and watch your spreadsheets populate automatically with information ready for immediate analysis using Excel’s native formulas and charting capabilities.
Users can leverage Excel’s familiar formulas and pivot tables to build custom dashboards that reflect current business operations, transforming raw ERP data into actionable insights for agencies and internal teams alike.
With Kondado’s Olist Tiny pipelines, you can pull detailed Order Details including line items and totals directly into Excel to calculate daily sales metrics and track fulfillment performance using familiar spreadsheet formulas. The Accounts Receivable pipeline delivers outstanding payment data that enables automated aging reports and cash flow projections, while the Product Stock pipeline ensures your inventory counts stay synchronized for demand planning and reorder point calculations. Once the data arrives in your workbook, you can apply custom formatting, create pivot tables for category analysis, or combine Olist Tiny figures with data from other sources to generate comprehensive business intelligence without switching between applications.
Try out all the features for free for 14 days
Replicated to Excel
Olist Tiny data available for Excel
Tables Kondado writes into your Excel, on a schedule you control.
15
available pipelines
792
extractable fields
Excel
Destination
Available integrations
CRM Issues
Includes fields such as assunto_id, assunto_cliente, and assunto_data_acao, enabling tracking of the stage and status of each issue in the CRM.
CRM Issues Details
Presents detailed information such as cliente_codigo, cliente_nome, and cliente_cidade, providing a comprehensive view of issues and their respective clients.
Accounts Payable
Contains data such as id, data_emissao, and valor, allowing effective management of accounts payable and their respective statuses.
Accounts Receivable
Includes information on receivables such as id, data_emissao, and saldo, facilitating the tracking of revenues to be received.
Contacts
Presents data such as cliente_id_cliente, cliente_nome, and cliente_email, allowing effective management of contacts and their information.
Accounts Payable Details
Includes fields such as id, data_vencimento, and historico, providing a detailed view of accounts payable and their conditions.
Accounts Receivable Details
Presents information such as id, data_vencimento, and saldo, allowing detailed control of accounts receivable.
Invoice Details
Includes fields such as id, numero_doc, and data_emissao, providing a detailed view of issued invoices.
Invoice Details: XML
Presents information in XML format, including fields such as id and xml_data, allowing technical analysis of invoices.
Order Details
Includes fields such as id, data_pedido, and valor_total, providing a comprehensive view of orders placed.
Product Stock
Contains information about the available quantity of products, including fields such as id, product name, and stock balance.
Invoices
Records details of issued invoices, including fields such as id, issue date, and customer name.
Orders
Includes information about placed orders, with fields such as id, order date, and order status.
Products
Presents data about registered products, including id, name, and selling price.
Products: grid
Provides a grid view of products, with fields such as id, name, and category.
Sync data automatically — no code, no manual exports.
1
Connect Your Olist Tiny Account
Log into Kondado and add Olist Tiny as a new data source by entering your API credentials. The platform will authenticate your ERP and display the available pipelines containing your ecommerce and financial data.
2
Set Up Excel Destination
Choose Excel as your destination and specify the target workbook where your Olist Tiny data should land. Kondado will prepare the connection to deliver structured data directly into your spreadsheet environment.
3
Select Pipelines and Schedule
Browse the 15 available pipelines such as Orders, Invoices, and Product Stock, then select those relevant to your reporting needs. Configure your update frequency, choosing from intervals as frequent as every 5 minutes or as spaced as daily, to keep your Excel reports current automatically.
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
Answers about sending Olist Tiny data to Excel automatically
How does Kondado send Olist Tiny data to Excel?▼
Kondado connects directly to your Olist Tiny ERP and extracts data from your selected pipelines on a configurable schedule. The platform then loads this information into your Excel workbooks automatically, ensuring your spreadsheets contain the latest orders, invoices, and inventory data without manual exports.
What specific Olist Tiny data can I access in Excel?▼
You can replicate 15 different pipelines including Orders, Invoices, Accounts Receivable, Product Stock, and CRM Issues. Each pipeline contains specific fields such as order totals, payment balances, stock quantities, and customer details that arrive as structured data ready for analysis in your spreadsheets.
How frequently can I update Olist Tiny data in my Excel files?▼
Kondado supports configurable schedules ranging from every 5 minutes to daily updates, allowing you to choose the frequency that matches your business needs. This ensures your financial reports and inventory tracking reflect recent transactions without overwhelming your workflow with constant manual refreshes.
Can I merge Olist Tiny data with information from other platforms in Excel?▼
Yes, once your Olist Tiny data arrives in Excel, you can combine it with data from additional sources such as Google Sheets, BigQuery, or PostgreSQL using standard Excel functions. This enables comprehensive analysis across your entire technology stack within a single workbook environment.
Does Kondado offer pre-built dashboards for Olist Tiny data?▼
Yes, Kondado provides ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report for users who prefer visual analytics. However, if you prefer working in spreadsheets, you can replicate the same underlying data to Excel and build custom reports using pivot tables and charts tailored to your specific requirements.
What format does Olist Tiny data take when it arrives in Excel?▼
The data arrives as structured rows and columns that map directly to the fields in your selected pipelines, such as invoice amounts, dates, and product SKUs. This tabular format integrates seamlessly with Excel's native features, allowing immediate use of formulas, filters, and data validation rules.
'%3E%3Cpath d='M51,41a9.978,9.978,0,0,0-7.857,3.835L22.648,34.588a9.69,9.69,0,0,0,0-5.176l20.5-10.247a10.1,10.1,0,1,0-1.791-3.577L20.857,25.835a10,10,0,1,0,0,12.33L41.352,48.412A9.994,9.994,0,1,0,51,41Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M33,47.645V60.71c.024-.014.05-.018.073-.033l11-7A2,2,0,0,0,45,51.992V40.012Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M31,47.645,19,40.011V51.992a2,2,0,0,0,.927,1.688l11,7c.023.015.049.019.073.033Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M32,21.693l12-7.634L33.076,7.086a2,2,0,0,0-2.152,0L20,14.059Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M12,35.556,0,27.922V39.9A2,2,0,0,0,.927,41.59l11,7c.023.014.049.019.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M52,35.556l12-7.634V39.9a2,2,0,0,1-.927,1.687l-11,7c-.023.014-.049.019-.073.033Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M47,38.914a2,2,0,0,0-.924-1.686L38,32.074V27.922l12,7.634V48.621c-.024-.014-.05-.019-.073-.033L47,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M13,33.821l12-7.634L14.076,19.214a2,2,0,0,0-2.152,0L1,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M17,38.914a2,2,0,0,1,.924-1.686L26,32.074V27.922L14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M32,45.91l12-7.634L33.076,31.3a2,2,0,0,0-2.152,0L20,38.276Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M14.076,19.214a2,2,0,0,0-2.152,0L1,26.187l12,7.634,12-7.634Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M49.924,19.214a2,2,0,0,1,2.152,0L63,26.187,51,33.821,39,26.187Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M26,27.922,14,35.556V48.621c.024-.014.05-.019.073-.033L17,46.726V38.914a2,2,0,0,1,.924-1.686L26,32.074Z' fill='%23383e51' data-color='color-2'%3E%3C/path%3E%3Cpath d='M27.076,25.138A2,2,0,0,1,28,26.824V30.8l1.848-1.179A4,4,0,0,1,31,29.123V23.428L19,15.794v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M36.924,25.138A2,2,0,0,0,36,26.824V30.8l-1.848-1.179A4,4,0,0,0,33,29.123V23.428l12-7.634v4.19Z' fill='%23383e51'%3E%3C/path%3E%3Cpath d='M33.076,31.3a2,2,0,0,0-2.152,0L20,38.276,32,45.91l12-7.634Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
'%3E%3Cpath d='M50.348,42.573c0-9.411-8.691-12.336-16.348-14.416v-16.1a32.837,32.837,0,0,1,9.363,1.656l2.778,1.11,2.228-5.57L45.584,8.134A38.043,38.043,0,0,0,34,6.046V1H30V6.081c-8.213.594-16.348,4.86-16.348,13.471,0,9.036,8.841,11.732,16.348,13.744V50.074a33.591,33.591,0,0,1-12.006-2.511l-2.683-1.341-2.684,5.367,2.684,1.342c.243.121,5.7,2.792,14.689,3.152V63h4V56.065C44,55.462,50.348,50.3,50.348,42.573Zm-30.7-23.021c0-5.133,5.96-7.016,10.348-7.446V27.071C23.512,25.243,19.652,23.535,19.652,19.552ZM34,50.043V34.393c6.5,1.882,10.348,3.761,10.348,8.18C44.348,48.377,37.873,49.744,34,50.043Z' fill='%23383e51'%3E%3C/path%3E%3C/g%3E%3C/svg%3E)
