Text Tools
Replace one selected CSV column with a new header and new values.
Use this tool to replace one CSV column by header name or 1-based column number. It is useful for fixing bad data, swapping out outdated fields, and rebuilding a column without editing every row manually.
Use this tool to replace one CSV column by header name or 1-based column number. It is useful for fixing bad data, swapping out outdated fields, and rebuilding a column without editing every row manually.
Use replace 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.
Read step-by-step usage guidance, best practices, and common mistakes.
See common questions and answers about input, output, and tool usage.
Review practical input and output examples before running the tool.
Find similar and supporting tools for adjacent actions and follow-up tasks.
Input
email username john anna name,email,role John,john@example.com,admin Anna,anna@example.com,editor
Output
name,username,role John,john,admin Anna,anna,editor
Useful when replacing a whole field instead of deleting and inserting separately.
Input
2 status active pending id,title,role 1,Book,admin 2,Pen,editor
Output
id,status,role 1,active,admin 2,pending,editor
Supports both header-based and index-based column selection.
Fix: Check the CSV header or use a valid 1-based column number.
Fix: Provide one replacement value for each CSV data row.
Fix: Put selector, new header, and values first, then a blank line, then the CSV.
It replaces one selected column with a new header and new values.
Yes. You can use either the exact header name or a 1-based column number.
Yes. The number of replacement values should match the number of CSV data rows.
No. It only replaces the selected column.
Replace does both operations in one step and keeps the same column position.