What we do
Tools
Industries
Department
How we workLet's talk →
Home/Zapier/Formatter by Zapier
Zapier

Formatter by Zapier: Matching Each Messy Field to Its Text, Number or Date Transform

The CRM wants 2026-03-04 and the form sent March 4th. Formatter by Zapier is the built-in step that fixes that mid-Zap without code. Add it as an action, choose one of four events (Text, Numbers, Date / Time or Utilities), then pick a transform from that event's list.

Adding a Formatter step

Add an action between the trigger and the step that needs clean data, search for Formatter by Zapier, and choose the event that matches the data type.

+ Formatter by Zapier Action event Transform

Map the field you want changed into Input, set the transform's options, and test the step. Later steps can then use Formatter's output instead of the raw field.

Task cost: in Classic Zaps, Formatter steps don't count toward your task usage, and neither do Filter or Paths steps.

Which Formatter event holds the transform you need

The data problem Event and transform Worth knowing
Full name in one field, CRM wants first and last Text, Split Text Choose which segment to return. Names with a middle name or two surnames split in odd places.
Order number buried in an email subject Text, Extract Pattern (regex) Test against several real subjects, not just the one sample Zapier pulled.
Shouty capitals or stray HTML from a form Text, case conversion, Remove extra text, or HTML to plain text Run cleanup before you split or extract, or the pattern won't match.
"1,250.00" stored as text, or a phone number in five formats Numbers, Format Number or Format Phone Number Set the input's decimal mark. European amounts use a comma.
Tax, discount or a total across two fields Numbers, Perform Math Operation or spreadsheet-style formula A formula reaches further than one math operation per step.
Date in the wrong format or time zone Date / Time, Format Set both the From and To formats. Leaving the input format to guesswork is how 03/04 becomes April.
Due date 30 days after the invoice date Date / Time, Add/Subtract Time Use Compare Dates if the next step needs to know which date is later.
"Gold" in one app has to become plan ID 7 in another Utilities, Lookup Table The table lives inside the Zap. If the codes change, someone edits every Zap that copies it.
An order with several products Utilities, Create Line Items or Line Items to Text The next app has to accept line items, or you'll get only the first product.

When a Formatter chain has turned into business logic

Formatter's menu is fixed, and that's fine for cleanup. It gets fragile when four or five Formatter steps are stacked to approximate one rule: parse a legacy SKU, look up the region, apply a price band, format the result. Each step is another place a run can quietly produce the wrong value, and nobody can read the rule in one place.

Zapier has its own next steps for this. Code by Zapier runs a short JavaScript or Python snippet inside the Zap, and Sub-Zaps let several Zaps share one set of steps. Use them for a one-off quirk.

When the rule decides money, needs live data from another system, or is copied across many Zaps, n-frames writes it as tested code. Your Zaps call it through a webhook step, so a rule change happens once. Branching on the result is a separate job: Filter only stops a Zap, and the main Zapier page covers where Paths fits.

Formatter output that looks right in the test and wrong in Zap history

The test sample was tidier than real data

How you'll know: The step passed in the editor, then live runs return blanks.

Fix: Pull a fresh sample with the messy cases in it (missing middle name, extra spaces, an empty field) and retest before you publish.

A blank input made a blank output, silently

How you'll know: Later steps run with an empty value and the record is created half-filled.

Fix: Add a Filter step after the Formatter that only continues when the output isn't empty. Filter steps don't use tasks in Classic Zaps.

The date flipped day and month

How you'll know: Invoices dated 4 March show up as 3 April in the next app.

Fix: Set the From Format explicitly on the Date / Time step instead of leaving Zapier to read it.

Only the first line item came through

How you'll know: An order with three products creates a record with one.

Fix: Check that the receiving action supports line items. If it doesn't, convert them to text with Line Items to Text, or loop through them.

Formatter and Filter, in short

What is Formatter by Zapier?

A built-in Zapier action for reshaping data mid-Zap without code. Its four events are Text (split, extract, replace, change case, strip HTML), Numbers (format, math, phone numbers, formulas), Date / Time (format, add or subtract, compare) and Utilities (lookup tables, line items, pick from a list, import CSV files).

What's the difference between Filter by Zapier and Paths?

Filter is a gate: when its condition isn't met, that run of the Zap stops. Paths sends the run down different branches depending on which condition matched. Use Filter for go or no-go, and Paths when there's more than one way forward.

Can Zapier Formatter use regular expressions?

Yes. The Text event's Extract Pattern transform takes a regular expression, so you can match your own patterns. For long or nested patterns, test against many real inputs, since a pattern that doesn't match can leave the output empty without stopping the Zap.

Does using Formatter or Filter cost extra Zapier tasks?

Not in Classic Zaps. Zapier's help lists Formatter, Filter and Paths steps among the ones that don't use tasks. The cost of a long Formatter chain is upkeep: more steps to edit, and more places a run can go wrong.

Can Zapier Filter check conditions from more than one app at once?

Only fields already in that Zap run. If the condition depends on another system, add a search or lookup step for that app first so its data is in the run. When a check needs several systems at once, n-frames builds it as one service the Zap calls, and Filter acts on the answer.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.