Skip to main content


Grid is a viewer for tabular data. Think Excel on steroids.


Certain features and functionalities described in this article are part of the PowerGrid package. For a complete experience, we recommend installation.



Select all rowsCtrl+A
Select rowsShift+Mouse Drag
Deselect rowsCtrl+Shift+Mouse Drag
Select columns and rowsMouse Drag rows
Select columnsShift+drag column headers
Select columnsCtrl+click column headers
Deselect columnsCtrl+Shift+click column headers
Invert column selectionCtrl+click
(De)select rows(Ctrl+) Shift + ↑↓
(De)select columns(Ctrl+) Shift + ←→
(De)select rows(Ctrl+) Shift + mouse-drag
(De)Select rows with the current value(Ctrl+) Shift + ENTER
Select rows above currentCtrl + Shift + Home
Select rows below currentCtrl + Shift + End


NavigateUp, Down, Left, Right
NavigatePage Up, Page Down
Jump to first rowCtrl+Home
Jump to last rowCtrl+End
Jump to first columnHome
Jump to last columnEnd
Prev / next selected rowCtrl + ↑↓
Show in full screenAlt+F


Sort a columnDouble-click column header


Edit cellDouble-click
Copy cell valueCtrl+C
Paste into cellCtrl+V
Add a row (requires Allow Edit set to true)Enter or click the plus (+) icon in the bottom row
Delete selected rows and/or columnsShift+Del

Resize and reorder

Reorder columnsDrag the column header.
Selected columns are repositioned simultaneously next to each other
Resize columnsDrag the right border of the column header.
Selected columns are resized simultaneously
Resize row heightDrag the border of the row header

Column properties


Rows and columns

You can access available options for rows, columns, and cells in a number of ways:

  • From an object's context menu (right-click to open)
  • From the Top Menu options and icons
  • For the current object, from the Context Panel
  • For columns, by clicking the Hamburger (≡) icon (hover over the column's header to display)

From there, you can change the cell format, color code a column, pin rows, and do more. For shortcuts, see Controls.


Grid rows have different states:

  • Selected (highlighted in orange)
  • MouseOver (on hover, highlighted in light blue)
  • Current (click or navigate using the up (↑) and down (↓) keys, highlighted in green).
  • Filtered

These states are synchronized with other viewers, making it easy to explore your data. For example, moving between rows in the grid updates both the current molecule on a scatterplot and similar molecules in the similarity viewer. The same works in reverse. Clicking a molecule on a scatterplot or a similarity viewer updates the current row in all other viewers, including grid.

To further aid with data exploration, the Context Panel dynamically updates to show info panes specific to the current molecule.


Unlike Excel, cells within a grid column are assigned one of the predefined data types: string, int, bigint, qnum, double, datetime, or bool. Additionally, a column may have tags, a semantic type (e.g., Molecule), and an entity type, which lets you annotate specific data points with custom metadata.

To edit column settings, either right-click the column's header to access its context menu or click the column's header to display available options in the Context Panel.

Subject to permissions, you can:

  • Change the column's properties (e.g., it's data type or cell renderer)
  • Customize the column's appearance or behavior (e.g., change the cell's format, color-code values, pin rows, etc.)
  • Specify who can edit a column. Users without edit permissions will receive a notification when attempting to edit a restricted column.
Column properties
New nameNew column name
VisibleAllows to hide column
Is Color CodedEnable/Disable column color coding
Show ValueAllows to do not show values on color coded column
WidthColumn width, in pixels
Background ColorBackground Color, 32 bit integer
Decimal PlacesDecimal Places
Custom NameCustom name, original will be saved
Column NameColumn Name
Custom FormatCustom Format
Cell TypeCell Type

For quick navigation, preview, or batch actions, use the Column Manager. To open, on the Status Bar, click Columns:


You can customize the display of cell data using cell renderers. Grid cells can also contain values from multiple columns or linked tables, and display embedded images.

Cell renderers

Cell renderers customize how cell data is shown. For instance, molecules in SMILES notation may be rendered in 2D. For specific semantic types, such as molecules or URL images, cell renderers are applied automatically.

To apply a cell renderer manually:

  1. Right click the column header and select Column properties.... A dialog opens.
  2. In the dialog, set the tag key to cell.renderer and the tag value to the desired cell renderer name (e.g., Tags).

Note: Some cell renderers may require additional parameters.

  1. Click OK.

Examples of built-in renderers include molecules, URL based images, fit lines, comboboxes, and more.

Summary columns

Summary columns show data from multiple columns within a row. To simply display data from multiple columns, use smart forms. To visualize numerical data, use sparklines. To design a custom form, use forms.

Smart forms show values from multiple columns within a single cell. They inherit color-coding and cell renderers from the source columns, and their content dynamically adjusts to fit the cell size.

To add a smart form, right-click a cell and select Add > Summary Columns > Smart Form. To change selected columns for the summary column, click its header and choose the columns you want in the Context Panel under Renderer.

smart forms

Data from linked tables

You can display data from one linked table within another. For example, you may want to show order details alongside customer orders.

Here's how:

  1. Link the tables.
  2. Right click any cell, select Add > Linked Tables, and choose the table you want. A column with data from the linked table is added to your dataset.

Linked table data in cell


Datagrok supports two types of images in cells: embedded and linked. Supported formats are .jpg, .png, and .jpeg.

To embed an image, double click a cell and select the source file.

For linked images, Datagrok automatically detects and visualizes images saved as URLs (those starting with "http://" or "https://", and ending with one of the supported image formats) using a cell renderer.


If images are not detected automatically, right-click the column header and select Column Properties. This opens a dialog. In the dialog, under Tags, set the following parameters:

  • quality to ImageUrl
  • cell.renderer to ImageUrl.

Working with data

Subject to permissions, you can add, delete, or modify records in your dataset. In addition, the Top Menu provides multiple options for data cleaning and transformation. For example, you can add calculated columns, impute missing values, delete duplicates, and more.

To learn more about data transformation, visit the Transform section of our documentation.

In addition to actions directly on your table's data, you can augment your dataset with additional information. You have these options:

  • Use built in tools from the Top Menu. For example, for molecules, you can add a column with descriptors via Top Menu > Chem > Calculate > Descriptors...

  • Add columns using info panes

    How to add

    You can add the content of most info panes as a column.

    To add the entire info pane, click the Add new column (...) icon next to the info pane's name. To add a specific calculation or object within an info pane, click the plus (+) icon next to the object or calculation you want to add.


To toggle filters, in the Top Menu, click the filter icon.

The Filters Panel is a viewer. Learn more about filters.

How To

Format cells

To change a cell's format:

  1. Right-click the column's header and select Format. Alternatively, right-click a cell and select Current column > Format.
  2. Select the format you want from the options provided or set a custom format by choosing the Custom... option.



Add rows and columns

To add a new row, either click the plus (+) icon after the bottom row in your dataset. Alternatively, go to the Top Menu and select Edit > Add rows... This opens a dialog where you can specify the number of rows to add, as well as their position relative to your current row.

To add a new column:

  1. In the Top Menu, click the Add New Column... icon. This opens a dialog.
  2. In the dialog, specify the column's name and data type and click OK.
  3. An empty column is added to the dataset.
  4. Optional. To specify a column's semantic type, tags, or cell renderer, use the column's properties.

Learn how to add calculated columns.

Pin rows and columns

You can pin rows and columns from the context menu. Pinned rows can be saved in projects and as layouts, using the column's name and cell value (for unique rows only).

To pin:

  1. Select rows or columns you want to pin.
  2. Right-click your selection and choose the relevant option from the Pin menu. Your selection is now pinned.

To unpin rows, select the Unpin option from the Pin context menu.

Pinned rows

Color code columns

You can color code columns with these schemes:

  • For categorical columns (string and bool data types), "categorical"
  • For numeric columns, "conditional" or "linear"
  • For datetime columns, "linear"

To color-code a column, right click its header and select the desired scheme from the Color Coding submenu. This applies color to the column's background. To customize color-coding settings, click the column's header and adjust them in the Context Panel under Colors.

To copy color coding from one column to others, use the Pick Up Coloring and Apply Coloring commands from the column's Color Coding menu. These commands copy both standard and custom color-coding, including the Off setting which removes color coding. Note that you can't transfer settings between numeric and categorical columns. The Apply Coloring command remains inactive if no color coding has been picked up. These settings are retained for a viewer instance but are not saved through layout serialization.

Show, hide, or reorder columns

To show, hide, or reorder columns:

  1. Right-click any cell and select Order or Hide Columns.... A dialog opens
  2. In the dialog:
    • To hide a column, clear a checkbox next to the column's name. To show a column, select the corresponding checkbox.
    • To reorder columns, drag column names or use the arrow controls


See also: