Creating a connection to Yandex Documents

To create a connection to Yandex Documents:

1. Open the connection creation page.

2. Under Files and services, select the Yandex Documents connection.

3. Add files depending on access permissions:

   Public

   Private

   1. Click Add file and navigate to the Public tab.

   2. Go to the service page.

   3. Right-click the required file and select Share. Click Copy.

      Note

      You can also get a link to the file in Yandex Disk. For more information, see this guide.

   4. In DataLens, paste the link into the Link to file in Yandex Documents field and click Add.

   5. If the file you are uploading contains several sheets, specify the ones you want to upload, or select all available. Each sheet is uploaded to a separate table.

   6. Click Add. Information about this file and the data to upload will appear at the center of the screen.

   Note

   Adding password-protected private files is not supported.

   1. On the connection page in DataLens, click Add file and navigate to the Private tab.

   2. On the tab, you will see a Yandex Documents authorization message. If authorized, proceed to the next step. If not, complete authorization:

      1. Click Log in.
      2. Select a Yandex account to log in to Yandex Documents.
      3. Allow DataLens to access your Yandex account. Click Next.

   3. Specify the Path to file in Yandex Documents relative to the root directory. Omit /disk at the beginning. You can view the file location in Yandex Documents: open the file and go to File → Table details.

   4. Click Add.

   5. If the file you are uploading contains several sheets, specify the ones you want to upload, or select all available. Each sheet is uploaded to a separate table.

   6. Click Add. Information about this file and the data to upload will appear at the center of the screen.

      To log out of your Yandex account, open the connection page and click next to the You are authorized in Yandex Documents button. Confirm token revocation. The sheets from the files with restricted access will no longer be displayed.

4. Set the Show column headers option to Yes or No.

5. Optionally, enable automatic updates for spreadsheet data. To do this, in the top-right corner, select Update automatically. Spreadsheet data will be updated every 30 minutes or less often. To update your data manually, click Update data.

6. Click Create connection.

7. Select the workbook to save your connection to or create a new one. If using legacy folder navigation, select a folder to save the connection to. Click Create.

8. Enter a name for the connection and click Create.

You can add, rename, and delete files in the connection.

Additional settingsAdditional settings

You can limit data export from charts based on this connection. To do this, click at the top right and uncheck Allow data export. With this option disabled, for charts based on the respective connection, the export data option will not be available in their menu. However, you will still be able to copy chart data and take screenshots.

LimitationsLimitations

Consider the following limitations when creating a connection to Yandex Documents:

• Currently, you can only upload xlsx files.
• Maximum number of table sheets per connection: 10. When creating a connection, all sheets will be loaded, but you can only select ten of them to work with at the same time.
• Maximum size per sheet: 200 MB.
• Maximum number of columns per sheet: 300.
• Minimum number of rows per spreadsheet: 2. In a spreadsheet with one row, you cannot identify column types as you cannot tell a header from a data row.
• The link to the file in Yandex Documents must be formatted as https://disk.yandex.ru/i/id. If the link contains /d instead of /i, you will get an error. What to do in case of the Invalid link format error