Clean text by the row. Masks profanity and flags whether a cell contained any — Sheets or Excel.
It's one of 250+ live sources you reach with a single =VERVE() function — served from APIVerve's production data engine, billed at 2 credits per resolved cell, and refreshed on whatever cadence you set. No API keys to wrangle, no scripts, no exports.
A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.
Fill =VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane") beside messy text and get the normalized, analyzed, or translated version back — data cleaning without leaving the grid.
Score or classify a whole column of responses, reviews, or messages in one fill instead of one-by-one.
Nest Filter Profanity's output inside your existing SUM, IF, or CONCAT logic like any other cell value.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane")Same source, same arguments, same key — in Excel on desktop, the web, or mobile. Excel namespaces it as VERVE.CALL. Drag to fill a whole column.
=VERVE.CALL("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
The mask to replace the profanity words with. Should be a Single Character (e.g., *)
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane", "mask", "*")Add a matches list with each filtered word and its start and end position
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane", "details", "true")Comma-separated words the filter should not flag, up to 100 single words (e.g. hell,damn)
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane", "allow", "hell")Comma-separated extra words to flag and mask, up to 100 single words
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane", "add", "frick")Add a field name right after the inputs to land just that value in the cell.
=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "filteredText")=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "isProfane")=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "trimmed")=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "profaneWords")=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "matches")=VERVE("profanityfilter", "Today is so damn hot! Why the hell would anyone go outside?", "mask")Premium marks data included on paid plans. On the Free plan a marked field is withheld and a marked input is ignored — either way the cell reads #PREMIUM(name) instead of a value, so a gated answer can never be mistaken for a real one. Everything unmarked works on every plan. Compare plans
Everything you need to wire it into a sheet.