Data & CSV
Find & replace in CSV cells
Replace literal text inside selected cells while keeping the table structure.
A clear answer. Here’s how.
Replaces every literal occurrence within selected cell contents, without treating search or replacement as code or regex syntax. Can apply across all columns or a chosen column. Headings are preserved. Search text cannot be empty; matching does not normalise accents or Unicode equivalents.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- Your CSV data
ID,Name,Department,Amount,Date 001,Ada,Design,120,2026-01-05 002,Sam,Writing,80,2026-01-06 003,Jo,Design,150,2026-01-07 004,Lee,Writing,,2026-01-08 005,Alex,Design,60,2026-01-09
- Column separator
- Comma
- Apply to
- All columns
- Text to find
- Design
- Replace with
- Creative
- Case matching
- Case sensitive
Example result
| ID | Name | Department | Amount | Date |
|---|---|---|---|---|
| 001 | Ada | Creative | 120 | 2026-01-05 |
| 002 | Sam | Writing | 80 | 2026-01-06 |
| 003 | Jo | Creative | 150 | 2026-01-07 |
| 004 | Lee | Writing | 2026-01-08 | |
| 005 | Alex | Creative | 60 | 2026-01-09 |