# Export Data from Bkper

You own the data in your Bkper Books and can export it at any time. Common reasons to export:

- Make periodic **backups**
- **Merge** or copy transactions to another Book
- Use the data in **another system**

## Exporting to Google Sheets

Use the [Bkper Add-on for Google Sheets](https://bkper.com/docs/guides/google-sheets.md) to export data directly into a spreadsheet.

Open the add-on from **Extensions > Bkper > Open**:

Select your **Book**, choose **Transactions**, enter a **query** that covers the date range you need (for example, `before:$y+10` to include all transactions), and press **Fetch**.

All matching transactions are exported to the spreadsheet:

> **Tip**
> - To export all transactions, use a query that spans the entire date range of your Book, such as `before:$y+10`.
> - Attachments are exported as links.
> - Enable the **Properties** option in the add-on to include custom property keys and values.
> - Each time you open the Google Sheet, Bkper Functions automatically refresh the fetched data.
> - From Google Sheets you can download the data as **CSV**, **Microsoft Excel**, or **PDF**.
To copy or merge transactions into another Book, export them to a spreadsheet first, then [import](https://bkper.com/docs/guides/using-bkper/data-import-export/import-data.md) them into the target Book.

## BkperApp for Google Apps Script

The [BkperApp library](https://bkper.com/api) for Google Apps Script gives you programmatic access to export data to any destination you need.

## Batch exporting Accounts

The [Bkper Add-on for Google Sheets](https://bkper.com/docs/guides/google-sheets.md) lets you export all Accounts from a Book in one step. This is useful for creating backups, building templates, or reviewing your Account structure outside of Bkper.

Open a Google Sheet and go to **Extensions > Bkper > Open**. Select your Book, switch to the **Fetch** tab, and choose **Accounts**. Click the cell where you want the data to start, then press **Fetch**.

The **Name**, **Type**, and **[Groups](https://bkper.com/docs/core-concepts.md#groups)** of each Account are listed in the spreadsheet, ready for reuse as a template or further processing.