Append TSV Column
Add a column at the end of the file, named, with an optional constant value on every row. Appending is the safest structural change you can make to a delimited file: every existing column keeps its position, so anything reading by position still works, and readers that address by name pick up the new column automatically.
How to use
- Paste or drop the file.
- Name the new column — it becomes the last header.
- Set the fill value, or leave it blank.
- Copy or download.
What a constant column is good for
Provenance — tag each file before merging so you can still tell the rows apart afterwards. Flags and defaults — astatus = pending or version = 2 column that a loader requires. Placeholders — an empty column with the right name, so a strict schema check passes and you can fill it in later with fill empty cells or the grid editor.
As an argument to another tool — this is the underrated one. Adding a constant column gives combine columns something to build a prefix or suffix from, and gives group and aggregate a way to aggregate the whole file (group by the constant).
FAQ
Can the value be different per row?
No — this writes one constant. For computed values, combine columns derives a new column from existing ones, and join brings values in from another file.
What happens on ragged rows?
Short rows are padded to the header width before the new column is added, so the result is rectangular. If you wanted to know about the raggedness first, check with the validator.
Is appending safer than inserting?
Yes, for anything that reads by position — an appended column can't shift existing fields. Insert column deliberately does shift them.
What's the awk equivalent?
awk -F'\t' -v OFS='\t' 'NR==1{print $0,"status"; next} {print $0,"pending"}' f.tsv — the NR==1 special case for the header is the part people forget.
Privacy
100% client-side. No upload. See the privacy policy.