Add Row Numbers to CSV
Add an auto-incremented ID or row number column to your CSV or Excel file. Set the column name, starting value, and position.
What this tool does
Many workflows require a unique identifier on every row — for database imports, mail merges, or simply as a row reference. Tabular adds a clean sequential number column to your file in seconds, with full control over the column name, starting number, and whether it appears at the beginning or end.
Problems it solves
- Adding a primary key column before importing to a database
- Numbering rows for reference in a review process
- Adding an order index before shuffling or sorting rows
- Creating unique IDs for records that don't have one
- Numbering survey responses before analysis
Example
An 'id' column starting at 1 added to the beginning.
Before
| Name | |
| Alice | alice@example.com |
| Bob | bob@example.com |
After
| id | Name | |
| 1 | Alice | alice@example.com |
| 2 | Bob | bob@example.com |
Frequently asked questions
Can I choose the column name?
Yes. The default is 'id' but you can use any name — 'row', '#', 'index', or anything else.
Can the numbering start at 0 or another number?
Yes. Set the starting number to any value — 0, 1, 100, or whatever your system requires.
Is this free?
Yes. Adding row numbers is available on the free plan.
Where is the column inserted?
By default at the beginning of the file. You can also place it at the end.
Related tools
Sort Rows
Sort your CSV or Excel file by any column — alphabetically or numerically, ascending or descending.
Reorder Columns
ProChoose which columns to keep and in what order. Drop unwanted fields and reorder the rest before your import.
Remove Duplicates
ProInstantly remove duplicate rows from any CSV or spreadsheet. Keep your data clean and analysis-ready.
Papiral
Tabular