Skip to content
Learn › Explore your data: open the docs menu

Find, hide and show columns with the Column Browser

Edit access; the button is unavailable in a View-only workspace · Updated 8 Nov 2026

The Column Browser is a floating panel in the data editor for finding, hiding, showing and exploring a View's columns. Open it with the Column Browser button at the left edge of the data grid; its Column Manager renames, retypes, reorders, removes and adds columns. Both need edit access: the button is unavailable in a View-only workspace.

Open the Column Browser

  1. Open a View.
  2. Click the Column Browser button (the column icon) at the left edge of the data grid. You can also click the column count in the status bar below the grid ("12 columns", or "9 of 12 columns" when some are hidden).

The button's tooltip reads "Search and select columns to hide, show, explore, rename, reorder or retype." The panel opens as a floating dropdown with the search box ready.

Hide columns, Show columns, Show only these and Column Manager are also unavailable when:

  • the grid is in edit mode or preview mode (exit it first);
  • the pipeline has a task in error.

What changes affect only this View and what changes the dataset

ChangeWhereScope
Hide or show columnsColumn Browser or Column ManagerThis View only
Open in Explore ColumnsColumn BrowserThis View only
Rename, change type, or remove a source columnColumn ManagerYou choose: this View only, or the entire dataset
Reorder columns, add a column, change columns created by pipeline tasksColumn ManagerThis View only
Add batch infoColumn ManagerDataset: all Views of the dataset are affected
Copy column namesColumn ManagerYour clipboard only

When you save a source-column change in the Column Manager, Mammoth asks Apply changes to… with This view only or Entire dataset. Changes to the entire dataset modify the dataset schema for all Views, and Mammoth warns that they may affect other Views, pipelines and connections that use the columns.

Find and select columns in the Column Browser

The panel has two sides.

  • Left: the column list. At the top are a select-all checkbox, a Bulk select dropdown and a Search columns… box. Each row shows a checkbox, position number, type icon (Text, Numeric or Date, the same icons as the grid headers), column name and an eye button. Hidden columns are dimmed. A pin icon marks frozen columns, and an Explore icon marks columns that already have an Explore Card. The bottom reads "Showing all 12 columns", or "Showing 9 out of 12 columns", plus the number selected.
  • Right: actions. The Actions list (Hide columns, Show columns, Show only these, Open in Explore Columns) and the Column Manager button.

Tick one or more columns to turn the actions on. Type in Search columns… to filter the list; matching text is highlighted, and "No matching columns" shows when nothing matches.

Select columns by type or visibility

Click the arrow beside the select-all checkbox (Bulk select). Each option applies to the columns currently listed, so a search narrows it.

OptionWhat it does
Text, Numeric, Date (under Filter by type)Shows only columns of that type and selects them. Choose the same type again to show all columns
Visible ColumnsSelects the visible columns
Hidden ColumnsSelects the hidden columns
Invert selectionFlips the current selection

Hide or show columns in a View

These actions change only the current View. Hidden columns leave the grid but stay in the dataset.

ActionWhat it doesAvailable when
Hide columnsHides the selected columnsAt least one selected column is visible
Show columnsShows the selected hidden columnsAt least one selected column is hidden
Show only theseHides every column except the selected onesOne or more columns selected

To hide or show one column, click the eye button on its row.

Open several columns as Explore Cards

Open in Explore Columns opens an Explore Card for each selected column. It adds to the cards already open rather than replacing them. It works for any column type, and it also works in edit mode and preview mode. It is unavailable when every selected column already has its card open.

Rename, retype, reorder or remove columns

Click Column Manager in the Column Browser to rename, retype, reorder or remove columns, or add batch info columns. See Rename and retype dataset columns with the Column Manager.

Troubleshooting the Column Browser

SymptomCauseFix
The Column Browser button is unavailableThe workspace is View-onlyAsk for edit access
Hide, show and Column Manager are greyed outThe grid is in edit or preview mode, or a pipeline task is in errorExit the mode, or fix the failing step
Open in Explore Columns is greyed outEvery selected column already has a cardSelect a column without a card
Was this page helpful?

Something wrong? support@mammoth.io