---
metadata:
- name: generator
content: Diplodoc Platform v5.63.0
alternate:
- en/workbooks-collections/export-and-import
- ru/workbooks-collections/export-and-import
- href: en/workbooks-collections/export-and-import.md
type: text/markdown
title: Markdown version
csp:
- script-src:
- https://mc.yandex.ru
img-src:
- https://mc.yandex.ru
connect-src:
- https://mc.yandex.ru
- wss://mc.yandex.ru
child-src:
- 'blob:'
- https://mc.yandex.ru
frame-src:
- 'blob:'
- https://mc.yandex.ru
frame-ancestors:
- 'blob:'
- https://mc.yandex.ru
canonical: en/workbooks-collections/export-and-import.html
title: Exporting and importing workbooks DataLens On-premises
description: Follow this guide to export and import DataLens On-premises workbooks.
vcsPath: en/workbooks-collections/export-and-import.md
---
# Exporting and importing workbooks DataLens On-premises
In DataLens, you can transfer [workbooks](./index.md) between installations using export and import tools. For example, you can export a ready-made workbook with its settings and connections from the cloud DataLens On-premises to an on-premise installation.
{% note info %}
* You can only export and import workbooks.
* Export is available to users with the `datalens.admin` role.
* Import is available to users who have permissions to create a new workbook.
{% endnote %}
## Exporting a workbook {#export-workbook}
To export a workbook:
1. In the left-hand panel, select **Collections and workbooks**.
1. Use one of the following methods to start exporting the workbook you need:
* Next to the workbook, click → **Export**.
* Open the workbook and click → **Export** at the top.
1. Click **Export**. You can see the progress in the indicator. Note the following:
* Workbooks are exported to a JSON file.
* This may take a few minutes.
* Sensitive [connection](../concepts/connection/index.md) data is not saved. During [import](#import-workbook), the user will have to set up connections again, e.g., specify a token or enter a password.
* Other DataLens versions may not support certain connection types. During import, such connection will not work.
If you try to close the indicator window before the export is complete, you will get the cancel export warning. Select:
* **Return** to continue the export.
* **Cancel export** to stop it.
Once the export is complete, you may get [warnings](./export-import-notifications.md#export-notifications) with workbook details and a list of objects requiring attention. To download the export file in JSON format, click **Download**.
{% note tip %}
You can edit the exported JSON file, e.g., add a password for a connection. However, DataLens does not guarantee successful import and correct operation of the workbook if you manually edit its configuration. We recommend that you carefully review all changes before import to mitigate possible issues.
{% endnote %}
If the workbook export fails, you will get an error [message](./export-import-notifications.md#export-notifications). Try to fix the error and re-export the workbook.
## Importing a workbook {#export-workbook}
To import a workbook:
1. In the left-hand panel, select **Collections and workbooks**.
1. In the top-right corner, click **Create** → **Create workbook**.
1. In the workbook creation window:
1. Enter a name for the workbook.
{% note info %}
The workbook name must be unique within the selected collection.
{% endnote %}
1. At the bottom, click **Select file** and select the JSON file with the workbook configuration.
1. Click **Create**.
You can see the import progress in the indicator. If you close the indicator window before the import is complete, it will not be interrupted. While the import is in progress, you will see the new workbook in the workbook list labeled as `Importing`, and selecting it will open the import progress window.
Once the import is complete, you may get [warnings](./export-import-notifications.md#import-notifications) with details of the imported workbook and a list of objects requiring attention. To go to the new workbook, click **Open workbook**. You can configure additional settings if you need to, e.g., enter a password for a connection.
If the workbook import fails, you will get an error [message](./export-import-notifications.md#import-notifications). Try to fix the error and re-import the workbook.
## Disabling workbook export {#workbooks-export-disable}
By default, users with the `datalens.admin` role can export workbooks. You can disable this option at the DataLens instance level. After you prohibit export:
* **Export** button will disappear from the workbook interface.
* Users will not be able to export workbooks.
* Any JSON export files created before you disable export may be imported to a new workbook.
Only the DataLens instance [admin](../security/roles.md#datalens-admin), i.e., a user with the `datalens.admin` role, can disable export.
To prohibit export of workbooks:
1. In the left-hand panel, select **Service settings**.
1. Select the **General** tab.
1. Disable **Workbook export** (enabled by default).