Excel

This guide walks you through setting up the integration between Unistream and Microsoft Excel.

Prerequisites

You will need:

• Microsoft Excel installed on your computer

• Clickhouse ODBC driver

• Unistream platform credentials (email and password)

Installation Steps

1. Install Clickhouse ODBC Driver

1. Download the Clickhouse ODBC driver from the official GitHub repository: https://github.com/ClickHouse/clickhouse-odbc/releases

2. If Windows is preventing you from running the .msi file:

   • Unzip the zip file

   • Right-click on the .msi file → Properties

   • At the bottom of the Properties window, you will see a checkbox labeled "Unblock"

   • Check this box and click "Apply" then "OK"

   • Now you can run the installer

3. Install the driver by following the installation wizard instructions

2. Connect Excel to Unistream

1. Open Microsoft Excel

2. Navigate to the Data tab in the ribbon

3. Click on Existing Connections

4. Select Browse for More

5. Locate and choose the Unistream_con.odc file you downloaded from the Unistream platform

6. Click OK

7. Enter your Unistream credentials:

   • Username: Your email address used for Unistream

   • Password: Your Unistream password

8. Click OK to establish the connection

Working with Unistream Data in Excel

Loading a Complete Table or View

1. In Excel, click on Queries & Connections

2. In the right panel, right-click on the connection named "The best Data Platform"

3. Select Edit

4. This will open the Power Query Editor

5. In the Applied Steps panel on the right, click the settings icon (gear) on the navigation step

6. Select any other table from the dropdown menu

7. Click OK to load the selected table

Running Custom SQL Queries

1. Follow steps 1-3 above to open the Power Query Editor

2. Remove all steps except the Source step

3. Click the settings icon (gear) on the Source step

4. Replace the default query with your custom SQL

5. Click OK to execute your custom query

Using Pivot Tables with Unistream Data

You can create powerful data visualizations by using Pivot Tables with your Unistream connection:

1. Select your data range

2. Navigate to the Insert tab

3. Click Pivot Table

4. Choose your data source and placement

5. Build your pivot table using the Unistream data fields

Video Tutorial

For a complete walkthrough of these features, watch our tutorial video

Troubleshooting

If you encounter connection issues:

• Verify your Unistream credentials

• Check that the Clickhouse ODBC driver is properly installed

• Ensure your network allows connections to the Unistream platform

• Contact your system administrator for assistance with firewall settings

For additional support, please contact the Unistream support team.