---
title: Jet Analytics Connector for Excel Online
description: "Jet Analytics provides various connectors for bringing data inside your Jet Data Manager. It provides you the functionality to import data from SQL Server, flat files and other custom data sources. One such method is to import data through **Excel…"
url: "https://globaldata365.com/helpcenter/jet-analytics-connector-for-excel-online/"
updated: "2026-08-20"
category: Jet Analytics
tags:
  - jet analytics
---

# Jet Analytics Connector for Excel Online

Jet Analytics provides various connectors for bringing data inside your Jet Data Manager. It provides you the functionality to import data from SQL Server, flat files and other custom data sources. One such method is to import data through **Excel Online**. You will learn how you can import data using [Jet Analytics](https://globaldata365.com/jet-analytics/) Connector for Excel.

 

## Installing CData Provider

 

In your[Jet Data Manager](https://globaldata365.com/jet-data-manager-training/), navigate to **Tools** and select **Manage CData Providers.**

![CData Provider](https://globaldata365.com/wp-content/uploads/2023/02/image-1.png)

Select **Add** and then move onto the list of Data Source providers.

![CData Provider](https://globaldata365.com/wp-content/uploads/2023/02/image-2.png)

Choose **Excel Online** and click **OK.**This will download the required data source provider.

![Data Source Provider](https://globaldata365.com/wp-content/uploads/2023/02/image-3.png)

 **Want to turn raw ERP data into powerful business insights?**
[👉 Join our Jet Analytics Training](https://globaldata365.com/jet-analytics-training/) and master building data warehouses, cubes, and advanced dashboards.

## Setting up Data Source with Excel

 

Right click **Data Sources** and navigate to **Add CData Data Source.**

![Data Source](https://globaldata365.com/wp-content/uploads/2023/02/image-4-1024x618.png)

Provide a suitable **Name** and set the provider to **Microsoft Excel Online.**

![CData Data Source](https://globaldata365.com/wp-content/uploads/2023/02/image-5.png)

At the bottom of window, select **Authorize OAuth** to configure the authorization.

![](https://globaldata365.com/wp-content/uploads/2023/02/aaaa.png)

You will be prompted to select your **Microsoft** account. After signing in, you will receive the message for successful authorization.

![Jet Analytics Connector for Excel](https://globaldata365.com/wp-content/uploads/2023/02/image-6-1024x450.png)

On successful authentication, you will return back to Jet Data Manager. Now navigate to the **OAuth**section. Go to drop down list infront of **Initiate OAuth** and select the option **REFRESH.**

![Jet Analytics Connector for Excel](https://globaldata365.com/wp-content/uploads/2023/02/image-7.png)

Now provide **OAuth Client Id**and**OAuth Client Secret.**The default value for both of them is an empty string (**" "**). Click **OK** to close the window.

![](https://globaldata365.com/wp-content/uploads/2023/02/image-8.png)

Now right click the data source and select **Read Objects from Data Source.**

![Jet Analytics Connector for Excel](https://globaldata365.com/wp-content/uploads/2023/02/image-9.png)

This will bring all Excel files available online and you can choose your desired file.

![Jet Analytics Connector for Excel](https://globaldata365.com/wp-content/uploads/2023/02/image-11.png)

**Preview table** to see the data.

![Jet Analytics Connector for Excel](https://globaldata365.com/wp-content/uploads/2023/02/image-10.png)

####  

#### If You Need Any Help for Jet Analytics Connector for Excel and more, [Contact us](https://globaldata365.com/contact/) Now!

###### Still have Questions?

Ask us anything about this article – we’ll get backto you shortly. 

.elementor-template-wrapper.elementor-template-53310 { display: block; width: 100%; clear: both; position: relative; z-index: 1; margin: 30px 0 40px; padding: 0; box-sizing: border-box; }

/* Make sure Elementor's generated content participates normally in the document flow */ .elementor-template-wrapper.elementor-template-53310 .elementor { position: relative; width: 100%; }

/* Prevent floated elements above/below from causing the template to overlap */ .elementor-template-wrapper.elementor-template-53310::after { content: ""; display: table; clear: both; }

/* Mobile spacing */ @media (max-width: 767px) { .elementor-template-wrapper.elementor-template-53310 { margin: 25px 0 30px; } }