Skip to content
Tutorials Center
My learning

Topics

Lesson 16 of 36 ยท Filters, Paths and Formatting

Formatter: Cleaning Text and Numbers

Use the Formatter tool to clean and convert data: trim, case, split, replace, extract, pad, number formatting, math and utilities, with runnable Python equivalents of each transform.

Data rarely arrives in the shape you need. Names come in ALL CAPS, emails have trailing spaces, prices are text with currency symbols, phone numbers use five formats. Formatter is Zapier's built-in utility app for fixing this inside a Zap, without code. It is a core tool: most robust Zaps have at least one Formatter step.

Zapier cannot run on this site. Transform names and options may vary; we describe the common ones in words. The Python blocks are labelled stand-ins: they perform equivalent transforms so you can see the exact input-to-output behavior.

How Formatter works

Add a step, choose the Formatter by Zapier app, then pick a transform type: Text, Numbers, Date/Time, Utilities and others. Fill in the input (mapped from earlier steps) and options. The step returns an output field you can use later. Formatter steps are generally not counted as tasks (confirm current rules).

Text transforms

Transform Does Example
Capitalize First letter of each word upper-case "ada lovelace" becomes "Ada Lovelace"
Lowercase / Uppercase Change case Normalizing emails
Trim whitespace Remove spaces at ends " [email protected] " becomes "[email protected]"
Replace Swap one text for another Remove dashes in phone numbers
Split text Break by a separator, get a segment "Lovelace, Ada" give the part after the comma
Extract email / URL / number / phone Pull a pattern from text Find the email in a long message
Truncate Cut to a length Keep a chat preview short
Pluralize, find, default value Utility helpers Use "Anonymous" when a name is empty

Cleaning data: a stand-in

The block below applies typical text transforms to a messy record. Compare the "before" and "after".

Python Stand-in: text cleaning transforms

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Splitting and positions

Splitting text by a delimiter and choosing the first, last or nth piece is common: "Lovelace, Ada" to last and first names, "2026-03-04" to year, month, day, or an address line to its city. Test with values that lack the delimiter, because the segment will be empty.

Python Stand-in: split text safely

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

The second value has no comma, so the "first name" is empty, which is the situation a good Zap must plan for with a default or a filter.

Numbers

Number transforms convert and compute:

  • Format number: choose decimal places and separators.
  • Spreadsheet-style formula or Perform math operation: add, subtract, multiply, divide.
  • Random number, currency conversion, phone number formatting (in some versions).

Always convert text to numbers first: "1,299.50" with a comma may not be a number until you remove the separator. Remember rounding: money is better calculated in minor units (cents) to avoid floating-point errors.

Python Stand-in: price text to number, tax and rounding

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Utilities

The Utilities group contains helpers such as:

  • Line-item to text and text to line-item: convert between lists and strings.
  • Pick from list: take the first, last or nth item.
  • Lookup table: map input values to outputs ("DE" to "Anna"). See lookups.
  • Import CSV file, Convert Markdown to HTML, Generate Unique ID, and others.

Chaining several Formatter steps

You often need several small transforms: trim, then lowercase, then extract the domain. Each is a separate step, using the previous step's output. Name them clearly ("Normalize email", "Get domain") so history reads well.

Python Stand-in: a chain of small transforms

Press Run (or Ctrl + Enter) to see the result here.

Program input ยท what you'd type while the program runs

Type the answers before you press Run, one per line. Each time the program reads a line (with input()), it gets the next line from this box.

Good habits

  • Normalize early (before searches, filters and comparisons).
  • Provide defaults for empty values.
  • Test with bad input: blanks, extra spaces, other languages.
  • Keep originals when destroying information (for example save the raw phone number in addition to the cleaned one).
  • Watch encoding and accents: transforms like uppercase handle most languages, but test yours.

Check your understanding

Quick check ยท 4 questions

of 4 answered You scored / 4 ยท perfect!

  1. 1. Why normalize an email before a search step?

    Trimming and lower-casing makes lookups and comparisons reliable.
  2. 2. A split step is used on text without the delimiter. What do you get?

    The requested piece may not exist; test and provide defaults.
  3. 3. Which is the safest way to compute money?

    Floats produce tiny errors; decimals or cents avoid them.
  4. 4. Where do you pick Formatter transforms?

    You add a Formatter step and choose Text, Numbers, Date/Time or Utilities transforms.

Summary

  • Formatter cleans and converts data inside a Zap without code.
  • Text transforms trim, change case, replace, split, extract and truncate.
  • Convert text to numbers before math; use decimal-safe rounding for money.
  • Chain small, well-named steps; normalize early; add defaults and test bad input.

Next: Formatter: Dates and Times