Exports the output of one or more TSQL script queries to a Microsoft Excel Workbook.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
App.config
LICENSE
Program.cs
README.md
Run SQLtoExcel.bat
SQLtoExcel.csproj
SQLtoExcel.csproj.user
Utils.cs

README.md

SQL to Excel

Iterates though a folder of *.sql script files, executing each script, capturing the script query output, and writing the results to a Microsoft Excel Worksheet file (one worksheet per script file).

Quick Start:
Download the files from the latest release and copy one or more SQL scripts into the same folder. Edit the .bat file to specify the name of the SQL instance you want to connect to and the name of the database (db name may or may not be applicable, depending on how the scripts are written). Launch the .bat file and SQLtoExcel.exe will iterate through the SQL scripts in the directory, run each script, capture the script query output, and write it to an Excel spreadsheet. A separate worksheet for each script is created, with the script file name used for the worksheet name.

Other Notes
SQLtoExcel.exe attempts to ignore “GO” batch separators. If there are #temp tables that span batches, you may encounter errors.

Blog Post with some screen grabs: Introducing SQL-to-Excel