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.




Leave a Reply

Your email address will not be published. Required fields are marked *