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

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.

Or paste it

Reading the file Separator First row is a header Trim spaces around values

Find and replace Find Replace with

Where Columns Change the header row too

Matching Ignore capitals when finding Only the first match in each value Trim the value before matching

Writing the result Separator Quote every field Windows line endings, for Excel Add a byte order mark, so Excel reads accents

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 Search and Replace in a CSV

A few steps, and nothing is uploaded.

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

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.

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.

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.

What to Know About Replacing in a CSV

Why doing it in a text editor goes wrong.

Doing this in a text editor is what you are avoiding. In the raw file, commas separate fields and quotes protect values, so replacing a comma or a quote changes the structure rather than the data. Replacing here happens inside each value after the file has been parsed, so the separators and quoting are rebuilt correctly afterwards.

Limiting the change to chosen columns is the main reason to use this. Replacing "open" everywhere might be right in a status column and completely wrong in a notes column that says "open the gate". A text editor has no idea which column it is in; this does.

The header row is left alone unless you ask. Renaming a column by accident while cleaning its values is an easy mistake to make and a confusing one to find later, so it needs the switch.

Whole value and part of a value are different jobs. Clearing a placeholder such as N/A should match the whole value, otherwise a genuine note containing those letters gets damaged. Adding a country to a city name is a part match. Picking the wrong one is the usual cause of a replacement that looks almost right.

Regular expressions are available and unforgiving. Capture groups can be used in the replacement as $1, $2 and so on. An invalid pattern is reported rather than silently matching nothing. If you only need plain text, the other modes need no escaping at all.

Replacing nothing is possible and usually a mistake. If the counter says zero cells changed, check the capitals switch and whether the match mode is whole value when it should be part, since those are the two usual causes.

Key Features & Capabilities

What this tool does, and what it deliberately does not.

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 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

Columns, whole values, patterns and the header row.

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.