How to use formatter for data on Zapier

intermediate 8 min read Updated 2026-03-18

Quick Answer

Zapier's Formatter tool transforms data between apps by cleaning, formatting, or converting text, numbers, dates, and other data types. Add it as an action step in your Zap to modify data before sending it to your destination app.

Try Zapier Full Zapier Review

Prerequisites

Active Zapier account
Basic understanding of Zaps and workflows
Data that needs formatting or transformation
Access to source and destination apps

Step-by-Step Instructions

Add Formatter to Your Zap

In your Zap editor, click + Add Step between your trigger and action. Search for Formatter by Zapier in the app selection menu and select it. Choose Action as the event type to transform your data.

Formatter works best when placed between your trigger and final action to clean data before it reaches your destination app.

Select the Data Type to Format

Choose the appropriate data type from the options: Text, Numbers, Date/Time, Utilities, or Lookup Tables. Each category contains specific formatting functions. For example, select Text for string manipulation or Date/Time for timestamp conversions.

Text formatting is the most commonly used option for cleaning names, emails, and removing extra spaces.

Choose the Specific Transform Function

Select the exact transformation you need from the dropdown menu. Popular options include Titlecase, Replace, Split Text for text, or Format Date/Time and Add/Subtract Time for dates. Each function will show a brief description of what it does.

Configure the Input Data

In the Input field, map the data from your trigger step that you want to transform. Click in the field and select the appropriate field from the Insert Data dropdown, or type custom text. You can combine multiple fields or add static text as needed.

Use the data pill picker to ensure you're pulling the correct field from your trigger step.

Set Additional Transform Parameters

Configure any additional settings specific to your chosen transform. For Replace, enter the text to find and replacement text. For Date Format, specify the output format like MM/DD/YYYY. For Split Text, define the separator character.

Test different date formats using Zapier's format guide or common patterns like YYYY-MM-DD for databases.

Test the Formatter Step

Click Test Step to run the formatter with sample data from your trigger. Review the Output section to verify the transformation worked correctly. The result will show the original input and the formatted output for comparison.

Always test with real data from your trigger to ensure the formatting works as expected.

Use Formatted Data in Subsequent Steps

In your next action step, map the formatted data by selecting it from the Formatter section in the data picker. The formatted output will be labeled clearly, such as Output or Formatted Text, depending on the transform type used.

You can chain multiple Formatter steps together for complex data transformations.

Turn On and Monitor Your Zap

Once satisfied with your formatting, click Turn Zap On to activate it. Monitor the Task History to ensure the formatter is working correctly with live data. Check for any errors in the formatting step and adjust settings if needed.

Set up error notifications to catch formatting issues early, especially with date and number transformations.

Common Issues & Troubleshooting

Formatted output is blank or showing 'null'

Check that your input field contains data and verify the field mapping from your trigger step. Ensure the source field isn't empty and try testing with different sample data.

Date formatting isn't working correctly

Verify the input date format matches what your trigger provides. Use Date/Time > Parse first if Zapier can't recognize the date format, then apply Format Date/Time.

Text replacement isn't finding matches

Check for exact case matching and hidden characters. Use Text > Trim Whitespace first, then apply replacement. Consider using Find and Replace with case-insensitive options.

Split text creating too many or too few segments

Verify your separator character is correct and check the source data for inconsistent formatting. Use Text > Extract Pattern for more complex text splitting needs.

Prices mentioned in this guide are pulled from current plan data and may change. Always verify on the official Zapier website before purchasing.

Visit Zapier View Zapier Pricing