Exporting SQL query results to a CSV file

SQL query results can be shown on a grid. The contents of this grid can be exported to a CSV file (to, for example, load values into an Excel spreadsheet).

To export the contents of the SQL query results grid to a comma separated variable file):

  1. To select the whole grid, click the square at the top left corner of the grid (underneath the title bar).
  2. Make sure that the grid is the current window and that it contains valid data.
  3. Select Edit | Export to file.
  4. Choose whether or not you want to export the column headings, as well as the data values.
  5. Enter a name for the CSV file.

SQL and stored queries