Live data access from Azure Synapse to Google Sheets

Unlock your data initiatives with live access to the data users need within any app or platform.

Provide safe, governed access to the data your teams need in a no/low-code interface, so they can access live data within the app, tool, or spreadsheet of their choice, accelerating analytics, business intelligence, and reporting.

Connect source to destination diagram
Azure Synapse Logo
Google Sheets Logo
Azure Synapse Logo

Azure Synapse:
Azure Synapse Analytics is a cloud-based analytics service provided by Microsoft Azure. It integrates data warehousing and big data analytics capabilities, allowing users to analyze large volumes of structured and unstructured data using familiar SQL-based queries. Azure Synapse provides a unified platform for data integration, warehousing, and analytics, enabling organizations to derive valuable insights from their data.

Google Sheets Logo

Google Sheets:
Google Sheets is a cloud-based spreadsheet program that allows users to create, edit, and collaborate on spreadsheets online. It offers a wide range of features, including formulas, charts, and conditional formatting. Users can access their spreadsheets from any device with an internet connection and easily share them with others for real-time collaboration.

Discover, blend, and access data from Azure Synapse in Google Sheets

No more downloading, wrangling, and uploading spreadsheets ever again! Connect Spreadsheets is the easiest way to get all your live data in your spreadsheets. Just connect to Azure Synapse, select the dataset you’d like to see, and import it into your spreadsheet. Schedule data refreshes, or click “Refresh” at any time to always get the latest version of data available.

  • Work with live Azure Synapse data in spreadsheets that updates as soon as the source system does, no data movement required
  • Consolidate from many sources into a single source-of-truth dashboard that others can view, collaborate on, and use in spreadsheet form
  • Create no/low-code queries to filter and find the Azure Synapse data you want in your spreadsheet without ever leaving the app.
  • Set a schedule for Connect Spreadsheets to update the data in your spreadsheet at certain times, so you know your data is always complete and accurate without needing to download, manipulate, and reupload every time you want to check a dashboard.

Access Azure Synapse in Google Sheets
Safeguard data

Azure Synapse to Google Sheets Features


icon

1. Install the add-in

Available in the Google Workspace Marketplace and Microsoft AppSource.

icon

2. Create a free account

Get started in minutes — no credit card required.

icon

3. Connect to your data

Set up your connections to more than 250 sources, powered by CData.

icon

4. Get your data

Select your data and see it in your spreadsheet at the click of a button.

Get started with CData Spreadsheets today