Exporting Data to CSV, JSON, and More

There are two ways you can export database data in Beekeeper Studio.

1. Exporting the results of a SQL query
2. Exporting a whole table, or a filtered table view
3. Copying individual rows

Export Formats

Beekeeper supports saving data in a number of formats

Exporting SQL query results

After running your query in the SQL Editor, click the download button to export the results in a supported format.

You can choose to either download as a file, or copy the result to your clipboard.

Supported Download Formats

• CSV
• Excel
• JSON
• Markdown
• Excel friendly TSV for pasting into Excel or Google Sheets

Limits on SQL query downloads

By default Beekeeper Studio limits query results to 20,000 records (so you don’t crash the app). This limit also applies to the download (for the timebeing).

Exporting a table

Exporting a table is a little more complex, because a table could contain millions of records.

When you export a table (or filtered table view), Beekeeper Studio will execute the query and then stream the results to the download file.

To start an export, go to the table explorer view, click the ⚙ icon in the bottom right, and choose Export.

You can choose the location of the final file, and the format of the export, along with some advanced options, where appropriate (like pretty printing JSON exports).

From here, simply click run to start the process and generate your export.

Exporting a large table can take a long time. You’ll see a notification in the bottom right of the app to indicate the progress as it runs.

Table export formats

• CSV
• SQL (insert)
• JSON
• Newline delimited JSON (JSONL)

Copying individual rows

For any table in Beekeeper Studio, whether in the table explorer or the query results, you can right-click a cell and choose to export the whole row in a number of formats.

Row copy formats

• Excel-friendly TSV
• JSON
• Markdown
• SQL Insert

Easily copy database data and paste into Excel and Google Sheets

Beekeeper Studio’s row-copy format is designed to allow the quick and easy pasting of data into Google Sheets and Microsoft Excel.

Pasting data into a spreadsheet using this format will allow your spreadsheet software to automatically parse the data and distribute it across columns correctly.

I added this feature because this is one of my pet-peeves with copying data from other tools.