Microsoft Excel Integration

Researching SQL Server Microsoft Excel Integration issues? Check out these valuable tips, tutorials, how-to’s, scripts, and more perfect for SQL Server Developers.

Title Author Date
Query Folding in Power Query to Improve Performance Koen Verbeeck2026-05-29
Excel as Front End Application for SQL Server Sebastiao Pereira2024-08-12
Visualize Time Series Data using Microsoft Excel Hadi Fadlallah2024-04-23
DAX in Excel Step-by-Step Tutorial Nai Biao Zhou2023-08-24
Combine Data from Multiple Sheets in an Excel file with Power Query Nai Biao Zhou2023-07-18
Pivot Tables in Excel – A Step-by-Step Tutorial for Beginners Nai Biao Zhou2023-06-12
Learn how to use Power Query in Excel to Transform Data Nai Biao Zhou2023-05-17
Excel Line Charts and Scatter Charts with SQL Server Data Rick Dobson2022-08-23
How to Make a Chart in Excel from a SQL Server Database Mircea Dragan2021-01-06
Excel Data Import to SQL Server with PowerShell Diana Moldovan2020-11-09
How to Export Data from SQL Server to Excel Matteo Lorini2020-05-22
Use Excel Parameters to Dynamically Export SQL Server Data Ohad Srur2020-05-08
Load Excel Data Into SQL Server Matteo Lorini2020-02-28
Analyze SQL Server Results in Excel with Conditional Formatting Jim Evans2020-02-24
Read Excel File in SQL Server with OPENROWSET or OPENDATASOURCE Diana Moldovan2019-10-10
How to Create a Burndown Chart in Excel from Scratch Siddharth Mehta2019-05-03
Automate Field Selection for SSAS Tabular Models Power View Reports Siddharth Mehta2016-12-19
Using Microsoft Query in Excel to Retreive SQL Server Data Douglas Correa2016-11-23
Compare Tabular Databases vs. PowerPivot Daniel Calbimonte2016-10-18
Export data from SQL Server to Excel Jeremy Kadlec2016-02-01
Retrieve file sizes from the file system using Power Query Koen Verbeeck2015-09-09
Extracting a SharePoint List with Power Query Koen Verbeeck2015-05-15
Introduction to Power Query for Excel Koen Verbeeck2015-04-28
Passing Dynamic Query Values from Excel to SQL Server Junaith Haja2015-01-16
Using PowerShell to scan and find SQL Server database connection information inside MS Excel files Brian P ODwyer2014-05-28
Creating Power View Reports in Excel 2013 Arshad Ali2013-08-27
Teach Business Users How To Create Power View Reports With SQL Server Data Sources Arshad Ali2013-08-05
Power View Reports with SharePoint, Excel and SQL Server Example Arshad Ali2013-08-02
Microsoft’s new 3D data visualization BI product – GeoFlow Brady Upton2013-05-31
More Uses for Data Explorer for Excel Brady Upton2013-05-24
Introduction to Data Explorer for Excel Dattatrey Sindol2013-05-16
Using source data from an SSRS report in PowerPivot for Excel Siddharth Mehta2013-05-10
Creating Hierarchies in PowerPivot for Excel Dattatrey Sindol2013-03-18
Working with Columns and Properties in PowerPivot for Excel Dattatrey Sindol2013-03-08
Building Key Performance Indicators (KPIs) with PowerPivot Brady Upton2013-03-05
Combining Data from Multiple Relational Data Sources into One Table in PowerPivot for Excel Dattatrey Sindol2013-02-25
PowerPivot with Excel 2013 Brady Upton2013-02-01
Creating Linked Tables in PowerPivot for Excel Dattatrey Sindol2012-12-31
Import SQL Data from Multiple Data Sources into PowerPivot for Excel Dattatrey Sindol2012-12-26
PowerPivot Example with SQL Server 2012 Daniel Calbimonte2012-12-24
Introduction to PowerPivot for Excel and SQL Server Edwin Sarmiento2011-06-27
Using a SQL Server Linked Server to Query Excel Files Ranga Narasimhan2010-05-27
Import Excel data with SSIS Tim Cullen2010-05-11
Insert, Update or Delete Data in SQL Server from Excel Jeremy Kadlec2008-07-15
SQL Server Reporting with Microsoft Excel Jeremy Kadlec2008-02-21
Import Excel data into SQL Server using copy and paste Kun Lee2008-02-08