Formulas for
Encode and decode Morse from a cell. Converts text to Morse and back down a column — 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("morsecode", "This Is A Message", "field", "morse") down a column and Morse Code returns a result for every row — a batch of live values in a single drag, no code.
Add Morse Code 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 morse code 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("morsecode", "This Is A Message", "field", "morse")
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("morsecode", "This Is A Message", "field", "morse")Tune the result by adding name=value before the field argument — in any order. Leave one out and its default applies.
Set to true to include an audio file of the Morse code
=VERVE("morsecode", "This Is A Message", "audio", "false")Add a field name as the last argument to land just that value in the cell.
=VERVE("morsecode", "This Is A Message", "field", "morse")=VERVE("morsecode", "This Is A Message", "field", "stats")=VERVE("morsecode", "This Is A Message", "field", "stats.characters")=VERVE("morsecode", "This Is A Message", "field", "stats.dits")=VERVE("morsecode", "This Is A Message", "field", "stats.dahs")=VERVE("morsecode", "This Is A Message", "field", "valid")=VERVE("morsecode", "This Is A Message", "field", "audio.audioFile")=VERVE("morsecode", "This Is A Message", "field", "audio.format")=VERVE("morsecode", "This Is A Message", "field", "audio.downloadURL")=VERVE("morsecode", "This Is A Message", "field", "audio.duration")=VERVE("morsecode", "This Is A Message", "field", "audio.frequency")=VERVE("morsecode", "This Is A Message", "field", "audio.sampleRate")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("counter", "test_counter", "field", "created")
=VERVE("htmltotext", "<!doctype html> <html> <head> <title>This is the title of the webpage!</title> </head> <body> <p>This is an example paragraph. Anything in the <strong>body</strong> tag will appear on the page, just like this <strong>p</strong> tag and its contents.</p> </body> </html>", "field", "text")
=VERVE("sqlexplainer", "SELECT u.name, COUNT(o.id) as order_count FROM users u LEFT JOIN orders o ON u.id = o.user_id WHERE u.created_at > '2024-01-01' GROUP BY u.id HAVING COUNT(o.id) > 5 ORDER BY order_count DESC", "field", "explanation")
=VERVE("metadataextractor", "https://apiverve.com", "field", "requestUrl")