Add a New Column to a CSV or Excel File Online
Insert a custom column with comma-separated values into any dataset. No Excel required — works with CSV, TSV, and Excel files.
How to Add Column
A complete guide to configuring your data pipeline.
Step 1: Naming the New Column
Open the Add Column tool. In the Column Name field, enter the header for the new column you are inserting (e.g., Status, Batch_ID, or Flag).
Step 2: Providing the Values
In the Values field, enter a comma-separated list of values to populate the new column. For example: Active, Inactive, Active, Pending. The values are assigned row by row from top to bottom.
If you provide fewer values than rows, the remaining cells are automatically filled with empty values (NaN). If you provide more values than rows, the operation is rejected to prevent data misalignment.
Step 3: Verifying the Result
The new column is appended as the last column in the table. Use the Select Columns tool afterward if you need to reorder it to a specific position.
Technical Specifications & Use Cases
Manually injecting a new column is a common need when annotating datasets — adding a cohort label, a batch identifier, a manual quality flag, or a static constant that was not present in the original export.
flowingTable inserts the new column by direct DataFrame assignment, padding shorter value lists with numpy.nan to maintain rectangular table geometry. The values are stored as an object-type series by default, preserving mixed types (strings and numbers) exactly as entered. This prevents the silent type coercion that occurs when pasting a new column into Excel, which can convert leading-zero identifiers like 007 into the integer 7.
Frequently Asked Questions
Can I add a column whose values are calculated by a formula rather than a static comma-separated list?
For formula-based column generation — for example, creating a 'Total' column that multiplies two existing columns — use the Create Column (Mutate) tool instead of the Add Column tool. The Add Column tool is designed specifically for injecting externally defined values that do not exist anywhere in the current dataset, such as a manually typed list of cohort labels or a batch identifier sequence. For any computed value that can be derived from existing columns using arithmetic or string functions, the Mutate tool is the correct instrument.
What happens if I provide fewer values than the number of rows in my dataset?
If the comma-separated list you provide contains fewer entries than there are data rows in the table, the engine automatically pads the remaining cells with NaN (empty values) to maintain the rectangular geometry of the DataFrame. For example, if your file has 1,000 rows and you provide 10 values, the first 10 rows receive your specified values and rows 11 through 1,000 receive empty cells. This behavior allows you to annotate a partial subset of records — for example, flagging the first batch of a dataset — without needing to manually pad the list to the full row count.
How do I place the new column at a specific position in the table instead of at the end?
The Add Column tool always appends the new column as the last (rightmost) column in the table. To move it to a specific position after insertion, use the Select Columns tool immediately afterward. In the Columns input field, list all column references in the exact order you want them to appear in the output — placing your new column name in the desired position within the list. The engine will reconstruct the DataFrame with columns arranged in that sequence, effectively allowing you to insert the new column anywhere without modifying the original data.
Will numeric values I enter in the values list be automatically converted to integers or floats?
No. All values entered through the Add Column interface are stored as an object-type (string) series by default to preserve your data exactly as typed. This prevents silent type coercion — a common issue in Excel where entering '007' in a cell automatically converts it to the integer 7, stripping the leading zeros. If you need the new column to be recognized as a numeric type for subsequent formula or filter operations, you can use the Create Column (Mutate) tool with the expression float($N) or int($N) to explicitly cast the new column's values after insertion.