Number List Generator

How it works

Type the last number of the list in the left box. The start and step default to 1, so typing 100 gives every number from 1 to 100, one per line, which pastes into Excel or Google Sheets as one number per cell. Set the step to 2 for odd numbers (1, 3, 5 …), or start at 0 with a step of 0.5 for 0, 0.5, 1 and so on. On this English page the decimal separator is the point; a comma inside a number such as 1,000 is read as a thousands separator. Pick 'Commas' as the separator for a list like 1, 2, 3 that you can paste into a form or code. If the last number is lower than the start (start 10, last number 1), the list counts down. 'Pad to equal length' writes 001, 002 … 100 so file names and invoice numbers sort correctly. In the prefix box, {n} is replaced by the number: 'Q{n}.' produces Q1., Q2., Q3. Without {n}, the text is simply put in front. The status line shows how many numbers were made, and up to 100,000 can be generated at once.

This tool is also known as number list generator, list of numbers 1 to 100, numbers 1-100 with commas, sequential number generator, generate numbers in a column.

What is Arithmetic sequence?

An arithmetic sequence is a list of numbers in which each term is the previous one plus the same fixed amount, called the common difference or step: 1, 2, 3 … has step 1; 5, 10, 15 … has step 5; 10, 8, 6 … has step −2. The n-th term is start + (n − 1) × step. This tool computes every value directly with that formula instead of adding repeatedly, which is why decimal steps do not accumulate rounding errors.

What is Decimal separator?

The decimal separator is the symbol between the whole part and the fractional part of a number. English-speaking countries mostly use a point (3.5), while much of continental Europe, Turkey and Latin America use a comma (3,5); the Unicode CLDR locale data records this per language. Because the same symbol means 'decimal' in one place and 'thousands' in another, number lists are easy to misread when shared. This page reads and writes the point.

What is the difference between a number list and a random number generator?

A number list writes every number in a range in a fixed pattern, in order and at equal steps: 1, 2, 3 … 100. The same settings always give the same list. A random number generator instead draws unpredictable numbers from the range; every click gives a different result and the numbers come in no particular order. Use the number list for numbering, row columns, table cards and file names, and the random number generator for raffles, prize draws and picking a random sample.

Common uses

Typing a long sequence by hand almost always goes wrong somewhere: a number is skipped or repeated and nobody notices until the end. A generated list contains every number exactly once, and the status line gives the count so you can check it at a glance.

• A row-number column in a spreadsheet: one number per line
• Numbered questions for a quiz or worksheet: prefix 'Q{n}.'
• Table cards for a wedding or event: prefix 'Table {n}'
• File and photo names that sort correctly: 001, 002 …
• Raffle ticket numbers: 0001 to 1000

Why leading zeros matter

File managers and many systems sort names character by character. Compared that way, '10.jpg' comes before '2.jpg' because 1 is smaller than 2, and you get the order 1, 10, 100, 11, 12 … 2, 20. When every number has the same length (001, 002, 010, 100), alphabetical and numerical order match.

The tool picks the width from the largest number in the list: three digits for 1 to 100, four for 1 to 1000. Note that Excel reads a pasted 001 as the number 1; format the column as Text first if the zeros must stay.

Frequently asked questions

How do I get numbers 1 to 100 separated by commas?

Type 100 in the left box and set the separator to 'Commas'. The result is 1, 2, 3 … 100 on a single line, ready to copy.

How do I make a list that counts down?

Set the start number to 100 and type 1 as the last number. Whenever the last number is lower than the start, the list is generated in descending order and the status line says so.

Will a 0.1 step produce values like 0.30000000000000004?

No. Each value is computed as start + position × step and rounded to the number of decimals you typed, so floating-point noise never reaches the list.

How many numbers can I generate?

Up to 100,000 at once. If your settings would produce more, the error message tells you how many and you can split the range or use a bigger step.