Get started with Formatter

Available on plans:

Free

Pro

Team

Enterprise

Formatter is Zapier’s built-in utility tool for transforming text, numbers, and other data into the format you need. Use Formatter when you need data in a different format than the format it’s coming in from your trigger or another step.

With Formatter, you can:

• Analyze and modify text formats
• Modify number formats
• Modify date and time formats
• And perform a variety of utility functions

You can also use Formatter with AI to discover formatting options as you map your fields, and describe what you need in plain language, and Zapier will draft the relevant Formatter step for you.

Example

You have a Zap that sends new PayPal customers to a MailChimp mailing list. PayPal shows your customers' full names and the detailed time and date they bought your product—but all you want is their first name and the day of the week. With Formatter, you can extract and format text the way you want before adding it to MailChimp.

• Count the number of characters or words in your Zap fields
• Use Formatter to decode and encode HTML in Zaps
• Remove extra text from your Zap data
• Convert the letter casing in a text string in your Zaps
• Use Formatter to split text in Zaps
• Modify large data for your AI prompts
• Extract data in Zaps
• Find and replace values in your Zaps
• Change your Zap data to HTML, Markdown, ASCII, or plain text
• Use regular expressions (regex) to find text in Zaps

Date and time transforms

• Add or subtract dates and times in Zaps
• Compare dates and times in Zaps 
• Modify dates and times formats in Zaps

Utility transforms

• Create lookup tables in Zaps
• Create line items in Zaps
• Create line items into text strings
• Pick from a list of items in Zaps
• Import CSV files into Zaps