Developer tools

CSV find and replace

Replace text in every row of a CSV file, in all columns or only the ones you pick. Use plain text or a regular expression, and see each changed cell before you save. It runs in your browser.

Processed in your browser

1. Add CSV

Choose a UTF-8 file or paste CSV. It is read as soon as you add it.

Preparing tool…

Auto-detect tries comma, semicolon, tab and pipe. Choose explicitly if the columns look wrong.

2. Find and replace

Replacement is always literal text: $1 and $& are not capture substitutions.

Comma-separated positions starting at 1. Duplicate header names are fine; select by position. Missing cells stay missing.

Changes clear the result. Replace always starts from your original input.

How to find and replace in a CSV file

  1. Add your CSV

    Choose a UTF-8 file or paste CSV. Check the delimiter and the First row is a header box.

  2. Set up the replacement

    Type Find and Replace with, pick Literal text or Regular expression, and list column numbers or leave the box blank for all.

  3. Review and save

    Select Replace, check the changed cells, then select Copy CSV or Download CSV.

Example: replace a status value in one column

Load example fills a CSV with the columns Name, Status and Note, sets Find to old, Replace with to active and Column numbers to 2, and runs it. Match case is off, so both old and OLD in the Status column become active: 2 cells change. The Note column is not touched, so its quoted comma, its line break and the leading zeros in 0012 stay as they were.

Replacement rules

Every non-overlapping match in each selected cell is replaced, left to right. Matching never crosses cells. Leading and trailing spaces in Find and Replace with are significant. Case is ignored unless Match case is selected, using Unicode simple case folding: É matches é, but ß does not match SS. A cell counts as changed only when its resulting value differs; the match count includes every match in the selected cells.

Regex mode accepts a JavaScript Unicode pattern without surrounding slashes. Global matching is always on; case-insensitive matching is optional. Multiline and dot-all flags are off: ^ and $ match only at the start and end of a cell, and . does not match a line break; use [\s\S] for any character. Unicode mode rejects unnecessary escapes such as \-. Zero-width matches are supported. Replacement text is literal in both modes, with no capture-group or backslash expansion.

Frequently asked questions

How do I replace a value in one CSV column only?

Type the column number in Column numbers, where 1 is the first column. With First row is a header enabled, the tool lists each header with its column number after reading the CSV. For several columns, separate the numbers with commas, such as 1,3. Leave the box blank to replace in every column.

Can I use a regular expression?

Yes. Choose Regular expression in Match type and type a JavaScript pattern without the surrounding slashes, such as \d+ for any run of digits. Replace with is always plain text, so $1 is written as $1 and capture groups are not inserted. A pattern that is not valid shows an error under Find.

Will other fields change?

Unmatched values, row order and row widths are preserved. With First row is a header enabled, header cells are untouched. Downloads quote every field, use CRLF record separators and omit an initial UTF-8 BOM. Line breaks inside file fields are preserved; pasted text and find/replacement text follow the browser’s newline normalization.

Can I remove text or match an empty cell?

Leave Replace with empty to delete matches. Find must contain text or a pattern. To fill empty cells, use regex ^$ with your replacement; absent cells in short rows remain absent. $1 in replacement text stays $1.

What if a regex takes too long?

Regex matching runs in your browser. Cancel stops processing, keeps your input and options, and reads the CSV again. Reset clears everything. No fixed file, row or processing-time limit is imposed; input, parsed records and output must fit browser memory.

Are my files uploaded or saved?

No. The tool processes files in your browser and does not upload or persist them. Copy writes to the clipboard when chosen; download saves when chosen. Choose another file or paste new input to replace it.