Add Rows

Type a few records straight into your table. Values are checked against each column before anything is added.

What it does

Add Rows puts new records at the bottom of your table. You type the values in a small form.

It is useful for the row that the export missed. A late expense claim, a walk-in sale, or a test record all fit.

The form shows one box per column. Each box is labelled with the column name and its type, such as amount (numeric).

Add a record

1. Type add rows in the Search transforms box, in the Pipeline panel.
2. Select Add Rows in the results. A card named Row 1 opens.
3. Fill in the boxes for Row 1. Leave a box empty for an empty cell.
4. Click Add another row for a second record.
5. Click the small cross on a card to remove that card.
6. Click Apply.

Your rows appear at the bottom of the grid. The step joins your pipeline, so you can edit it later.

What to type in each box

The grey hint inside each box tells you the format:

Each value converts to the column type when you apply.

A value that does not fit stops the step and says so, naming the value and the column: "twelve" is not a valid number for "qty". Correct the box and apply again.

This used to be silent. A typed twelve in a number column became an empty cell, the row was added, and the step reported success, so the only way to find out was to spot the blank in the grid.

What an empty box means

An empty box means an empty cell. That is what you want almost always, and it is the default.

There is a second, rarer reading: a piece of text that exists and happens to be empty. The two look identical in the grid, but they behave differently. A missing value is skipped by an average and found by Fill Missing; an empty piece of text is a value like any other.

A box left blank means switches between them. Only a text column can hold an empty piece of text, so a number or date column gets a blank either way.

Good to know

• An empty box makes an empty cell. Fill only the columns you know.
• A date goes in as 2026-03-14. Other layouts are accepted where the database can read them, and refused by name where it cannot.
• A card with every box empty is skipped. Nothing is added for it.
• Do not type commas in numbers. Write 1250.50, not 1,250.50.
• Edit the step later to correct a typo. The Pipeline panel has an edit button on each step.
• New rows arrive last. Click a column header to sort the grid and find them in place.

Adding many rows?

This form suits a handful of records. Twenty rows of typing is slow work.

For bulk data, put the records in a second file. Then append that file with Union All.

For SQL users

One new row on a three-column table runs as:

SELECT "sku", "item", "qty" FROM "inventory"
UNION ALL
SELECT 'SKU-99' AS "sku",
       'Stapler' AS "item",
       CAST('12' AS INTEGER) AS "qty"

The cast is strict, not TRY_CAST. A value the column cannot hold has to fail the step: turning it into a blank is how a row ends up in the table looking nothing like what was typed.

Related Operations

• Join - Join with another file/table
• Unnest - Explode delimited column into rows
• Fill Missing - Fill null values