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.

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

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.

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

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

Tiny ERP data available for Excel

available pipelines

792

extractable fields

Available integrations

Integration	Description
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.

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.

See all available data →

Try out all the features for free for 14 days

How to send Tiny ERP data to Excel

Sync data automatically — no code, no manual exports.

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.

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.

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