The table toolbar

Every table in the console carries the same toolbar above its rows. This page maps its controls: the buttons that act on the table, the search, the view settings and the statistics. For the table itself, see Tables overview; for a single cell, Table cells and editing.

How the toolbar is arranged

On a wide screen the toolbar runs from the action buttons on the left, through the search field and the view controls, to the table statistics and the right-side actions.

• Not every table offers every control: the toolbar shows the ones that apply to that table.
• When room runs short, the statistics fold into a small info icon first, and the view controls then gather into one View settings menu.
• On a phone-sized window the toolbar keeps only the search field and the export control; the other buttons and the statistics are hidden.
• In Card view, the controls that shape the table itself (the column menu, Auto-fit columns, the density control and Selection mode) are hidden.

Read the statistics

The toolbar can show a small line of statistics for the table's last load:

• Rows Read: how many rows the load read.
• Bytes Read: how much data it read.
• Time Elapsed: how long it took, for example 0.42s.

A table with nothing to report shows no statistics line. When the toolbar runs short of room, the line folds into a small info icon labelled Table statistics, which carries a dot while a filter or a selection is active.

Arrange the columns

1. Open Toggle column visibility in the toolbar. The panel header reads Columns and counts what shows, for example 8 of 12 visible.
2. Tick a column to show it, and untick it to hide it.
3. Drag a column up or down in the list to change its order; the hint under the list reads Drag to reorder.
4. Click Reset to default to bring back the default columns.

You can also work from the headers: drag a column header to move the column, drag its edge to resize it, or open the menu that appears in a header when the column offers its own actions. The Auto-fit columns button fits every column to its content at once; a second click resets the widths to their defaults.

Search and clear the filters

• Type in the search field to narrow the table to the rows that match your text; how the matching works is on Table filtering, sorting and search. It reads Search... while empty, and a small button labelled Clear search empties it.
• Clear all filters clears every column filter and the search box in one click. The button is greyed out while nothing is active; point at it to see how many filters it will clear, for example Clear all filters (3).

Change the view

Where a table offers a card layout, a Table view / Card view switch sits in the toolbar. How cards are laid out, and what the table remembers, is on Table preferences and drafts. View opens View Preferences, with the table's Density and Text Size settings.

Density sets the spacing between rows. The control steps through four levels:

Text Size sets the size of the table's text: Small (12px), Medium (14px) or Large (16px).

Filter visibility sets when the small filter icons appear on column headers: Always visible, When active or hovered or Hidden.

When the toolbar gathers its buttons into one View settings menu, it carries Auto-fit columns and the density, filter visibility, selection mode and column choices in one place.

Set the selection mode

Selection mode opens a menu with two sections.

• Row Selection chooses how rows are selected: Checkbox (select rows with checkboxes), Drag (click or drag rows to select them), Both (checkbox and drag), or None (row selection is off).
• Cell Selection switches Enable Cell Selection on or off. With it on, you select cells the way you do in a spreadsheet: click a cell, drag across a range. Cell selection works instead of row selection: you use one or the other.

The menu lists only the choices the table allows, and a table that offers nothing to configure shows no Selection mode button. How to select, and what a selection can do, is on Tables overview.

Compare rows from the toolbar

Stack selected rows as comparison cards opens the side-by-side comparison for the rows your selection touches. The cards, the ticking and the Replace cycle are described on Compare rows.

Refresh, remove and save rows

• Refresh data loads the table again; its icon spins while the new rows arrive.
• Remove selected rows removes the rows you selected. It is greyed out until there is a selection; once there is one, the button shows how many rows are selected and turns red. Removing rows clears the selection.
• Two more buttons appear while a table holds unsaved rows: Save N unsaved row(s) and Discard unsaved changes. How unsaved rows work is on Tables overview.

Copy, export and upload

Three controls move data in and out:

• Copy to clipboard puts the table's rows on the clipboard, headers included.
• The export control chooses a file format under a Download header (CSV, Excel, JSON or TSV), and the download button saves the file.
• Upload sends an Excel file to a table that accepts one.

Each of them, with its formats and limits, is on Table export, copy and upload.

Questions, answered

Why are some toolbar controls missing on a narrow window?

The toolbar gives up controls as room runs out: the statistics fold into an icon first, then the view controls gather into one View settings menu, and on a phone-sized window only the search field and the export control stay. Widen the window to bring the rest back.

What do Rows Read, Bytes Read and Time Elapsed mean?

They describe the table's last load: how many rows it read (Rows Read:), how much data it read (Bytes Read:) and how long it took (Time Elapsed:). A table with nothing to report shows no statistics line.

What does the second click on Auto-fit columns do?

It resets every column width to its default. The first click fits each column to its content; the second click undoes that fit.

How do I choose which columns show, and in what order?

Open Toggle column visibility, tick the columns to show, and drag the list to reorder them; Reset to default brings back the default set. You can also drag column headers to reorder the table itself, and drag a header's edge to resize it.

Why isn't a column listed in the Columns menu?

The list holds the columns you can hide and reorder. The checkbox column that carries row selection is not listed, and it always keeps the first position in the table; columns that cannot be hidden or have no header label are left out too.

Why did Clear all filters empty the search box too?

The search counts as a filter, so one click clears the column filters and the search text together. The button is greyed out while nothing is active, and its tooltip counts what will be cleared, for example Clear all filters (3).

How do I turn on Excel-like cell selection?

Open Selection mode and switch on Enable Cell Selection. Cell selection works instead of row selection: you use one or the other; how to select and what a selection can do is on Tables overview.

Why do some toolbar buttons vanish in Card view?

Card view shows rows as cards, so the controls that shape the table layout are hidden there: the column menu, Auto-fit columns, the density control and Selection mode. Switch back to Table view to use them.

Why is Remove selected rows greyed out?

It needs a selection first. Select rows and the button shows how many you picked; clicking it removes those rows and clears the selection.

How do I refresh a table's data?

Use Refresh data in the toolbar; its icon spins while the table loads again.