Fill a column with AI

Run a prompt down a column and get plain values back, with placeholders, progress and Stop.

Fill column is the right tool for anything beyond a few rows: it writes values, not formulas, so the sheet stays fast and nothing is ever recalculated or re-billed.

Fill column tab

Settings

Field Meaning
Sheet Which tab to work on
Input col The column with the text to work from, e.g. B
Output col Where answers go, e.g. C. Existing values are kept when Skip rows that already have an answer is on.
First / last row Row range; last row defaults to the last row with data
Prompt What to do with each row

Placeholders

If the prompt contains no placeholder, the input is appended automatically.

Running

Click Fill column. Rows are processed in batches of ten with a progress bar; Stop finishes the current batch and keeps what was written. Run again later with Skip rows that already have an answer ticked to do only new rows.

Free plan: up to 50 rows per run. Pro: 1,000.

Tips