CleanCSV

Find and Replace in CSV and Excel Files

Run several replace rules at once, target one column or all of them, use regular expressions and fill empty cells with a default value.

Free, no sign-upFiles never leave your deviceCSV, Excel & JSON

CSV & Excel cleaning workspace

No account. No uploads. Just clean data.

100% in your browser
1

Upload your file

Drop your CSV or Excel file here

or browse your device. You can select several files at once.

CSV, TSV, TXT, XLSX, XLS, ODS and JSON · up to 50.0 MB and 250,000 rows

Your files never leave your device.

Step by step

How to use this tool

  1. 1

    Drop your CSV or Excel file into the tool above.

  2. 2

    Type what to find and what to replace it with in the first rule. Leave the replacement empty to delete the text.

  3. 3

    Choose a column or keep All columns, and tick Match case, Whole cell only or Regular expression as needed. Add more rules; they run in order.

  4. 4

    Watch the preview update, then download.

Partial matches or whole cells

By default a rule replaces every occurrence inside a cell, so replacing “St.” with “Street” turns “Main St.” into “Main Street”. Tick Whole cell only when the entire value must match, for example to turn “N/A” and “n/a” into empty cells without touching “N/A” inside a sentence.

Filling blank cells

Leave Find empty, tick Whole cell only and type a replacement such as “Unknown” or “0”. Every empty cell in the chosen column is filled. This helps before importing into tools that reject empty required fields.

Regular expressions

With Regular expression on, Find is a JavaScript regular expression and the replacement can use groups such as $1. For example, find (\d{3})(\d{3})(\d{4}) and replace with ($1) $2-$3 to format 10-digit numbers, or find \s*\(.*?\) with an empty replacement to remove anything in brackets. Invalid patterns are flagged and skipped instead of breaking the file.

Frequently asked questions

Is find and replace case-sensitive?

Not by default. Tick Match case to make a rule case-sensitive.

Can I replace text in just one column?

Yes. Every rule has its own column selector. Choose All columns to apply it everywhere.

Can I undo a replacement?

Yes. Edit or delete the rule and the preview updates immediately. Your original file is never changed.