Formatter - Features, Pricing, Alternatives, and More
What is Zapier Formatter?
You want to move data—your contact list, say—from one app to another, right? Zapier’s the tool for that. It's a workflow automation tool that connects 1000+ apps—from Airtable to Zoho CRM and everything in between—so when someone new buys your products or fills out your form or anything else, Zapier can copy that data and add it to the correct app.
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.
Launched on Zapier January 23, 2016
Zapier combines Triggers (like "New Subscriber") and Actions (like "Numbers") to complete an action in one app when a trigger occurs in another app. These combos—called "Zaps"—complete your tasks automatically.
The following Formatter Triggers, Searches, and Actions are supported by Zapier:
Work with numeric data to do math operations, reformat currencies, and more (with line-item support).
Various utilities like "choose value from list" or "look up in table" (with line-item support).
Work with dates and times to change formatting or add/subtract time (with line-item support).
Work with text data to find & replace, capitalize, remove HTML, and more (with line-item support).
Do More With Formatter
Extract phone numbers from emails
Manually adding contacts can take up a lot of time. Even if it's just two minutes for one contact a day, that'll add up to 12 hours of copy and paste every year! Zapier can automatically create new contacts from emails you receive and also look for phone numbers in the email signature.Use This Zap
Split First and Last Names
Remember the complicated Excel formulas we used to use to split first and last names? Things have improved. You can add a Formatter step in your Zap to automatically split names when you're passing info from one app to another.
Convert Markdown to HTML
Writing in HTML can be distracting when you have to memorize tags and make sure they're all closed. Use Zapier Formatter to automatically convert Markdown to HTML when you want to post to your blog, website, or print a formatted pdf.Use This Zap