CSV Find and Replace by Column
Set rules that apply to one column or to all of them. Replace part of a value, a whole value, the start or end, or use a pattern. The count shows what each rule changed.
Drag a file here or choose one
Worked examples
Standardise a spelling
Name,Country Ann,U.K. Bob,uk Cara,UK
Name,Country Ann,UK Bob,UK Cara,UK
Two rules on Country: the whole cell U.K. becomes UK, and uk becomes UK. Capitals are ignored, so the second rule changes Bob's row; Cara's was already right.
Fill blanks
Name,Status Ann,active Bob,
Name,Status Ann,active Bob,unknown
Rule: the whole cell, nothing to find, replace with unknown.
About CSV Find and Replace by Column
Ordinary find and replace changes every match everywhere, which is wrong when one column holds codes and another holds names. Here every rule is limited to the column you choose, or applied to all columns, and you can set up to four rules that run one after another. The count beside each rule shows how many cells it changed.
The kind of match matters. Anywhere in the cell replaces part of a value. The whole cell replaces only cells that hold exactly your text, ignoring spaces at the ends, which is how you turn N/A into a blank or UK and U.K. into a single spelling. Start and end match only at those places, and a pattern accepts a regular expression with $1 style references to groups you capture. A whole cell rule with nothing to find replaces blank cells.
How to use CSV Find and Replace by Column
- Paste your CSV or open a file.
- For each rule, choose the column, type what to find and what to put in its place.
- Choose how to match: part of the cell, the whole cell, the start, the end or a pattern, and whether capital letters matter.
- Check the counts and the preview, then download the result.
Common uses
- Standardising country names or status values
- Turning N/A and similar placeholders into blank cells
- Filling blank cells with a default value
- Removing a prefix or a suffix from a code column
Frequently asked questions
How do I fill blank cells with a value?
Choose The whole cell, leave Find empty and type the value in Replace with. Every blank cell in the chosen column gets that value.
Are the rules applied in order?
Yes, rule 1 first. A later rule sees the result of an earlier one, so you can chain changes.
How do patterns work?
Choose A pattern and type a regular expression to find. In the replacement, $1 stands for the first captured group, $2 for the second. For example ^(\w)(\w+)$ with $2$1 moves the first letter to the end.
Does it match capital letters?
Only if you tick Match capital letters for that rule. By default uk matches UK.
Is the header row changed?
No. Rules apply to the data rows. Use the column extractor to rename columns.