{"id":9155,"date":"2017-10-16T17:28:15","date_gmt":"2017-10-16T17:28:15","guid":{"rendered":"http:\/\/www.withdata.com\/blog\/?p=9155"},"modified":"2026-07-09T06:36:53","modified_gmt":"2026-07-09T06:36:53","slug":"create-excel-report-from-sql-server-database","status":"publish","type":"post","link":"https:\/\/www.withdata.com\/blog\/mssqltoexcel\/create-excel-report-from-sql-server-database.html","title":{"rendered":"Create Excel report from SQL Server database"},"content":{"rendered":"<p>Want to create Excel report from  <a href=\"https:\/\/www.microsoft.com\/en-us\/cloud-platform\/sql-server\">SQL Server<\/a>  database?<\/p>\n<p>Using <a href=\"https:\/\/www.withdata.com\/mssqltoexcel\/\">MsSqlToExcel<\/a>, you can generate excel report from SQL Server  easily and fast, no need to program, no need learn VBA, just a few mouse clicks!<\/p>\n<p>Here you can <a href=\"https:\/\/www.withdata.com\/down\/MsSqlToExcel.exe\">download<\/a> and install <a href=\"https:\/\/www.withdata.com\/mssqltoexcel\/\">MsSqlToExcel<\/a>.<\/p>\n<h2>Create an Excel report based on SQL Server <\/h2>\n<p> Click &#8220;Export From Query&#8221; at task dialog.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbtoexcel\/wizard-task.png\" ALT=\"SQL Server  reporting with Microsoft Excel - task window\" width=\"636\" height=\"455\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>then show the Export Query form.<\/p>\n<p>1. Enter query.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbtoexcel\/create-report-source.png\" ALT=\"Generate excel report from SQL Server  Query - select query\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\"><\/p>\n<p>2. Enter data file name.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbtoexcel\/create-report-target.png\" ALT=\"Create an Excel report based on SQL Server  Query Records - enter file name\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>3. Summary.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbtoexcel\/create-report-summary.png\" ALT=\"Create Excel report from SQL Server  - summary\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>4. Export.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbtoexcel\/create-report-convert.png\" ALT=\"generate Excel report from SQL Server  Query Resultset- export\" width=\"722\" height=\"572\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<p>5. View report.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/dbtoexcel\/create-report-view.png\" ALT=\"generate Excel report from SQL Server  Query Resultset - view report\" width=\"772\" height=\"560\" style=\"max-width:100%;height:auto;display:block;\" loading=\"lazy\" decoding=\"async\"><\/p>\n<hr style=\"clear: both;\" \/>\n<p><a href=\"http:\/\/www.withdata.com\/mssqltoexcel\/\">More about MsSqlToExcel &#8211; the tool to Create Excel report from SQL Server <\/a><\/p>\n<div style=\"clear: both;\">\n<p>30-day free trial <a href=\"http:\/\/www.withdata.com\/down\/MsSqlToExcel.exe\"><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/btn_download_green.png\" alt=\"Download MsSqlToExcel\" width=\"165\" height=\"50\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/><\/a>US$59.95 <a href=\"http:\/\/www.withdata.com\/mssqltoexcel\/purchase.html\"><img decoding=\"async\" src=\"http:\/\/www.withdata.com\/images\/btn_buynow_green.png\" alt=\"Buy MsSqlToExcel\" width=\"154\" height=\"45\" style=\"max-width:100%;height:auto;\" loading=\"lazy\" decoding=\"async\" \/> <\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Want to create Excel report from SQL Server database? Using MsSqlToExcel, you can generate excel report from SQL Server easily and fast, no need to program, no need learn VBA, just a few mouse clicks! Here you can download and install MsSqlToExcel. Create an Excel report based on SQL Server Click &#8220;Export From Query&#8221; at [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[52],"tags":[2344,15,1321,263],"class_list":["post-9155","post","type-post","status-publish","format-standard","hentry","category-mssqltoexcel","tag-create-excel-report-from-sql-server","tag-excel","tag-sql-server","tag-sql-server-export-excel"],"_links":{"self":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/comments?post=9155"}],"version-history":[{"count":1,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9155\/revisions"}],"predecessor-version":[{"id":9156,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/posts\/9155\/revisions\/9156"}],"wp:attachment":[{"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/media?parent=9155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/categories?post=9155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.withdata.com\/blog\/wp-json\/wp\/v2\/tags?post=9155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}