Formulas for
Fill cells with strong passwords. Returns secure passwords by the row — Google 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 1 credit 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("passwordgenerator", 10, 12, "strong") down a column and Generate Passwords returns a result for every row — a batch of live values in a single drag, no code.
Add Generate Passwords beside a table you already have to append its output right where your data lives, then sort, filter, or chart on it.
Set the sheet to refresh on a schedule and the generate passwords values keep themselves current without anyone re-typing.
The same function works in both apps — install once, sign in with your key, and type it into any cell.
Google SheetsAdd-onInstall from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.
=VERVE("passwordgenerator", 10, 12, "strong")
Microsoft ExcelAdd-inSame 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("passwordgenerator", 10, 12, "strong")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
The kind of password to generate. random uses the complexity preset, pronounceable builds readable syllables, passphrase joins dictionary words, and custom honours the include/exclude switches below
=VERVE("passwordgenerator", 10, 12, "strong", "type", "random")Include digits. Applies to custom and pronounceable, and to random at simple complexity
=VERVE("passwordgenerator", 10, 12, "strong", "includeNumbers", "true")Include punctuation symbols. Applies to custom, and to random at medium complexity
=VERVE("passwordgenerator", 10, 12, "strong", "includeSymbols", "true")Include uppercase letters. Applies to custom, and to random at simple complexity
=VERVE("passwordgenerator", 10, 12, "strong", "includeUppercase", "true")Include lowercase letters in a custom password. Set false to build from the other character sets only
=VERVE("passwordgenerator", 10, 12, "strong", "includeLowercase", "true")Exclude characters that are easy to confuse when read aloud or typed (i, l, 1, L, o, 0, O)
=VERVE("passwordgenerator", 10, 12, "strong", "excludeSimilar", "true")Exclude brackets, slashes, quotes and other characters that need escaping in shells and config files
=VERVE("passwordgenerator", 10, 12, "strong", "excludeAmbiguous", "true")Randomly capitalise letters in a pronounceable password
=VERVE("passwordgenerator", 10, 12, "strong", "mixedCase", "true")Guarantee at least one character from every enabled set rather than leaving it to chance
=VERVE("passwordgenerator", 10, 12, "strong", "strict", "true")How many words a passphrase contains. Only applies when type is passphrase
=VERVE("passwordgenerator", 10, 12, "strong", "wordCount", "4")The character placed between passphrase words. Only applies when type is passphrase
=VERVE("passwordgenerator", 10, 12, "strong", "separator", "-")Capitalise each word of a passphrase. Only applies when type is passphrase
=VERVE("passwordgenerator", 10, 12, "strong", "capitalize", "true")Return a strength analysis alongside each password
=VERVE("passwordgenerator", 10, 12, "strong", "analyze", "true")Add a field name as the last argument to land just that value in the cell.
=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords")=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords.0.password")=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords.0.length")=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords.0.metadata")=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords.0.metadata.type")=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords.0.metadata.complexity")=VERVE("passwordgenerator", 10, 12, "strong", "field", "passwords.0.analysis")=VERVE("passwordgenerator", 10, 12, "strong", "field", "count")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.
=VERVE("acronymgenerator", "Application Programming Interface")
=VERVE("babynamegenerator", "male")
=VERVE("bingocardgenerator", "field", "size")
=VERVE("boggleboardgenerator", "field", "size")
=VERVE("colorpalette", "FF5733", "field", "source")
=VERVE("commentgenerator", "text", "field", "count")