Text Tools
Replace one selected TSV column with a new header and new values.
Use this tool to replace one TSV 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 TSV 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 tsv 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 TSV header or use a valid 1-based column number.
Fix: Provide one replacement value for each TSV data row.
Fix: Put selector, new header, and values first, then a blank line, then the TSV.
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 TSV data rows.
No. It only replaces the selected column.
Replace does both operations in one step and keeps the same column position.