Database Workbench offers two wizard for easy exporting of data to different file formats, different editions support different export formats.
The Export Data Wizard - Database > Export Data let's you export data from one or more tables or views. Alternatively, the context menu on a table, view, list of tables or views in the Database Navigator lists these options as well.
Export Data Wizard - output format and templates page
You can save your current export settings to a template, which will show up automatically on the Output Format page. Alternatively, you can load a new template not in the list, by using the Template button on the bottom left.
Customizing the Export
You can select the amount of rows to export, more options may be available depending on the export format.
If you have a very large amount of records, you perhaps want to export a few records only - anyway, select one of the predefined options or enter a custom amount.
To export the result of a custom SQL statement, use the Export Result set button in the SQL Editor - the statement will be re-executed and is optimized for high speed forward only access.
The last page shows you a summary and allows you to save your current export settings to a template for later re-use.
See also: File and Folder Boxes