Free Online CSV Search and Replace, By Column
Search and replace inside the values of a CSV rather than in the raw text, so the commas, quotes and structure of the file are never touched. Limit the change to chosen columns, match whole values or part of one, use a regular expression if you need it, and see how many cells will change before you download.
| Nothing to show yet. |
| Nothing to show yet. |
Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.
How to Use Bulk CSV Search and Replace
Step by step, start to finish.
One or many. The same replacement is applied to each, with columns matched by name.
Leaving the replacement empty deletes the matched text, which is how you clear a placeholder such as N/A.
Name the columns by heading, by letter or as a range. This is the part a text editor cannot do and the reason a value in one column stays safe while another changes.
The samples under the options show actual before and after pairs from your file. The counters say how many cells will change.
Key Features
What this tool does, and what it does not do.
The file structure, its separators and its quoting are rebuilt afterwards and never damaged.
Name them by heading, by letter or as a range, or exclude a few and change the rest.
Before and after pairs taken from your own file, with a count of how many cells will change.
Regular expressions with capture groups in the replacement, and a clear error when a pattern is invalid.
The same replacement across every file, downloaded together as a single zip.
Customer records are edited inside this tab and never sent anywhere.
About Bulk CSV Search and Replace
Everybody reaches for a text editor first, and for a one off change in a small file that is fine. It stops being fine the moment the thing you are replacing could also appear somewhere it should not. The word "open" in a status column is a status; in a notes column it is an ordinary English word, and a plain find and replace treats them identically.
The worse version of the problem is structural. A CSV uses commas to separate fields and quotes to protect values that contain commas. Replace a comma in a text editor and you have added or removed a field. Replace a quote and you have either broken the protection or started a quoted value that never ends, which swallows the rest of the file. Neither produces an error; both produce a file that loads wrongly.
Working on parsed values avoids all of it. The file is read properly first, the replacement happens inside the cells, and the file is written back out with correct separators and quoting. That also makes column targeting possible, which is the feature people actually want and the one no text editor can offer.
Frequently Asked Questions
Common questions about this tool.