Exporting Data

How to get data out of your database and into a convenient file type

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.

Click Download

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.

Image Alt Tag

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.

Image Alt Tag

Row copy formats

Excel & Google Sheets friendly TSV format

This is a row-copy format designed to allow the quick and east 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.
Image Alt Tag

On this page

    This site is powered by DuckDocs.