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
![](https://sqldatalens.com/wp-content/uploads/2021/11/image.png)
The Save result function allows to configure many export parameter:
![](https://sqldatalens.com/wp-content/uploads/2021/11/image-1.png)
If you want to export a large amount of data, please use the feature direct to file!