Developer tools
CSV Find Replace
Change the text you need. Keep the other fields intact.
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.
Updated CSV
Scroll within the table to see more columns. With the table focused, use the arrow keys.
Exports preserve formula-like text and leading zeros as field values, including a replacement that starts with = + - or @. Spreadsheet apps may interpret them; import columns as text when needed. CSV quoting and record separators are normalized.
How to update CSV text
- Add your CSV
Choose a UTF-8 file or paste CSV. Check the delimiter and header settings.
- Set up replacement
Enter find and replacement text, choose a match type and optionally select columns.
- Review and save
Replace, inspect the changed cells, then download or copy every record.
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
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.