PapiralPapiralPixelForgePixelForgeTabularTabular
TabularTabular
HomeCSV ToolsFind & Replace

Find and Replace in CSV

Find any text in your CSV and replace it across an entire column or the whole file — bulk editing made easy.

Pro feature

Upgrade to Pro to use the Find & Replace tool and process files up to 50 MB.

See Pro plans

What this tool does

Bulk find-and-replace across thousands of rows is painful in a spreadsheet editor. Tabular lets you specify exactly what to find, what to replace it with, and which columns to target. Options for case sensitivity and whole-cell matching give you precise control over what gets changed.

Problems it solves

  • Renaming a value that appears in hundreds of rows
  • Standardizing country names like 'US' to 'United States'
  • Removing a prefix or suffix from cells in bulk
  • Replacing null placeholders like 'N/A' or '-' with empty strings
  • Correcting a systematic typo across a column

Example

Replaced 'US' with 'United States' in the Country column.

Before

NameCountry
AliceUS
BobUS
CarolUK

After

NameCountry
AliceUnited States
BobUnited States
CarolUK

Frequently asked questions

Does find & replace support partial matches?

Yes. By default it replaces any occurrence of the search text within a cell. Toggle 'Match whole cell only' to only replace cells whose entire value matches.

Can I target specific columns?

Yes. Leave the column selector empty to search all columns, or select one or more specific columns to restrict the replacement.

Is the search case-sensitive?

By default, no. Enable case-sensitive mode to distinguish between uppercase and lowercase.

Is this a Pro feature?

Yes. Find & Replace is available on Pro and Business plans.

Related guide

How to Find and Replace Text in a CSV File

3 methods — browser tool, Excel, and Python

Related tools

Trim Whitespace

Strip leading and trailing spaces from every cell in your CSV or spreadsheet with one click.

Open tool

Normalize Casing

Pro

Convert text in your CSV to UPPERCASE, lowercase, or Title Case — across all cells or specific columns.

Open tool

Filter Rows

Pro

Keep only the rows that match your criteria — filter by column value, text match, or emptiness. No formulas needed.

Open tool