Formatter

Formatter Updates

Formatter update · July 19, 2018

New for Formatter: Do More with Line Items and Split Text

You don't want to sell one item—you'd much prefer customers with full shopping carts and dozens of detailed orders. Line items give you the details of every item, but sometimes that's not quite enough. Zapier's newly updated Formatter actions give you more control over the...read more
Formatter mention · May 14, 2018

How to Find Records Automatically in Google Sheets, Excel, and Zapier

Spreadsheets excel at crunching numbers. Add a column of figures—your sales or expenses, perhaps—and a quick formula =SUM(A1:A10) can add them up or =AVERAGE(A1:A10) returns the average price. They’re flexible yet powerful. Databases are better at connecting enormous amounts of data across different...read more
Formatter mention · December 13, 2017

MeisterLabs Built a Workflow in Slack to Manage Vacation Requests

Communication sits at the heart of any great relationship—including co-workers or different teams within a company. But as businesses grow, communication can dwindle. Ensuring different departments know what the others are up to can be a challenge. MeisterLabs, creators of MindMeister and MeisterTask found a simple fix. With team...read more
Formatter update · November 24, 2017

Updates to Our Built-In App, Formatter by Zapier: Line Item Support

Your client invoice or eCommerce order is made up of line items—for example, individual, itemized expenses on a receipt, order, invoice, or payment. This Formatter update adds support for these line items so you can use Zapier to automatically add each line item from an order to, say, a...read more
Formatter mention · October 31, 2017

Customer.io Automatically Standardizes Form Submissions for Reporting

When you work on a small team, odds are high that you have multiple responsibilities. Some of those tasks are probably shared, too, or jump department lines. Today might be a marketing project but tomorrow might have more of a sales or support slant to it. Maybe it's a...read more
Formatter mention · September 26, 2017

How to Automatically Convert Markdown to HTML

Formatting text should be easy. Often, however, it's not. If you've ever opened a Word document in an earlier version of Word or in a different word processor app and then spent half an hour getting your formatting looking perfect again, you know how annoying rich text can...read more
Formatter mention · September 22, 2017

How to Find and Replace Any Text in Your Documents

Your company just updated its name—it's not Apple Computer, Inc. anymore, now it's just Apple, Inc, and every reference you have to OS X needs to be replaced to macOS. Even more common: come New Years, all of your document headers and copyright footers will have the...read more
Matthew Guay
Reviewed by Matthew Guay
Last updated August 30, 2018

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.

Have any feedback on this overview, or something we should change? Let us know!

Use our free platform to build a single Zapier integration and instantly connect your app with 1,000+ others.

Become a Zapier Integration Partner

About Formatter by Zapier

Built-In

Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.