From Tiny ERP to Excel: managed, scheduled, no code.
Creating a pipeline that sends data from Tiny ERP to Excel spreadsheets takes only a few minutes with Kondado. And the whole integration from Tiny ERP to Excel is managed and executed by our platform. With Kondado, you can focus on extracting value from Tiny ERP data and combining it with other data in your Excel spreadsheet
Kondado provides a direct integration between Tiny ERP and Excel, allowing you to replicate your ecommerce, financial, and operational data automatically. Configure your data source once, set your preferred schedule from every 5 minutes to daily, and watch your spreadsheets populate with fresh data without manual exports. This pipeline-driven approach ensures your Excel workbooks always reflect current inventory levels, sales orders, and financial records from your ERP system.
Kondado is a data replication platform that connects Tiny ERP to Excel through automated pipelines, delivering near-real-time updates on a configurable schedule to eliminate manual data entry and keep your financial reports and inventory tracking current.
Replicate your Accounts Receivable pipeline to Excel to build aging reports and cash flow forecasts using familiar formulas, or replicate the Product Inventory pipeline to maintain up-to-date stock level monitoring across multiple warehouses directly in your spreadsheets. With Order Details data flowing automatically into Excel, you can create custom pivot tables analyzing sales trends by channel and product category without switching between systems. This automated data delivery transforms your Excel workbooks into dynamic business intelligence tools that reflect your actual Tiny ERP operations.
Try out all the features for free for 14 days
Replicated to Excel
Tiny ERP 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.
CRM Issues Details
Presents detailed information such as cliente_codigo, cliente_nome, and cliente_endereco, facilitating the analysis of associated contacts.
Accounts Payable
Contains records with id, data_emissao, and valor, allowing control over accounts payable and their respective statuses.
Accounts Receivable
Includes fields such as id, data_emissao, and saldo, facilitating the management of accounts receivable and their history.
Contacts
Contains information such as cliente_id_cliente, cliente_nome, and cliente_fone, allowing effective management of contacts.
Accounts Payable Details
Includes fields such as id, data_vencimento, and situacao, allowing detailed tracking of accounts payable.
Accounts Receivable Details
Presents information such as id, data_vencimento, and saldo, facilitating control over accounts receivable.
Invoice Details
Includes fields such as id, data_emissao, and historico, allowing detailed tracking of issued invoices.
Invoice Details: XML
Presents information in XML format, including fields such as id and tax data, facilitating integration with external systems.
Order Details
Includes fields such as id, data_pedido, and valor_total, allowing detailed tracking of placed orders.
Product Inventory
Table provides information about inventory, including fields such as id, product name, and available quantity.
Invoices
Table contains details of invoices, featuring fields such as id, issue date, and customer name.
Orders
Table lists the orders placed, including fields such as order id, order date, and status.
Products
Table presents information about products, with fields such as id, name, and price.
Product Grid
Table provides a detailed grid of products, including fields such as id, description, and category.
Sync data automatically — no code, no manual exports.
1
Connect Tiny ERP on Kondado
Authenticate your Tiny ERP account in Kondado by providing your API credentials to establish the data source connection. This creates the foundation for replicating your ecommerce and financial data.
2
Configure Excel destination
Set up Excel as your destination by selecting it from the available options and specifying your target workbook location. Kondado will prepare the connection to receive your Tiny ERP pipelines automatically.
3
Select pipelines and schedule
Choose which Tiny ERP pipelines to replicate, such as Accounts Receivable or Product Inventory, and configure your update schedule from 5-minute intervals to daily. Once activated, your selected data flows automatically into Excel on the schedule you defined.
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 Tiny ERP data to Excel automatically
How does Kondado replicate Tiny ERP data to Excel?▼
Kondado creates automated pipelines that extract data from your Tiny ERP account and load it directly into Excel workbooks on a configurable schedule. You select which data endpoints to replicate, configure the sync frequency, and Kondado handles the data transfer automatically. The platform supports 15 different pipelines including financial records, inventory data, and sales orders.
What Tiny ERP data can I replicate to Excel?▼
You can replicate 15 different pipelines covering CRM Issues, Accounts Payable, Accounts Receivable, Contacts, Invoices, Orders, Products, and Product Inventory. Each pipeline contains specific fields such as order IDs, issue dates, customer names, and inventory quantities, giving you access to 792 total fields from your ERP system for comprehensive analysis in Excel.
How frequently does my Tiny ERP data update in Excel?▼
Kondado updates your Excel data on a configurable schedule that you control, with options ranging from every 5 minutes to daily intervals. This near-real-time replication ensures your spreadsheets reflect current business operations without the delays associated with manual exports or batch processing.
Can I combine Tiny ERP data with other sources in the same Excel workbook?▼
Yes, you can replicate data from multiple sources into the same Excel workbook or alongside other destinations like Google Sheets, BigQuery, or PostgreSQL. This allows you to create unified reports that blend Tiny ERP financial data with marketing analytics from other platforms or inventory data from additional systems.
What format does Tiny ERP data arrive in when sent to Excel?▼
Data arrives as structured tables within your Excel workbooks, maintaining field names and data types from your Tiny ERP pipelines such as data_emissao, valor_total, and cliente_nome. The standardized format allows immediate use with Excel's native formulas, pivot tables, and charting tools without requiring data cleaning or transformation.
Does Kondado offer pre-built dashboards for Tiny ERP data?▼
Yes, Kondado provides ready-made report templates including the Olist Tiny Looker Studio Report and Olist Tiny Power BI Report for users who want immediate visualization capabilities. While these templates work with Looker Studio and Power BI, you can also export the same data structures to Excel and recreate these analyses using spreadsheet formulas and charts.
'%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)
