Add Column to CSV

How the column is added

Enter a column name in the name field and a value in the default value field. The tool appends the new column to the right side of every row, including the header row. Every data row gets the same default value. The output is a CSV with one additional column at the end, and all existing columns and values are unchanged.

The new column is always appended at the end rather than inserted at a specific position. If you need the column at a different position, export the file from this tool, then use the CSV Column Extractor to select columns in your preferred order, which produces a reordered output.

Adding metadata columns before import

Many import processes require a status column, a source tag, or a batch identifier that is not present in the original export. Rather than opening a spreadsheet and manually filling a column, set the column name and default value here and download the augmented file. The entire operation takes a few seconds regardless of how many rows the file contains.

Adding a country code column to a flat export before sending it to a country-segmented import tool is a common case. If you export a list of contacts from a global CRM and need to import them into a regional system that requires a "country" column, add the column here with the appropriate country code, then import.

A source tag column records where a dataset originated, which is useful when later merging it with records from other sources. Adding a "source" column with a value like "salesforce_export_2024_q1" before merging makes it straightforward to trace any row back to its original file after the merge is done.

Frequently asked questions