Basic tasks
Access
Import
To open a local file, drag and drop it on the platform. Alternatively, go to Sidebar > Browse () > Top Menu and click the Open file () icon or the Import text () icon, which lets you configure the text file before import.
Open in Datagrok
To open a file, table, or other object in Datagrok, open Browse (Sidebar > Browse ()). In the Browse tree, find your object and double-click it to open.
To learn more about data access options, see the Access section of our documentation.
Save and share a table
When you import a table in Datagrok, your changes to it aren't saved automatically. Everything stays in your browser's memory. If you close or refresh the browser tab, any unsaved work will be lost. Click SAVE button on top to upload it to the server. A project containing this table will be automatically created.
Uploading the project object doesn't automatically share it with others. You must share it explicitly.
Saving a dashboard
When you open a CSV file or run a function that produces a table, it opens a Table View resembling Excel. Here, you can edit both the data (the table) and its visual representation (the layout).
Tables and layouts are separate entities. This means you can choose to save changes made to the data, layout, or both.
To save:
- At the top of your screen, click the SAVE button top open the Save project dialog.
- In the dialog:
- For new entities: Enter a name and, optionally, a description for your project. By default, mew entities are saved to your personal project under My stuff.
- For existing (modified) entities: Remove any tables you don't want to save. By default, all open tables are included. Select one of the following:
- Save original project: Updates the original project.
- Save a copy: Useful when you want to edit the project, but don't have the privilege to modify the original one. If you choose this option, you must also decide what happens to each table included in your new project:
- Clone: Creates a copy of the table in your new project.
- Move: Moves the table to the new project, leaving a read-only linked copy in the original project. The linked copy updates with changes made to the table in the new project.
- Link: Creates a read-only linked copy of the original table in your project. Changes to the table in the original project are automatically reflected in the linked table in your project.
- Personal view customizations: Saves personalized layout changes visible to you only, without changing the layout seen by others.
- Optional:
- To update the data every time you open a project, toggle Data sync. This feature is commonly used to create dynamic dashboards or when tables link to different projects.
- To save your project in a presentation mode, toggle Presentation mode. Useful for sharing with data consumers. Toolboxes, status bars, menus, ribbons, context panels will not be shown, letting users focus on the data and visualizations you have created.
- Click OK to save. The SAVE button in the Table View turns grey, indicating you have no unsaved changes.
Moving tables between projects impacts their hierarchy, name, and privileges. Learn more.
Dynamic data
Whenever a table is generated by a function (such as a database query), this information is stored together with the table as its "generation script". This serves several purposes:
- Provides data lineage
- Lets you refresh data on demand
- Lets you publish dynamic dashboards
When you upload a table with a generation script, you can activate the Data sync option. This saves the table as a generation script instead of a static snapshot. Enabling data sync means that the function behind the table will automatically re-execute each time the project is opened. Additionally, you can refresh the table manually or change the query parameters as needed (Toolbox > Source).
Share
You can share Datagrok entities with other users or groups. When you share an entity, you grant a privilege (typically, view or edit) to others. To learn how to manage groups and privileges, see Access control.
To share an entity, right-click to open the context menu and click "Share...". You can also do that from the Context Panel.
You can send the entity's URL to your colleague. To access an entity via a URL, the recipient needs appropriate permissions.
To share an entity using context actions:
- Right-click to open the context menu and click "Share...".
- In the dialog:
- In the identity/email field, start typing the name, username, email, or group name and select the appropriate match.
- Assign access privileges. You can select any
or all of the following options:
- Can view: Can view, open, and download.
- Can edit: Can rename, edit, delete, and share the entity with others.
- Optional. Add description. Decide if you want to notify users by email or
through the Datagrok interface:
- To notify via email, when entering the user identity, use emails instead of user/group names. The email notification will include a link to the shared entity and the description provided.
- To notify via Datagrok, enter a user or group name. The recipients will receive an in-app notification.
- To skip notification, clear the Send notification checkbox.
- Click OK to share. The shared item appears in the recipient's Browse view.
You can share an entity with an email address that doesn't yet have a Datagrok account. In such cases, Datagrok creates a non-active user account. To access the shared entity, the recipient will need to register and activate their account using the specified email address.
Download
Tables and visualizations
You can download any open table as a file or a set of files. To do this, use the Download () icon located at the top of the screen.
Supported download formats
- CSV
- Excel documents (.xlsx)
- JSON
- PNG
- PowerPoint presentations (.pptx)
- Parquet
- Feather
- Fasta
- SDF (for tables containing molecules)
When downloading a table in the CSV format, you can configure the CSV file before downloading it. To do this, select the As CSV (options)... command from the Download menu. This opens the Save as CSV dialog, where you can specify the desired configuration. If you want to use these settings by default in the future, click the SET DEFAULT button.
When downloading tables in a CSV format, only the current table is downloaded.
To download all open tables at once, you have two options:
- Create a zip archive with separate CVS files. To do this, select the **CSV and PNG as ZIP commands. This generates a zip file that includes CSV files for each open table, along with "screenshots" that capture the current visual state of all viewers, including the grid.
- Save open tables as individual worksheets in an XLSX file. To do this, select the As Excel Document command. This creates a separate worksheet within the Excel file for each open table.
To download just the screenshots of all viewers and tables, select the As Presentation command. This generates a PowerPoint presentation with individual screenshots that you can resize or delete as needed.
In Datagrok, the underlying data (tables) and their visual representations (layout) are distinct entities. You can download a layout for any open table.
To download a layout, in the Top Menu, select View > Layouts > Download for your current table. You can then apply this layout to any other table using drag and drop.
Files
To download a file, go to Sidebar > Browse. In the Browse tree, right-click the file and select the download option from its Context Menu.
Add to favorites
To add an entity to favorites, do any of the following:
- Drag-and-drop in the Browse tree:
- Drag and drop the entity on the Favorites directory under My stuff.
- Click the Favorites directory under My stuff. This opens the Favorites view. Drag and drop the entity on the view.
- Use the Context Panel
- In the Browse tree, click the entity you want. The Context Panel shows entity-specific information and actions.
- On the Context Panel next to the entity's name, click the Add to favorites () icon. The color of the icon changes to orange, and the entity is added to your favorites.
You can later access favorites either from the Browse tree or by clicking the Favorites () icon:
- On the Sidebar, or
- On top of the Context Panel.
To remove an entity from favorites, use the context menu. Alternatively, on the Context Panel next to the entity's name, click the orange Add to favorites () icon. The color changes to neutral, and the entity is removed from your favorites.
You can favorite any Datagrok entity like a data connection, query, or a project. You can't favorite an individual file or a specific value within a cell.