How to export data from the results grid
Last modified: March 2, 2023
Query Builder allows selecting and exporting data from the results grid.
Selecting data in the results grid
You can select data from the results grid in one of the following ways:
-
Move the mouse pointer across the grid holding the left mouse button.
-
Click the first cell of the required data range, press the SHIFT key, hold it and click the last cell. A rectangular range of cells will be selected.
Right-click the selected data and click Export Data to invoke the Data Export Wizard. Alternatively, you can open it by clicking Export Data at the top of the grid.
Note
Query Builder comes with Paginal Mode enabled by default, limiting the selection to the first 1000 records. In order to export more records, disable the Paginal Mode and press Ctrl+End to fetch all the selected data at once. This will ensure that all the data is loaded into the Query Builder. Then, you can click Export Data at the top of the grid to launch the Data Export Wizard.
By following these steps, you can bypass the default limitation and export the desired data from Query Builder.
Exporting data from the results grid
Using Query Builder, you can export data to a variety of formats:
- Export data to HTML
- Export data to plain text
- Export data to XLS
- Export data to XLSX
- Export data to Microsoft Access
- Export data to RTF
- Export data to PDF
- Export data to JSON
- Export data to XML
- Export data to CSV
- Export data to ODBC
- Export data to DBF
- Export data to SQL
- Export data to Google Sheets
Additionally, you can save and use data export templates for recurring scenarios.