---
title: "Enter a table manually in Strata | Oplema"
description: "Type a small table into Strata with Manual Input for lookup values or test data. Edit a live example, add rows and columns and see blank cells become NULL."
url: "https://oplema.com/docs/strata/io/manual-input"
updated: "2026-11-04"
---

# Manual Input

Type a table into a grid of column names and rows. Use it for examples, tests, lookup values or other small datasets; blank cells become NULL.

**Learn this in context:** [Label rows from a small lookup table](https://oplema.com/learn/many-sources/label-rows-from-a-lookup-table) (Combine and reconcile data files)

## Create a small table

Manual Input holds three delivery options. Edit the Data grid and watch the output preview change.

Result
| code | label | amount |
| --- | --- | --- |
| 001 | Standard | 12.5 |
| 002 | Express | 20 |
| 003 | Collection |  |

1. Change `Standard` to `Economy` in the `label` column and look for the updated value in the output.
2. Enter `0` in the empty `amount` cell for Collection. Compare that value with the missing value shown before the edit.
3. Right-click a cell and choose Add row below, then fill in the new row. You can also hover near a row edge and select the + control to add a row.
4. Right-click a cell and choose Add column right, then give the new column a name. You can also hover near a column edge and select the + control.

## When to use

Use Manual Input for small tables you can type: lookup lists, test data or a few values to try a flow with. For anything larger, or data that changes elsewhere, load it with Input.

## Read the output

Manual Input creates one output table from the **Data** grid. Column headings become the output column names, and each grid row becomes a row in the table. In this example, `code`, `label` and `amount` each contain three values.

Manual Input infers column types automatically, using the same detection as Auto Field. The code `001` keeps its leading zeros, and the amount `12.50` becomes a number you can sum. Typing a formula doesn't calculate anything.

## Read blank cells correctly

The Collection row ends with a blank `amount` cell. Its output is **NULL**, meaning no value is present. That is different from `0`, which is an entered value. A completely blank row still gives a row of NULL values. It isn't removed automatically.

## Shape the grid

Edit column headings to name your data. Right-click a cell to insert or delete rows and columns. To add one directly from the grid, hover near a row or column edge and select the **+** control that appears. At least one column must remain. Removing all rows leaves an empty table that keeps its column headings.

The grid's contents are saved with the block configuration.

For data from a file or an external service, use [Input](https://oplema.com/docs/strata/io/input).

## Inputs and outputs

### Inputs

0 ports

No input ports

This block has no incoming connection.

### Outputs

1 port

**Out**

The table entered in Data, with its column names and rows. Column types are inferred as in Auto Field; blank cells become NULL.

## Configure the block

**Clean whitespace**

Trim leading and trailing whitespace before type inference. When off, text retains whitespace, including whitespace-only cells. Empty strings always become NULL.

Default: `true`

**Data**

Manually entered table. Blank cells become NULL.

Default grid · 2 columns, 2 rows
| Column1 | Column2 |
| --- | --- |
| Blank | Blank |
| Blank | Blank |

## Manual Input FAQs

**Does Manual Input need an input connection?**

No. Manual Input is a source block. It creates a table from the Data grid without an incoming connection.

**Does Manual Input convert numbers and dates automatically?**

Yes. Manual Input uses the same type inference as Auto Field. Columns whose non-NULL values all match a supported type are converted automatically. Integer-like codes with leading zeros stay as text.

**What happens to blank cells?**

Empty cells become NULL, a missing value. Typing 0 gives the number 0, which isn't the same as leaving the cell empty.

**How do I add or remove rows and columns?**

Right-click a cell to add a row above or below, add a column to the left or right or delete its row or column. You can also hover near row or column edges and select the + control to insert one. At least one column must remain. Edit a column heading to rename it.

**Where is manually entered data saved?**

The Data grid is stored in the block configuration as part of the project. It doesn't require a separate file or connector. Changes you make in this example stay in the example.

### Prepare your data. Build it in Strata.

Strata opens in your browser, with no account.

[Open Strata](https://oplema.com/editor?path=%2F%3Fopen%3Dstrata) [About Strata](https://oplema.com/strata)
