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.
ExampleYou 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.
With Formatter, you can:
- Analyze and modify text formats
- Modify number formats
- Modify date formats
- And perform a variety of utility functions
Learn more about the different ways you can format your data and use Formatter in your Zaps.
Formatter transformations
All number transformations
- Format Currency
- Format Number
- Format Phone Number
- Perform Math Operation
- Random Number
- Spreadsheet-Style Formula
Learn more about number transformations.
All text transformations
- Capitalize
- Convert HTML to Markdown
- Convert Markdown to HTML
- Convert to ASCII
- Default Value
- Extract Email Address
- Extract Number
- Extract Pattern
- Extract Phone Number
- Extract URL
- Find
- Length
- Lowercase
- Pluralize
- Remove HTML tags
- Replace
- Split Text
- Spreadsheet-Style Formula
- Superhero Name
- Titlecase
- Truncate
- Trim Whitespace
- URL Decode
- URL Encode
- Uppercase
- Word Count
Learn more about text transformations.
All date / time transformations
- Add/Subtract time
- Format
Learn more about date / time transformations.
All utility transformations
- Import CSV file
- Line itemizer (to create, append or prepend line items)
- Lookup table
- Pick from list
- Text to line-item
- Line-item to text
