There are two ways you can export database data in Beekeeper Studio.
- Exporting the results of a SQL query
- Exporting a whole table, or a filtered table view
- 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.