HelpCreateFormat data in Zaps

Get started with Formatter

Last updated:

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.


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.

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

Learn more about number transformations.

All text transformations

Learn more about text transformations.

All date / time transformations

  • Add/Subtract time
  • Format

Learn more about date / time transformations.

All utility transformations

Need more help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community

Zapier University

Video courses designed to help you become a better Zapier user, whether you’re a beginner or more experienced.
View courses