Formatter by Zapier

Get to know Formatter by Zapier

Sometimes getting the data in the right format needs a bit of help, though, which is where Formatter comes in. Formatter's a Zapier tool that tweaks your data to get it working the way you need.

Say you need to copy PayPal customers into 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. Just add Formatter to your Zap, and Zapier can format text the way you want before adding it to MailChimp.

Formatter supports the following actions:

  • Numbers - Work with numeric data to do math operations, reformat currencies, and more (with line-item support).

  • Utilities - Various utilities like "choose value from list" or "look up in table" (with line-item support).

  • Date / Time - Work with dates and times to change formatting or add/subtract time (with line-item support).

  • Text - Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).

When you're trying to automate anything in Zapier, and can't figure out how to get two apps to fit together, Formatter will most likely help. Just add it to your Zap, and with a little tweaking you should be able to get your text the way you need before sending it to the next app.

Do more with Formatter by Zapier

Zapier allows you to instantly connect Formatter by Zapier with 1,500+ apps to automate your work and find productivity super powers.

Connect to 1,500+ Apps


Email +1Email, Google

Facebook Lead Ads

Ads & Conversion +2Ads & Conversion, Facebook, Premium

Google Sheets

Google +1Google, Spreadsheets

Formatter by Zapier Pricing

Included with any paid Zapier plan.

Formatter by Zapier Features

  • Split names and other text.

  • Extract email addresses, website links, and numbers from text.

  • Find and replace text.

  • Format dates and times.

Formatter by Zapier Updates

New Formatter Options: Encode URLs and...Add Ellipses

Connect the apps you use every day

Get started with a Free account

By signing up, you agree to Zapier’s Terms of Service