Skip to main content
WizTools123
Free Online Tools

Tool Categories


CSV Tools New Tool

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.

Free Forever Nothing Uploaded Column by column Many files at once
Free Online CSV Search and Replace, By Column
Share this tool
Advertisement Slot (Top Banner) Google AdSense Unit • Responsive Banner
Bulk CSV Search and Replace Your file is read inside this tab. Nothing is uploaded anywhere.
Drop the CSV files you want changed The same replacement is made in every file. Your originals are never touched. Choose files Up to 25 MB per file. Nothing is uploaded.
0%
Or paste it
Reading the file
Find and replace
Where
Matching
Writing the result

0 files 0 cells changed 0 matches replaced - columns searched

Before
Nothing to show yet.
After
Nothing to show yet.
Buy Us A Coffee

Enjoying WizTools123? Help keep our server infrastructure 100% free and open for everyone.

Buy Us A Coffee
Sponsored Content (Below Tool) Google AdSense Placement

How to Use Bulk CSV Search and Replace

Step by step, start to finish.

1
Drop the files in

One or many. The same replacement is applied to each, with columns matched by name.

2
Type what to find and what to put instead

Leaving the replacement empty deletes the matched text, which is how you clear a placeholder such as N/A.

3
Limit it to the right columns

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.

4
Check the preview, then download

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.

Inside values only

The file structure, its separators and its quoting are rebuilt afterwards and never damaged.

Chosen columns

Name them by heading, by letter or as a range, or exclude a few and change the rest.

A real preview

Before and after pairs taken from your own file, with a count of how many cells will change.

Patterns when needed

Regular expressions with capture groups in the replacement, and a clear error when a pattern is invalid.

A folder at a time

The same replacement across every file, downloaded together as a single zip.

Nothing is uploaded

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.

Because in the raw file a comma is a separator and a quote protects a value. Replacing either changes the structure rather than the data, and a text editor cannot tell which column it is working in, so a word that is right to change in one column gets changed in all of them.

Put N/A in the find box, leave the replacement empty, and set the mode to "only when it is the whole value". That protects genuine text that happens to contain those letters.

Yes, with the regular expression mode. Refer to them as $1, $2 and so on in the replacement, exactly as you would elsewhere. An invalid pattern is reported rather than quietly matching nothing.

Not unless you switch that on. Renaming a column by accident while cleaning its values is easy to do and hard to notice afterwards, so it is kept separate.

The capitals switch, and whether the mode is set to whole value when you meant anywhere inside the value. Those two account for almost every case where a replacement appears to do nothing.

Yes. Drop them all in and the same replacement is made in each, with columns matched by name, then downloaded together as a zip.
Advertisement Slot (Bottom Banner) Google AdSense Unit • Responsive Banner