SEQUENCE

SEQUENCE creates a spilled range of consecutive numbers arranged in the specified number of rows and columns, starting at a given value and incrementing by a set step. It is widely used to build numbered lists, date series, and helper arrays for other dynamic array formulas.

Excel

=SEQUENCE(5,1,1,1)

Google Sheets

=SEQUENCE(5,1,1,1)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1Decide how many rows and columns you need, the starting value, and the increment step.
2Enter =SEQUENCE(rows, [columns], [start], [step]) in an empty cell.
3The array spills automatically — combine with other functions like DATE or TEXT for date sequences.

Need a version for your data?

Try: “Create a numbered list from 1 to 10 in a single column.”

SORTBY FLATTEN

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

SEQUENCE

Try it with your data

How it works

Related