SQL DATA LENS provides the ability to export data to a variety of formats
- Text files (CSV)
- XML
- HTML
- SQL (INSERT, UPDATE or DELETE, INSERT)
- JSON
- Excel (XLS and XLSX)
In order to export the data there exists some options in SQL DATA LENS:
Save result
This feature is available in each result table, choose Save result and the data from the result table is saved to disk

The Save result function allows to configure many export parameter:

If you want to export a large amount of data, please use the feature direct to file!