Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • Built-in tools
  • Formatter
  • Getting started with Formatter

Get started with Formatter

Written by Owner

Updated at August 20th, 2025

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Tables
    Work with tables Manage tables Create tables Troubleshoot Zapier Tables
  • Product updates
    Product updates: January 2023 Product updates: March 2023 Product updates: February 2023 Product updates: April 2023 Product updates: May 2023 Product updates: June 2023 Product updates: July 2023 Product updates: August 2023 Product updates: September 2023 Product updates: October 2023 Product updates: November 2023 Product updates: December 2023 Product updates: January 2024 Product updates: February 2024 Product updates: March 2024 Product updates: April 2024 Product updates: May 2024 Product updates: June 2024 Product updates: July 2024 Product updates: August 2024 Product updates: September 2024 Product updates: October 2024 Product updates: November 2024 Product updates: December 2024 Product updates: January 2025 Product updates: February 2025 Product updates: March 2025 Product updates: April 2025 Product updates: May 2025 Product updates: June 2025 Product updates: July 2025 Product updates: August 2025
  • Zaps
    Zap basics Zap history Troubleshoot Zaps Manage your Zaps Do more with Zaps
  • Your Zapier account
    Plans Billing Account profile Notifications Data privacy & security Get help User roles and permissions
  • Interfaces
    Troubleshoot Zapier Interfaces Create an interface Use interface components Manage interfaces
  • Canvas
    Create a canvas Collaborate on a canvas
  • Chatbots
    Add logic and knowledge to chatbots Troubleshoot chatbots Create chatbots Manage chatbots
  • Getting started
    Intro to Zapier Set up your Zapier account Use case templates
  • Agents
    Create agents Manage agents Troubleshoot agents
  • MCP
    Set up MCP
  • Built-in tools
    Filter & Paths Formatter Schedule & Delay Email, IMAP, SMTP, & Email Parser Webhooks & Code Storage, Digest, & RSS Sub-Zap & Looping Other built-in tools Custom Actions & API Requests Functions AI by Zapier & AI actions Copilot Human in the Loop
  • Lead Router
    Create routers
  • Apps
    Connect and manage your app connections AI apps on Zapier Apps on Zapier
+ More

Table of Contents

Date and time transforms Number transforms Text transforms Utility transforms

Available on plans:

A green checkmark

Free

A green checkmark

Pro

A green checkmark

Team

A green checkmark

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:

  • Modify date and time formats.
  • Modify number formats.
  • Analyze and modify text 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.

actionEdit icon 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.

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

Number transforms

  • Modify number formats in Zaps 
  • Perform maths operations in Zaps
  • Select a random number in Zaps
  • Compare dates and times in Zaps
  • Use spreadsheet-style formulas in Zaps to work with both text and numbers 

Text transforms

  • 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

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

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Use Formatter with AI to automatically format data
  • Available spreadsheet-style formulas
  • Use spreadsheet-style formulas in Zaps

Copyright 2025 – OBZ-Zapier.

Knowledge Base Software powered by Helpjuice

Expand