Exporting Data

Harlequin’s Results Viewer is a great way to see query results, but sometimes you need to export data to use it in a different tool. Harlequin provides two easy options for this.

Using the Clipboard

The Results Viewer can copy selected data to the clipboard. First, select a range of cells using ctrl+a (to select all), holding shift while using arrows or other keys to move the cursor, or by clicking and dragging. Then press ctrl+c to copy the data to the clipboard.

Data is copied in a tab-separated-values format. This format is compatible with many other applications, and pastes nicely into Excel, Google Sheets, and the Harlequin Query Editor.

Tip

Copying works best when Harlequin has access to the system clipboard. If it doesn't work out of the box, see the troubleshooting guide for more information.

Exporting Files

Copying and Pasting is quick and easy, but often it is better to export he results of a query as a file. Harlequin provides a utility to export data in common formats, including CSV, Parquet, JSON, ORC, and Feather.

First, execute your query. Then, with the results visible, press ctrl+e to open the Data Exporter screen. Enter a file path, then select a format. Harlequin will then display the relevant options for that format.

Press enter or click the “Export” button, and Harlequin will write the file with all of the data from your query.