Export SQL Data to Excel with Column Headers
Export SQL Data to Excel with Column Headers
How many times have you had to write up a quick query in SQL Management Studio for someone and then export the data out to Excel? Exporting data from SQL Server is a fairly long process and involves several steps, but once you do it a few times, it’s not bad.
One thing I learned about saving SQL query results into Excel format or CSV format is that it’s best to use the SQL Import and Export Wizard rather than trying to right-click on the results and saving them.
Table of Contents
export sql to excel export sql to excel
You can always right-click and choose Save Results As, however, the CSV file that you get will not contain the column headers! This is a royal pain if you have 50 columns.
Export SQL Data to Excel
To export SQL data the correct way, right-click on the database (not the table) and choose Tasks, Export Data.
tasks export data tasks export data
Next, you need to choose the Data Source. If you right-clicked on the database name, then everything should come up automatically.
choose data source sql choose data source sql
Now you need to choose the Destination. Go ahead and pick Microsoft Excel from the drop down list. After that, you will need to click Browse and choose the location for the output Excel file. Also, be sure to keep the “First row has column names” box checked.
sql data to excel sql data to excel
Next, you can either choose to export an entire table/view to Excel or to write your own query. In my case, I will write a specific query for the data that I want to export.
ekspor data ke excel ekspor data ke excel
Ketik kueri Anda lalu klik Parse untuk memastikan semuanya sudah benar.
ekspor kueri sql ekspor kueri sql
Terakhir, klik Next lalu klik Finish. Data SQL Anda akan dikeluarkan ke dalam file Excel dan itu akan mencakup semua header kolom juga! Menikmati!
ekspor data ke excel ekspor data ke excel
Ketik kueri Anda lalu klik Parse untuk memastikan semuanya sudah benar.
ekspor kueri sql ekspor kueri sql
Terakhir, klik Next lalu klik Finish. Data SQL Anda akan dikeluarkan ke dalam file Excel dan itu akan mencakup semua kolom header juga! menikmati!
Sekian artikel tentang Export SQL Data to Excel with Column Headers. Baca juga artikel mengenai F8 Tidak Bekerja Di Windows 10? 5 Hal Yang Harus Dicoba yang mungkin perlu Sobat ketahui.