Simple online tools for developers, networking, text and conversions.

Text Tools

Insert a CSV Column

Insert a new CSV column at a chosen 1-based position.

Tool

Use this tool to insert a new column into CSV data at a specific position. It is useful when imports, reports, or workflows require a new field in the middle of an existing CSV structure.

About this tool

Use this tool to insert a new column into CSV data at a specific position. It is useful when imports, reports, or workflows require a new field in the middle of an existing CSV structure.

Use insert a csv column when you need a fast browser-based result without extra setup. It works well for quick checks, one-off tasks, and routine formatting or calculation work.

Learn more

Why use this tool

How to use

  1. Put the 1-based insert position on line one
  2. Put the new column header on line two
  3. Put one value per CSV row after that
  4. Leave a blank line
  5. Paste the CSV below and run the tool

Examples

Example

Input

2
email
john@example.com
anna@example.com

name,role
John,admin
Anna,editor

Output

name,email,role
John,john@example.com,admin
Anna,anna@example.com,editor

Useful when a required field must appear in a specific position.

Example

Input

3
region
EU
US

id,title,status
1,Book,ok
2,Pen,ok

Output

id,title,region,status
1,Book,EU,ok
2,Pen,US,ok

Adds a new field into the middle instead of only first or last.

Common errors

Using index 0 instead of 1

Fix: This tool uses 1-based column positions.

The values count does not match the CSV row count

Fix: Provide one new value for each CSV data row.

Using a position outside the valid range

Fix: Use a position from 1 to header length plus 1.

FAQ

What does Insert a CSV Column do?

It adds a new column at a chosen 1-based position in the CSV.

Can I insert at the beginning or end?

Yes. Position 1 inserts first, and the last valid position inserts at the end.

Do I need one value per row?

Yes. The number of values should match the number of CSV data rows.

What if the position is invalid?

The tool returns an error so you can fix the input.

How is it different from Prepend or Append?

Insert lets you choose the exact position instead of only first or last.

Use cases

Related tools