The output format in the result window is always Table mode, which provides a friendlier interface which ensures all of the columns are lined up properly. If you right-click on a table or multiple tables, you can save the results to a file in HTML or CSV format. The HTML format consists of a table containing results of the select statement. The CSV format, produces a comma-separated values file with a header row, which is suitable for importing to any spreadsheet program, such as Microsoft Excel or OpenOffice Calc.

CSV files are often used as a simple way to transfer a large volume of spreadsheet or database information between programs, without worrying about special file types. For example, transferring a home-made address book from Power*Architect into a database program such as Filemaker Pro could be done by exporting the file as a CSV from Excel, then importing that CSV into Filemaker.

For example, here are the results of executing the select statement, "select * from art_logs":

You can view this same data in HTML by right-clicking the selected table, then choosing "Exported selected to HTML..". Here is what the generated HTML looks like in a text editor:

and formatted in a web browser:

With the addition of a custom CSS style sheet, this HTML page could fill a basic reporting need. For more advanced report layout, be sure to try Wabit, the open source reporting tool from SQL Power.