Add Serial Numbers Online

Add a numbered column to your list with custom start, step, prefix and suffix.

100% private. Everything runs in your browser. Your data never leaves your device.

Add Serial Numbers

Your values (one per line)

Start at

Step

Prefix

Suffix

Separate number and value with a tab (for pasting into Excel)

What does this tool do?

This tool adds a serial number (row number) to every line in your list, with a custom starting number, step, and optional prefix and suffix. A quick alternative to Excel fill series. Runs in your browser.

How to use Add Serial Numbers - Free Online Tool

Paste your values, or click "Try with sample data".
Set the start number, step, and optional prefix/suffix.
Click Add Numbers.
Copy or download the numbered list.

Example

Numbering a list:

Before

Item

Apple

Banana

After

No	Item
1	Apple
2	Banana

A serial column is added before each value.

Excel formula alternative

Prefer a formula? You can achieve a similar result with ROW / fill series:

=ROW()-1

Excel uses ROW() or fill handle. This tool adds prefixes, suffixes, and custom steps too.

When should I use this tool?

Numbering lists and rows

Creating invoice or SKU sequences

Adding IDs with a prefix

Preparing ordered data

Generating reference numbers

Indexing survey responses

Frequently Asked Questions

Yes, set any start value and step size.

Yes, add a prefix and/or suffix to each number.

No, it runs in your browser.

Yes, the number is added alongside each value.

Related tools

Add Prefix / Suffix

Combine Columns

Sort Data

Split Text (Text to Columns)

Excel Formula Generator

Related Tools

Compare Excel Files Excel Formula Generator Merge Excel Workbooks Trim, Clean & Convert Case Remove Duplicates Compare Two Excel Columns Excel ↔ JSON Converter Excel ↔ XML Converter EMI Calculator Age Calculator Excel ↔ CSV Converter Split Excel Sheets Remove Blank Rows/Columns Format Data Income & Expense Tracker Find Duplicates Split Text (Text to Columns) Extract Email Addresses Extract Numbers from Text Word & Character Counter Change Text Case Find & Replace Text Combine Columns Remove Special Characters Add Prefix / Suffix Reverse Text Convert Text to Numbers Split Full Names Remove Extra Spaces Extract URLs Extract Text Between Characters Transpose Data Sort Data Delete / Keep Columns CSV Viewer CSV to JSON JSON to CSV CSV to SQL CSV to Markdown Table Markdown Table to CSV Excel / CSV to HTML Table Count Unique Values Data Profiler & Health Check Percentage Calculator Percentage Change Calculator Profit Margin Calculator CAGR Calculator Discount Calculator GST Calculator