Connect Spreadsheets

Connect Spreadsheets is the easiest way to get all your live data into Microsoft Excel – no more downloading, wrangling, and uploading files.

With Connect Spreadsheets, just connect to your data, 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 in the source system.

Connect Spreadsheets is brought to you by CData, the real-time data connector company, used today by Google, Oracle, Informatica, Intel, Office Depot, Tableau, Salesforce, and more.

Use Connect Spreadsheets for free, forever, no credit card required. Unlock professional features and usage with a paid plan.

----------------------------

✓ Features

- Easy Connection Setup – Configure connections that just need your credentials and authentication, with documentation and help guides to get started.

- Query Builder – Create no/low-code queries to filter and find the dataset you want in your spreadsheet without ever leaving Microsoft Excel.

- Custom SQL – Input your own custom SQL to have complete control over the data you want to see out of your data source.

- Scheduled Refreshes – 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.

- Helpful Community Support – Ask questions, get help, and discover how other users are using Connect Spreadsheets to work with their data in spreadsheets.

✓ Use Cases

- Consolidate from many sources into a single source-of-truth dashboard that others can view, collaborate on, and use in spreadsheet form

- Work with live data in spreadsheets that updates as soon as the source system does, no data movement required

- Sync your accounting and finance data from QuickBooks Online, Sage Intaact, ADP, and more into the spreadsheets you know and love

- Select and build datasets you need for each unique use case with ease

✓ Other Supported Connections

- Accounting (ADP, Zoho, Xero, Sage, QuickBooks Online, and More)

- Big Data (Amazon Redshift, Google BigQuery, Snowflake, MongoDB, and More)

- Collaboration (Confluence, Sharepoint, Slack, Smartsheet, Trello, Asana and More)

- CRM & ERP (Salesforce, NetSuite, SAP, Workday, ServiceNow, and More)

- E-Commerce (Shopify, ShipStation, Stripe, Square, BigCommerce, and More)

- File & API (REST API, OData, S3, Azure Data Lake, Twilio, and More)

- Marketing (Facebook, Instagram, Google Ads, Google Analytics, Hubspot, LinkedIn, Marketo, SendGrid, and More)

- RDBMS (AlloyDB, Google Spanner, MySQL, PostgreSQL, SAP HANA, SQL Server)

Interested in more features to explore and blend data, as well as unlocking connectivity to more than just spreadsheets? Check out CData Connect Cloud, our platform solution to live data connectivity that unlocks not just spreadsheet destinations, but BI and Analytics platforms such as PowerBI, Tableau, and Looker, automation platforms like Power Automate and Power Apps, and much more.