The export menu on the toolbar of the results writes the result of the query tab to a file or to the clipboard. It offers two kinds of export, separated in the menu. ![[20260806-qtm-export-menu.png]] ## Export of the Statement The first group writes the complete result of the statement, in the following formats: - Microsoft Excel (`.xlsx`) - CSV (`.csv`) - Tab-delimited text (`.tsv`) - Plain text (`.txt`) - XML (`.xml`) - JSON (`.json`) - NDJSON (`.ndjson`) - SQL insert statements (`.sql`) - SQL select statement (`.sql`) - SQL create table statement (`.sql`) These exports run the statement of the tab once more and write the fresh result, since the result on screen is not kept in memory. Consequences: - The bar with the progress and the cancel button appears again, and cancelling leaves a file which may be incomplete. - Sorting, filtering, grouping and hidden columns are not taken into account: the file holds the complete result of the statement. - A document or an image is written as it is, and not as the `[BLOB]` shown in the grid. - The export is unavailable after "Execute All" and when the statement produced no result set, since there is no single statement to run again. The three SQL formats take the name of the table from the name of the file, with spaces replaced by underscores. ## Export of the Current View The second group writes what is on screen: the visible columns in the order they are shown, and the rows in the order and the selection produced by sorting, filtering and grouping. - "Delimited Text (CSV)" writes a file with a semicolon as separator, in UTF-8. - "Clipboard" places the rows on the clipboard separated by tabs, ready to paste into a spreadsheet. Both report how many rows were written. A value holding a document or an image is written as the text `[BLOB]`. ## Formats Not Available PDF, Microsoft Word, XPS, HTML and RTF are not offered, and neither is printing. Those formats need renderers which are only available in the Microsoft Windows products; use [[Invantive Query Tool/Invantive Query Tool|Invantive Query Tool]] for Microsoft Windows when they are needed.