Insert CSV columns
Add new columns to CSV data at specified positions.
Insert CSV Columns
This tool allows you to insert new columns into CSV data at specified positions. You can prepend, append, or insert columns at custom positions based on header names or column numbers.
Insert CSV columns Examples
Click to try!
Insert a single column by position
In this example, we insert a single column "city" at position 1 in the CSV data. The input CSV has data about cars, including the "Brand" and "Model" of the car. We now add a "city" column at position 1. To do this, we enter the city data in the comma-separated format in the "New Column" option, and to quickly add the new column at position 1, then we specify the position number.
CSV to insert
Enter one or more columns you want to insert into the CSV. the character used to delimit columns has to be the same with the one in the CSV input file. Ps: Blank lines will be ignored
CSV Options
Enter the character used to delimit columns in the CSV input file.
Enter the quote character used to quote the CSV input fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Fill With Customs Values
If the input CSV file is incomplete (missing values), then add empty fields or custom symbols to records to make a well-formed CSV?
Use this custom value to fill in missing fields. (Works only with "Custom Values" mode above.)
Position Options
Custom position
Specify where to insert the columns in the CSV file.
Position
Select the method to insert the columns in the CSV file.
Number of the column you want to insert columns after.
Append Multiple columns by header Name
In this example, we append two data columns to the end of CSV data. The input CSV has data about cars, including the "Brand" and "Model" of the car. We now add two more columns at the end: "Year" and "Price". To do this, we enter these two data columns in the comma-separated format in the "New Column" option, and to quickly add the new columns to the end of the CSV, then we specify the name of the header they should be put after.
CSV to insert
Enter one or more columns you want to insert into the CSV. the character used to delimit columns has to be the same with the one in the CSV input file. Ps: Blank lines will be ignored
CSV Options
Enter the character used to delimit columns in the CSV input file.
Enter the quote character used to quote the CSV input fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Fill With Empty Values
If the input CSV file is incomplete (missing values), then add empty fields or custom symbols to records to make a well-formed CSV?
Position Options
Custom position
Specify where to insert the columns in the CSV file.
Header name
Select the method to insert the columns in the CSV file.
Header of the column you want to insert columns after.
Append Multiple columns
In this example, we append two data columns to the end of CSV data. The input CSV has data about cars, including the "Brand" and "Model" of the car. We now add two more columns at the end: "Year" and "Price". To do this, we enter these two data columns in the comma-separated format in the "New Column" option, and to quickly add the new columns to the end of the CSV, then we select append.
CSV to insert
Enter one or more columns you want to insert into the CSV. the character used to delimit columns has to be the same with the one in the CSV input file. Ps: Blank lines will be ignored
CSV Options
Enter the character used to delimit columns in the CSV input file.
Enter the quote character used to quote the CSV input fields.
Enter the character indicating the start of a comment line. Lines starting with this symbol will be skipped.
Fill With Empty Values
If the input CSV file is incomplete (missing values), then add empty fields or custom symbols to records to make a well-formed CSV?
Position Options
Append columns
Specify where to insert the columns in the CSV file.
Related tools
- All tools
- CSV Tools
- Convert CSV to JSONConvert CSV data to JSON format.
- Convert CSV to XMLConvert CSV data to XML format.
- Convert CSV Rows to ColumnsConvert CSV rows to columns.
- Convert CSV to TSVConvert CSV data to TSV format.
- Swap CSV ColumnsReorder CSV columns.
- Convert CSV to YAMLQuickly convert a CSV file to a YAML file.
- Change CSV SeparatorChange CSV file delimiter
- Find incomplete CSV recordsQuickly find rows and columns in CSV that are missing values.
- Transpose CSVQuickly transpose a CSV file.
- TSV to JSONConvert TSV to JSON format