About the CSV Column Adder
Sometimes a CSV file needs one more column before it can be imported: a running ID, a constant such as a country or a status, or a blank field that a system expects. This tool inserts that column for you. Paste your CSV, choose where the new column goes, name it and decide how to fill it: either with numbers that count up from a starting value, or with the same text in every row. It detects comma, semicolon, tab and pipe separators and keeps quoted values intact. Your data stays in the browser and is never uploaded.
Updated October 2026
How to use the CSV Column Adder
- 1Paste your CSV into the box on the left.
- 2Type the position for the new column; 1 puts it at the front, and the word last adds it at the end.
- 3Give the column a name for the header row, or untick the header option if your file has none.
- 4Choose to fill it with counting numbers or with the same text in every row.
- 5Copy the result or download it as a CSV file.
When you need an extra CSV column
Import tools are strict about columns. A shop platform may want an ID in the first column, a mailing service may want a status column, and a database loader may expect a fixed number of fields on each line. Adding the column by hand in a spreadsheet works for twenty rows but not for twenty thousand, and opening a large file in a spreadsheet can also change dates or drop leading zeros.
Doing the job on the text avoids those side effects. The tool reads the rows, inserts the new field and writes the file back out, so everything else stays exactly as it was.
Choosing the position and the fill
Position 1 is the front of the row, 2 is after the first column, and so on. A position bigger than the number of columns, or the word last, puts the new column at the end. Use numbers as the fill for IDs, serial numbers and sort keys. Use the same text for labels, such as the source of the data or the month it belongs to.
If you need a different value on each row, fill the column here with numbers or a placeholder, then join the real values with another tool or in your spreadsheet.
- Front of the file: position 1
- After the first column: position 2
- End of the row: type last
Phone and computer
On a phone, paste into the box, adjust the three or four options, then copy the result with one tap. On a computer you can also download the file. Check the first few rows of the output before you import it into another system, especially if your file uses quotes around values with commas. If you only need to look at one column of the file first, CSV Column Extractor pulls it out cleanly. For a whole-file view, CSV Tools has the other common edits, and CSV to JSON Converter turns the finished table into data an app can read.
Features
- Insert at any position or at the end
- Fill with 1, 2, 3 numbers from any start value
- Fill with the same text in every row
- Works with comma, semicolon, tab and pipe files
- Keeps quoted values with commas intact
- Private: nothing is uploaded
Frequently asked questions
How do I add a column to a CSV file?
Paste the CSV, type the position and name of the new column, choose how to fill it and copy the result. For example, position 1 with the name id and numbers turns a two-column list into a three-column list that starts with 1, 2, 3.
Can I add an ID or row number column?
Yes. Choose numbers as the fill and set the first number. With 1 as the start, the rows get 1, 2, 3 and so on; with 1001 as the start they get 1001, 1002 and 1003. The header row, if you have one, gets the column name you typed.
How do I add a column with the same value in every row?
Choose the same text option and type the text to repeat, for example United Kingdom or active. Every data row receives it, and the header row receives the column name.
What if my CSV has no header row?
Untick the option that says the first row holds column names. Then every line is treated as data, the new column is filled in every line, and no name is written.
Does it work with semicolon or tab separated files?
Yes. The separator is detected from the first lines, and the result is written with the same separator, so a European file with semicolons stays a semicolon file.
Is my CSV uploaded anywhere?
No. The column is added by code running in your browser tab, and the data never leaves your device. That makes it safe for customer lists and exports you would not want to send to a website.