Papiral
PixelForge
Tabular
TabularAdd a Column to a CSV File
Insert a new column into any CSV or spreadsheet file, with a default value for every row.
What this tool does
Sometimes you need to add a constant column before importing into a database, or a flag column before processing in a pipeline. Tabular's Add Column tool inserts a new column at the start or end of your file and fills every row with the value you specify — or leaves it blank. No formulas, no manual editing.
Problems it solves
- Adding a 'source' or 'imported_from' column before a database import
- Inserting a blank column to fill in manually after export
- Prepending a sequence or batch identifier column
- Adding a 'status' column defaulted to 'pending' for workflow tracking
- Creating a template column before populating with a formula in Excel
Example
A 'Source' column added at the end with default value 'import'.
Before
| Name | |
| Alice | alice@example.com |
| Bob | bob@example.com |
After
| Name | Source | |
| Alice | alice@example.com | import |
| Bob | bob@example.com | import |
Frequently asked questions
Can I add the column at the beginning of the file?
Yes. Choose 'Start (first column)' in the position dropdown to prepend the new column.
Can the default value be empty?
Yes. Leave the default value field blank and every cell in the new column will be an empty string.
Is this free?
Yes. Add Column is available on the free plan for files up to 5 MB.
Can I add multiple columns at once?
Add multiple Add Column operations in the operations list — each one inserts another column.
Related tools
Rename Columns
ProRename any column header in your CSV or XLSX file. Map old names to new ones before importing to another system.
Reorder Columns
ProChoose which columns to keep and in what order. Drop unwanted fields and reorder the rest before your import.
Merge Columns
Combine two or more columns into a single column with a separator. Great for building full names, addresses, or IDs.