About the CSV Column Replacer
A normal find and replace changes every match in a file, including the ones in columns you wanted to leave alone. This tool limits the change to one column. Paste your CSV, say which column to work on by number or header name, type what to find and what to put instead, and the matching cells in that column are rewritten. Options let you match the whole cell or part of it, ignore capital letters, or use a regular expression for patterns. The header row can be left unchanged. It runs in your browser, and the note tells you how many cells changed.
Updated October 2026
How to use the CSV Column Replacer
- 1Paste your CSV into the box.
- 2Enter the column by number or by header name.
- 3Type the text to find and the text to put in its place.
- 4Choose whole-cell matching, ignoring capitals or regular expressions if you need them.
- 5Check how many cells changed, then copy or download the CSV.
Targeted find and replace
Cleaning a CSV often means standardising one field: country names, status words, product codes or currencies. Replacing across the whole file risks damaging other fields. Working column by column is safer, and the count of changed cells lets you notice if the result looks wrong, for example zero changes because of a spelling mismatch.
Use whole-cell matching for codes and labels. Use part-of-cell matching for prefixes, suffixes and stray characters.
Using regular expressions
A regular expression describes a pattern instead of fixed text. Typing ^0+ matches zeros at the start of a cell, \s+$ matches spaces at the end, and [0-9]+ matches a run of digits. Test your pattern on a few rows first. If you only need plain words, leave the option off, because special characters such as the dot and the plus sign mean something in patterns.
- Leading zeros: ^0+
- Trailing spaces: \s+$
- Digits: [0-9]+
Safe habits
Keep the original file. Run the replacement, scan the output, and compare the number of changed cells with what you expect. If you need several different replacements, run them one after another, using the output of one as the input of the next.
Examples that save time
Change every UK in a country column to United Kingdom before an import. Replace the word pending with active in a status column. Remove a currency symbol from an amount column by replacing it with nothing. Turn Y and N into Yes and No for a report.
If the Replace box is left empty, the matching text is deleted, which is useful for stripping prefixes and suffixes from codes. Before you replace values, tidy stray gaps in the text with Remove Extra Spaces so that matches are exact. CSV Column Extractor shows you a single column to check, and CSV Tools covers sorting, filtering and other edits on the same file.
Features
- Changes one column only
- Whole-cell or part-of-cell matching
- Optional case-insensitive search
- Optional regular expressions
- Header row can be left alone
- Counts the cells that changed
Frequently asked questions
How do I replace values in only one CSV column?
Paste the CSV, enter the column, type the text to find and the replacement. Only that column is searched. If the column is country and you replace UK with United Kingdom, a name containing the letters UK in another column is not touched.
What does matching the whole cell mean?
With it on, a cell changes only if its entire content equals the text to find. With it off, the text is replaced wherever it appears inside the cell, so replacing cat with dog also changes concatenate.
Can I ignore capital letters?
Yes. Tick the option to ignore capitals, and UK, uk and Uk will all be found.
Can I use a regular expression?
Yes. Tick the option and the Find box is read as a pattern. For example the pattern ^0+ removes leading zeros from every cell in the chosen column. If the pattern is invalid, the tool shows an error instead of changing anything.
Will the header row be changed?
Not when the header option is ticked. The first row is passed through exactly as it is, which keeps column names intact.
Is the data uploaded?
No. The replacement is done in your browser, and the CSV is never sent anywhere.