Exporting from SQL Server to Excel with column headers?

Question

I have a query that has approximately 20 columns and I would like to export this to an Excel file with the column headers.

I thought this would be easy to figure out but no luck! I searched the web and found one suggestion that did not end up working so I am stuck.

is this a onetime export or you trying to setup a job?

JoshBerke
– JoshBerke

2009-03-12 18:29:14 +00:00
Commented Mar 12, 2009 at 18:29 — JoshBerke
– JoshBerke, Commented Mar 12, 2009 at 18:29
Are you using Enterprise Manager or Management Studio?

Dan Roberts
– Dan Roberts

2009-03-12 18:31:25 +00:00
Commented Mar 12, 2009 at 18:31 — Dan Roberts
– Dan Roberts, Commented Mar 12, 2009 at 18:31

Jeff Kwiat · Accepted Answer · 2012-01-12 00:04:31Z

30

Tools --> Options, Select "Query Results" --> "SQL Server" --> "Results to Grid" and "Results to Text" (images below):

enter image description here

answered Jan 12, 2012 at 0:04

Jeff Kwiat

4711 gold badge5 silver badges4 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Michael Innes Over a year ago

You will need to restart SQL Server Management Studio for the settings to take effect.

Codezy · Accepted Answer · 2009-03-12 21:44:16Z

15

I typically do this by simply click the upper left corner in the results grid, copy, and then paste into Excel. There is one catch, you need to go into options->query results-> SQL Server->results to grid (or text if you want to save to file for import into excel) and turn on include column headers when copying or saving the results. I find this works great.

answered Mar 12, 2009 at 21:44

Codezy

5,5807 gold badges41 silver badges48 bronze badges

Comments

sam · Accepted Answer · 2012-02-15 10:08:17Z

4

This script rocks BCP to Export data to excel

answered Feb 15, 2012 at 10:08

sam

411 bronze badge

Comments

Gregory A Beamer · Accepted Answer · 2009-03-12 18:29:08Z

1

That is the default if you use the Import/Export wizard. You can also save this out to an SSIS package if you want to customize the export.

answered Mar 12, 2009 at 18:29

Gregory A Beamer

17k3 gold badges27 silver badges32 bronze badges

1 Comment

Mark Kadlec Over a year ago

Thanks Gregory, unfortunately I can't use the wizard since I have to automate to run every day.

donohealy · Accepted Answer · 2022-07-21 17:15:25Z

0

I know this is an old post, but my suggestion is not obvious in MS-SSMS so I'm passing it on.

RIGHT click on the upper left corner of the results grid and select 'Save Results As' and CSV and TXT formats are the two choices in 'Save as Type'.

This works best when the query results are too big for 'cut and paste' used for smaller query results.

answered Jul 21, 2022 at 17:15

donohealy

1

Collectives™ on Stack Overflow

Exporting from SQL Server to Excel with column headers?

5 Answers 5

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related