What this tool does
The Text Processor performs bulk text operations across one or more text fields in your Airtable table. Use it to clean data, standardize formatting, fix capitalization, or add consistent prefixes and suffixes across thousands of records at once.Settings reference
Source
Operations
Find and replace
Search for a string and replace it with another across all selected fields.
Example: Find
Acme Corp, replace with Acme Corporation to standardize company names across a table.
Case conversion
Change the capitalization of text in selected fields.
Example: Convert a “Status” field to Title Case so all entries like
approved, PENDING, in review become Approved, Pending, In Review.
Trim and normalize
Clean up whitespace issues in text fields.Prepend / Append
Add text before or after existing values.
Example: Add
https:// as a prefix to a URL field where URLs were stored without the protocol.
Field scope
The All text fields option automatically discovers all text-type fields (Single Line Text, Multiline Text, Rich Text, URL, Email, Phone Number) in the table and processes all of them. Use Selected fields when you want to limit the operation to specific columns.Preview
The Text Processor has a preview panel that shows how the transformation would affect a sample of your records. Review the preview before running.Common questions
Does the tool skip records that don't change?
Does the tool skip records that don't change?
Yes. The tool only writes back to Airtable for records where the transformation actually changed the value. Unchanged records are not updated.
Can I use regex in Find and Replace?
Can I use regex in Find and Replace?
Yes. Toggle Use regular expression on and enter a valid regex pattern in the Find field.
Can I run multiple operations in one pass?
Can I run multiple operations in one pass?
No. Each run executes one operation type. Run the tool multiple times for multiple transformations.