# Data Table

The Metadata Table panel shows the data that was uploaded as a spreadsheet (usually CSV) either at initial upload or during addition of more data tables using the add panel tool.

See [Metadata Data](/instructions/creating-a-microreact-project/metadata-column-types.md) for data source guidance.

The look of the Data Table can be formatted and sorted, and the table can be used to select (highlight) data on other panels or filter data on other panels.

## Formatting table

### Show/hide column in table

**To hide a column**, you can either click on the <img src="/files/G3MiSLRhTzMzmVWVWNm1" alt="" data-size="original"> icon ![](/files/SD4rLQdSyOfBnVX2SFKh) or uncheck the column in the Columns configuration menu (lozenge)<img src="/files/MZLUEfFpec0AhkUnBbcM" alt="" data-size="original">

**To show a column**, the Columns lozenge and re-check the column's checkbox.

![](/files/-MZYBCuNy-sEUns_draw)

### Set column width in table

The <img src="/files/Hs1Cc1F2KGFfs5Y9v2UB" alt="" data-size="original"> width icon will **automatically set the width of the column** to fit the contents. For columns with a lot of text this will expand the column enabling all the data to be viewed, and for columns with short headers and values, this will shrink the column.

### Renaming columns

See [Renaming columns](/instructions/creating-a-microreact-project/metadata-column-types.md#renaming-columns)

### Reorder columns

Column order can be manually changed. Hover over the left side of the column name, and when the hand icon appears, click and drag the column right or left to the desired location.

<figure><img src="/files/dhamT40klH2Fxb6Vfl4Y" alt=""><figcaption><p>Reorder columns</p></figcaption></figure>

### Set row density in table

The density of the rows can be altered by clicking on the density lozenge <img src="/files/-MZYBXAwyd8PlLOD4B4t" alt="" data-size="original"> which brings up the following dialog

![](/files/-MZYBlxyBIpG48EvG537)

### Sort table by selected column

The <img src="/files/IC2rZkZQX9G4T8G6uxqO" alt="" data-size="original"> AZ button **sorts rows in ascending order**

The <img src="/files/aCU62ig2hqyQ4yrRZQvL" alt="" data-size="original"> ZA button **sorts rows in descending order**

## Selecting data

To select (highlight) data across other panels by using the data table, click in the checkboxes on the left side of a row.

## Filtering data

Any column in the data can be used to filter the data visualised on all panels. To filter by a column, hover over the column name in the metadata table header, and click on the <img src="/files/-MZExfD5pqzwudLAWJGD" alt="" data-size="original"> filter icon. This will bring up a dialog box with options for filtering the data, depending on what kind of field the column is.

{% hint style="warning" %}
**Always** click on the **APPLY FILTER** button to apply the filtering conditions to the column
{% endhint %}

### Filter by condition

Conditions are dependent on the type of column. Choose the condition and the value to apply as the filter.

<figure><img src="/files/GIYMoMKa7sZORokkFGrC" alt=""><figcaption></figcaption></figure>

### Filter by value

To filter the column by selecting one or more specific values from the dataset, click on **filter by values**

* **Search** for specific text (or scroll)
* **Select** those values you want to include

![](https://lh4.googleusercontent.com/Ww07RjQcZ0XM5DISJSB3ZQ1qdUdkv5D6RmlXx6JJP8iJohnsr2QUJCUfoU7PO3Cxtvii3o3eWtCVAwwoOwbMK7bbdZ3XLwf9VaNIVI_yxZLxVqHEVKIECuN3eCGCIia8lYTZbkUMi5QTdH7qlE0tDEChY4C7KZPNbP_xyzgbyTNlALOrzTPkAhwCdI9W)

### Filter using a list

Users can also search metadata with a comma-separated list.

Navigate to your metadata table to the column of data you would like to filter or search on. Choose “Text in comma-separated values” as your filter by condition.

\
Type or copy/paste your comma-separated values into the filter criteria. Use the Reset Filter in the search bar to clear the filter.

![](https://lh7-rt.googleusercontent.com/docsz/AD_4nXd5-AdVIV2-ZRaO6A1pzfJdbnZyp0cQPIEEXwPEFYcu8l4INdabxRkF8yrThcBl00utY4qGoyHwaMnhg9ceIg7s8gpt-ZkuBwEsYFCnpdRR7zOqqGxh4ctU-ia3E72wEgAm6bOE6JIOVmmeif5e4wMR8Zt5?key=eWiUFSXUJbPgi8wi6uipZA)

\\


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.microreact.org/instructions/adding-and-editing-panels/data-table-panel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
