How to Connect Via Kondado to Excel Desktop using Power Query

Step-by-step guide to import automated data directly into Excel using Power Query

What is Via Kondado?

Via Kondado is a Kondado platform destination that lets you access your integrated and modeled data through a simple API. With it, you can:

• Access 80+ data sources connected to Kondado
• Get data in CSV format through API links
• Automate updates in Excel without manual exports
• Build dynamic reports that refresh automatically

Ideal use case: Connect your ERP, e-commerce platform (Shopify, VTEX) or marketing tools (Meta Ads, Google Ads) directly to Excel and keep your spreadsheets always up to date.

What you need

Before you start, make sure you have:

1. An active Kondado account with configured pipelines
2. Excel 2016 or later (or Microsoft 365) with Power Query
3. A Via Kondado destination created on the Kondado platform
4. An access token for your Via Kondado destination

Step 1: Get the Access Link in Kondado

To connect Excel to your data, you first need to obtain the API access link:

1.1 Open your Pipeline

1. Log in to the Kondado platform
2. Click on Pipelines in the side menu
3. Select the pipeline you want to connect to Excel

1.2 Copy the Access Link

1. Inside the pipeline, click the View Data button
2. In the modal window, click Connect to Power BI (this also works for Excel)
3. Choose the decimal separator: comma or dot
4. Select the desired table
5. Click the copy icon next to the URL

The URL will look like:

https://hub.kondado.io/data/table_name?token=your_token_here&decimal_sep=comma

Save this URL — you will use it in Excel.

Step 2: Import Data into Excel with Power Query

Now let's connect Excel to your data using Power Query.

2.1 Open Power Query

1. Open Excel Desktop
2. Go to the Data tab
3. Click Get Data → From Other Sources → From Web

Tip: In newer Excel versions, you can find it directly at Data → Get Data → From Other Sources → From URL.

2.2 Paste the URL

1. In the dialog, paste the URL you copied from Kondado
2. Click OK

2.3 Configure Authentication

Power Query will ask for access credentials:

1. Select the Anonymous tab
2. Click Connect

Note: Authentication is handled via the token embedded in the URL, which is why we select "Anonymous" here. Keep your token secure and never share it publicly.

2.4 Preview and Transform Data

After connecting:

1. Power Query will display a CSV preview of your data
2. Verify that the columns are correct
3. Click Transform Data to adjust data types if needed
4. Or click Load to import directly

2.5 Adjust Data Types (Optional)

In the Power Query Editor:

1. Select the columns that need adjustment
2. Click the data type icon (e.g., "ABC", "123") on the column
3. Pick the right type: Text, Decimal Number, Date, etc.
4. Click Close & Load to import the data into Excel

Step 3: Data in Excel

Your data is now in the Excel spreadsheet! You will see:

• A formatted table with all the pipeline data
• Automatic refresh available
• The ability to create charts and reports

Step 4: Refresh Data Automatically

The real power of the integration is automatic refresh. You can:

Manual Refresh

Click Data → Refresh All to pull the latest data

Automatic Refresh

1. Click Data → Queries & Connections
2. In the side pane, right-click the connection
3. Select Properties
4. Under Refresh, check Refresh every X minutes
5. Set the desired interval (e.g. 60 minutes)

Tips & Best Practices

1. Decimal Format

If your numbers look wrong:

• Check that you picked the right separator in Kondado (comma vs dot)
• In Power Query, use Replace Values to fix separators

2. Large Data Volumes

For very large spreadsheets:

• Consider filtering data in Power Query before loading
• Use Load To → Only Create Connection + PivotTable for better performance

3. Token Security

• Never share your spreadsheet with the full link in public
• The token grants access to your data
• To share reports, export as PDF or remove the connection

4. Multiple Tables

You can repeat the process for several tables:

• Each table creates a separate connection in Excel
• Combine data using Merge Queries in Power Query

Troubleshooting

"Unable to connect"

• Check that the URL is complete (including the token)
• Confirm the Via Kondado destination is active in Kondado
• Test the URL in a browser first

"Data is not refreshing"

• Check that the Kondado pipeline is actually replicating data
• Click Data → Refresh All manually to test
• Confirm the automatic refresh settings

"Numbers appear as text"

• In Power Query, change the column type to Decimal Number
• Verify the decimal separator in the URL (comma vs dot)

"Special characters don't show up"

• Via Kondado normalizes characters for CSV compatibility
• This is expected to ensure universal compatibility

Next Steps

Now that your data is in Excel, you can:

1. Build charts and dashboards using data that refreshes automatically
2. Combine multiple sources via Power Query (Merge Queries)
3. Schedule reports for periodic refresh
4. Share insights with your team

Additional Resources

• Full Via Kondado documentation
• Create a Kondado account — 14-day free trial

Questions? Reach out to our support through the contact page.