# Input Tables
URL: https://docs.valsight.ai/input-tables/
Description: Enter values directly into a table on the worksheet and see the effect on your scenario without leaving the sheet.
An input table brings simulating and viewing together: values are typed straight into a table on the worksheet and the effect shows up immediately, with no switching between screens.

## What it is

An input table looks like an ordinary table, but it has an **Input Data** mode. In that mode the cells accept typed values, and saving them applies the change across your scenario.

![An input table showing editable values per region, engine type and year](./images/5937365006.png)

Each input table edits one line-item, in one of two views:

| View            | What you type                                      |
| --------------- | -------------------------------------------------- |
| **Change View** | Relative changes, for example a percentage uplift. |
| **Result View** | Absolute values, which replace what is there.      |

## When to use it

* You want a reader to try their own numbers without opening the Scenario Manager.
* You want to enter many values at once, which is faster in a grid than with sliders.
* You want to set a total that other tiles then divide up, for example one feeding a [split slider](/split-sliders/).

Use a **[slider](/sliders/)** instead for a single value that is better dragged than typed, and a plain **table** when readers should only read the numbers.

## Configuration

1. Click **+ Chart** in the workspace.
2. Go to the **Simulations** category and select **Input Table**.

   ![The Simulations category with Input Table in the chart type selection](./images/5937463312.png)
3. Choose the **Line Item** to edit, and the **variant** to modify.

   ![The input table configuration, with the line-item and variant selected](./images/5936676877.png)
4. Edit the **Table title** if you want something other than the proposed one.
5. Choose **Change View** or **Result View**.

   ![An input table in Result View, showing absolute values](./images/5936676883.png)
6. Optionally apply **filters** to narrow the table to the rows that matter. A filter icon appears when you hover over a filtered table.

### Entering values

1. Hover over the input table tile and click **Input Data** in the top right corner.
2. Type values into the cells to test an assumption.

   ![Typing a value into an input table cell](./images/5937463306.png)
3. Click **Save** to apply the change across the scenario. Every linked table updates automatically.

## Good to know

* **What you type depends on the view.** In **Change View** a `10` is a relative change; in **Result View** the same `10` is an absolute value. Check which view a table uses before entering numbers.
* **Nothing is applied until you save.** Values typed in **Input Data** mode take effect on the scenario only when you click **Save**.
* **A table can be maximized while you work.** Expanding it for easier entry does not lose what you have typed.
* **Perspective and sheet filters apply.** They adjust the data shown in the table automatically, so the rows you see may depend on the sheet's current perspective.

![An input table maximized on the worksheet](./images/5937365000.png)

## Related

* [Sliders](/sliders/): drag a single line-item's value instead of typing it.
* [Split Sliders](/split-sliders/): redistribute a total across its parts while the total stays fixed.
* [Chart Types](/chart-types/): the other tiles you can place on a worksheet.