Microsoft Excel data integration tutorials
Tutorials for querying live business data from Microsoft Excel with Microsoft Query and CData ODBC drivers, including parameters, joins and refreshing.
What this integration does
Microsoft Query is the legacy data import wizard in Excel for Windows. It works with any ODBC data source, so once a system is exposed through ODBC you can run SQL against it, bring the rows into a worksheet and drive a filter from a cell. The workbook stays connected to the source, which means a refresh returns current rows without another export.
How CData fits in
CData ODBC drivers present SAP, Jira, SharePoint, Snowflake, Active Directory and hundreds of other sources as ordinary ODBC data sources. You install the driver, set up a DSN, and Excel sees tables it can query. The tutorials cover the practical parts: the connection settings that trip people up, parameterized queries, joins, and keeping a report refreshable.
Microsoft Excel tutorials by data source
Active DirectoryExport Active Directory Users to Excel (and Keep the List Live)
Export Active Directory users to Excel with an LDAP ODBC driver and SQL. Covers what you need, limiting the search to one OU, slow queries and refreshing.
JiraJira Time Tracking in Excel: Join Issues and Projects with SQL
Build a live Jira time-spent report in Excel with an API token and ODBC. Join Projects and Issues in SQL, filter by reporter, and pivot by project lead.
SAPHow to Pull SAP Material Master Data into Excel Without ABAP
Query SAP material master data (MARA) from Excel with ODBC and SQL. Covers RFC connection types, what to ask Basis for, and a report you can refresh.
SharePointSharePoint List to Excel: Export, Power Query, or SQL over ODBC?
Compare three ways to get a SharePoint list into Excel, then use SQL over ODBC for SharePoint Online or on-premises, including a parameterized query.
SnowflakeConnect Excel to Snowflake over ODBC: MFA and Warehouse Costs
Connect Excel to Snowflake with the CData ODBC driver. Covers connection properties, Duo MFA, and habits that keep warehouse compute use low.
Don't see your data source or tool?
CData connects hundreds of sources to the tools you already use. Browse the connectors, or talk to us about a specific setup.