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.

• Capitalize
• Convert HTML to Markdown
• Convert Markdown to HTML
• Convert to ASCII
• Default Value
• Extract Email Address
• Extract Number
• Extract Pattern
• Extract URL
• Find
• Length
• Lowercase
• Pluralize
• Remove HTML tags
• Replace
• Split Text
• Split Text into Chunks for AI Prompts (beta)
• Spreadsheet-Style Formula
• Titlecase
• Trim Whitespace
• Truncate
• URL Decode
• URL Encode
• Uppercase
• Word Count