Delimited Column Replacer

This tool replaces specific columns in delimited text with a fixed replacement value. You can customize both input and output delimiters and choose which column indexes to target. It processes data instantly and updates the output in real time, making it ideal for obfuscating, redacting, or substituting values in tabular data formats like CSV or TSV.

Paste your input above or import a file below.
No file chosen
Supported file type: text/plain (.txt)
Total items: 0
Options

How to Use:

  1. Paste your delimited text into the input box or import a .txt file using the Choose File button.
  2. In the Options section:
    • Set the Input Delimiter used in your file (e.g. ,, |, TAB).
    • Specify the Columns to Replace using zero-based indexes (e.g. 1 or 0,2).
    • Enter the Replacement Value (e.g. REDACTED, *****, null).
    • Choose the Output Delimiter you want for the result.
  3. The output updates live as you make changes.
  4. Use Copy Output to copy the result to your clipboard.
  5. Use Export to File to download the result as a .txt file.
  6. Click Clear All to reset everything.

Example:

Input:

Name,Age,Location
Alice,30,New York
Bob,25,Los Angeles
Charlie,35,Chicago

Columns to Replace:
1
Replacement Value:
REDACTED

Output:

Name,REDACTED,Location
Alice,REDACTED,New York
Bob,REDACTED,Los Angeles
Charlie,REDACTED,Chicago

Common Use Cases:

Use this tool to redact private information like names, locations, or ages in datasets, or to insert placeholders where original values are no longer needed. It’s ideal for cleaning exports before sharing, testing masked data formats, or preparing inputs for scripts that require neutralized values.

Useful Tools & Suggestions:

If you’re replacing columns in delimited data, Delimited Column Deleter can help clean out old or unused ones before making updates. And once the structure’s locked in, Delimited Column Exporter gives you a clean way to pull out exactly what you need from the updated set.

Related Tools