Replace Text in Excel - Search & Replace for Make

PDF4me Replace Text in Excel module enables comprehensive search and replace operations in Excel documents within Make scenarios with optional formatting application. This powerful text manipulation service supports literal text replacement and regular expressions (regex), with case-sensitive matching options, entire cell or partial matching, multiple replacement phrases in single operation, and optional formatting changes (font, color, size, bold, italic, underline, strikethrough, subscript, superscript)—perfect for data standardization, content updates, error correction, automated text transformation, and bulk find-replace operations across all worksheets in cloud storage platforms and business applications.

Authenticating Your API Request

To access the PDF4me Web API through Make, every request must include proper authentication credentials. Authentication ensures secure communication and validates your identity as an authorized user, enabling seamless integration between your Make scenarios and PDF4me's powerful Excel text replacement services.

Get your API Key

Key Features

• Literal & Regex Support: Replace text using simple text matching or powerful regular expressions
• Case-Sensitive Option: Control case sensitivity for precise or flexible matching
• Entire Cell Matching: Match partial text or require entire cell match
• Multiple Replacements: Process multiple search-replace operations in single module
• Optional Formatting: Apply font, color, size, and style changes to replaced text
• All Worksheets Processing: Automatically processes all worksheets in workbook

Parameters

Complete list of parameters for the Replace Text in Excel module. Configure these parameters to control text replacement behavior.

Important: Parameters marked with an asterisk (***) are required and must be provided for the module to function correctly. This module processes all worksheets in the Excel file.

Parameter	Type	Description	Example
File Name***	String	Excel Document Name • Filename with .xlsx or .xls extension • Used for processing and output file identification • Supports dynamic naming from scenario variables • Required for replacement operation	data.xlsx
Document***	Buffer	Excel File Content • Map from previous module (Drive/Dropbox/HTTP) • Binary Excel document for text replacement • Must be valid Excel format • All worksheets will be processed	[Buffer]
Phrases***	Array	List of Replacement Operations • Array of ReplacementPhrase objects with properties: • SearchText* (String) - Text or regex pattern to find • ReplacementText* (String) - Replacement text (empty = delete) • IsExpression (Boolean) - true = regex, false = literal (default: false) • CaseSensitive (Boolean) - true = case-sensitive (default: false) • MatchEntireCell (Boolean) - true = entire cell, false = partial (default: false) • Formatting (Object) - Optional: FontName, FontColor, FontSize, Bold/Italic (Apply/Remove/Inherit), UnderlineType, StrikethroughType, ScriptType (Subscript/Superscript) • Must contain at least one phrase • Processed sequentially in array order • Regex supports capture groups ($1, $2) in replacement	[{"SearchText":"old","ReplacementText":"new"}]

Output

The PDF4me Replace Text in Excel module returns comprehensive output data for seamless Make scenario integration:

Table

Table View

Response data in a structured table format:

Parameter	Type	Description
Name	String	Output Excel filename
Doc Data	Buffer	Excel document with text replaced

JSON

JSON Response Format

The raw JSON response from the module:

{
  "Name": "data.xlsx",
  "Doc Data": "[Buffer Data]"
}

Scenario Integration

Make Scenario Usage

Use Excel with replaced text in subsequent modules:

• Data Standardization: Fix common data entry errors and inconsistencies
• Content Updates: Update product names, codes, or terminology across workbooks
• Error Correction: Fix typos and misspellings in bulk
• Rebranding: Replace old company names with new names across all sheets

Scenario Examples

The PDF4me Replace Text in Excel module in Make provides comprehensive scenario templates designed for real-world text replacement needs:

Data Standardization

Automated Data Entry Error Correction Workflow

Fix common data entry errors across all worksheets automatically:

Complete Scenario Steps:

1. Trigger: Weekly data quality cleanup scheduled every Friday at 6 PM
2. Get Master Data: Retrieve data workbook from Google Drive
3. Build Replacement Array: Create multiple phrase objects for common errors
4. Fix State Abbreviations: SearchText = "California", ReplacementText = "CA"
5. Fix Product Names: SearchText = "Widget Type A", ReplacementText = "Widget-A"
6. Set Case Insensitive: CaseSensitive = false for flexible matching
7. Process All Worksheets: Module automatically processes all sheets
8. Upload Cleaned Data: Save standardized workbook to Google Drive
9. Email Data Team: Send data quality cleanup report
10. Log Corrections: Record replacement count and types in quality log

Business Benefits:

• Standardizes 500+ inconsistent entries weekly automatically
• Multiple replacements in single operation improves efficiency
• Processes all worksheets ensuring complete standardization
• Eliminates manual find-replace sessions saving 3 hours weekly

Create Scenario

Corporate Rebranding

Automated Corporate Name Replacement Workflow

Update company names across all Excel files during rebranding:

Complete Scenario Steps:

1. Trigger: File selected for rebranding in content management
2. Get Legacy Document: Retrieve Excel with old company name
3. Replace Company Name: SearchText = "OldCorp Inc.", ReplacementText = "NewCorp LLC"
4. Set Exact Match: MatchEntireCell = false for partial cell matching
5. Case Sensitive: CaseSensitive = true for precise matching
6. Apply Brand Color: Formatting.FontColor = "#003366" (new brand color)
7. Make Bold: Formatting.Bold = "Apply" for emphasis
8. Process All Sheets: Automatic all-worksheet processing
9. Upload Rebranded: Save to rebranded documents folder
10. Email Marketing: Send rebranding completion notification

Business Benefits:

• Rebrands 200+ Excel files automatically during corporate transition
• Text replacement with formatting applies new brand styling
• All worksheets processed preventing missed references
• Reduces manual rebranding from 40 hours to 2 hours total

Create Scenario

Regex Normalization

Automated Phone Number Format Normalization Workflow

Standardize phone number formats using regex patterns:

Complete Scenario Steps:

1. Trigger: Customer data file uploaded to Dropbox
2. Get Customer Data: Retrieve Excel with mixed phone formats
3. Build Regex Pattern: SearchText = "\(?(\d3)\)?[-.\s]?(\d3)[-.\s]?(\d4)"
4. Set Replacement: ReplacementText = "($1) $2-$3" for (555) 123-4567 format
5. Enable Regex: IsExpression = true
6. Set Case Insensitive: CaseSensitive = false
7. Partial Matching: MatchEntireCell = false
8. Process All Sheets: Automatically normalizes all worksheets
9. Upload Normalized: Save standardized data to Google Drive
10. Email Data Team: Send normalization completion report

Business Benefits:

• Normalizes 10,000+ phone numbers in various formats automatically
• Regex capture groups enable complex format transformations
• Consistent phone format improves data quality for CRM import
• Eliminates manual phone number cleanup saving 8 hours per file

Create Scenario

Industry Use Cases & Applications

Data Quality & Standardization

• Address Standardization: Replace state names with abbreviations (California → CA) across customer databases
• Phone Format Normalization: Use regex to standardize phone numbers to consistent (555) 123-4567 format
• Product Code Updates: Replace deprecated product codes with new SKU format across inventory sheets
• Data Entry Error Fixes: Correct common typos and misspellings (recieve → receive) in bulk
• Unit Standardization: Replace various unit representations (lbs, pounds, lb) with standard "lbs"

Corporate Rebranding

• Company Name Updates: Replace old company name with new name across all documents and templates
• Product Line Rebranding: Update product line names throughout pricing sheets and catalogs
• Department Name Changes: Replace reorganized department names across org charts and reports
• Brand Color Application: Replace text with new brand color formatting during rebranding
• Trademark Symbol Addition: Add ® or ™ symbols to product names using regex replacement

Compliance & Legal

• Redaction Replacement: Replace sensitive terms with "[REDACTED]" for compliance reviews
• Legal Entity Updates: Replace acquired company names with parent company name
• Clause Standardization: Replace non-standard contract language with approved clause text
• Reference Updates: Update regulatory citation references when regulations change
• Disclosure Updates: Replace outdated disclosure text with current required language

Template Maintenance

• Year Updates: Replace hardcoded year references (2023 → 2024) in annual templates
• Contact Info Updates: Update contact email, phone, address across all company templates
• URL Updates: Replace old website URLs with new domain across marketing materials
• Version Number Updates: Replace version strings across template footers and headers
• Formula Corrections: Replace incorrect formula references with corrected references in templates

Get Help

Make IntegrationGet your API KeyMake Documentation