CSV Column Adder

Append a constant column to a table.

Use this tool

Input CSV format
Output CSV format

Parsed table

Result

The result appears in this panel after you run the tool.

About this tool

The input is parsed into cells, the column is added to that table, and the result is written again from those cells. Output delimiter Same as input keeps the delimiter that was used to read the file. Choosing semicolon rewrites every separator, including the ones that were already there.

When Header row is on, the first row receives the header name and every later row receives the value. When it is off, the header name is hidden and every row receives the value.

The value is text. It is not a formula.

How to use it

  1. Paste a table or open a file. The parsed table updates when you change the input format.
  2. Set the value, and the header name when the first row contains column names.
  3. Choose the output delimiter, then use Add column. Copy, download, or continue with the serialized CSV.

Limitations

One new cell at the end of every row

The same value is appended, unless the first row is a header

The input dialect splits the table. A new cell is added at the end of each row. When the input header control is on, the first row receives the header name you typed, and every later row receives the value you typed. When that control is off, every row, including the first, receives the value. The header name is then unused. The value is a constant. It is not a formula, not a copy of another column, and not a running count. Each data row gets the same characters.

The output dialect writes the wider table. If the new value contains the output separator or a line break, the writer quotes it. Existing cells are quoted according to the same rules. A spaces separator on output becomes a comma. The new column is always last. There is no control to insert it at an index. To place it elsewhere, add it and then reorder.

Header mismatch is a real footgun

If the source had a header row but the header control is off, the first data row of the file receives the constant value instead of a name, and the real header row is treated as data. The columns no longer line up with their titles. Turn the header control on when the file’s first row is names. The renamer, unlike this page, refuses to operate when the header control is off. The adder will still run, and it will do the less useful of the two behaviors.

What is not filled in

Blank value means an empty cell on each data row, which is a column of empties, not a deleted column. You cannot ask the adder to pull a value from the row beside it. Use it to stamp a literal, such as a source label, onto every record. The original cells stay. Nothing is dropped except the previous file’s exact bytes, which are reprinted in the output dialect.

Privacy

Your input is processed in your browser and is not uploaded to UtilChain. File names, text, and results are not sent to analytics.