SQL Server Query Analyzer Results to Excel (TSV)

I tried to run a query today and have the results go to a file. The output was a ton of rows with only one column. If you need to output query analyzer results to a format compatible with Excel just do the following:

1. Go to “Tools”
2. Click “Options”
3. Click the “Results” tab
4. Under “Results output format: (*)”, select “Tab Delimited”
5. Make sure “Print column headers (*)” is selected
6. Click “OK”

Now when you run your query the results will be in TSV format with the column headers.

Enjoy!