Category: SQL

  • 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!

    Share