Parse CAA Records in a Cell in Google Sheets & Excel — =VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"")

What this pulls

Break down DNS CAA records by the row. =VERVE("caaparser", A2) returns the CA, tag and policy for each record — 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.

See it in a cell

A real example — the input you type, and the values you can pull from it. Click any cell to see the formula behind it.

caaparser.xlsxsample data

B2fx=VERVE("caaparser", A2, "raw_record")

Record

Raw record

Domain

Ttl

Class

example.com. 3600 IN CAA 0 issue "letsencrypt.org"

example.com. 3600 IN CAA 0 issue "letsencr…

example.com

3600

click any cell to see its formula1 credit / cell

Ways to use it

Look up facts in the grid

Fill =VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"") beside your keys and pull the reference value for each into its own cell — one trusted lookup per row.

Standardize a dataset

Replace hand-maintained lookup tables with a live one so your reference values never drift out of date.

Join to your data

Use Parse CAA Records in a Cell's output as a lookup column your other formulas can VLOOKUP or reference directly.

Use it in your sheet

The same function works in both apps — install once, sign in with your key, and type it into any cell.

Google SheetsAdd-on

Install from the Workspace Marketplace, then drop the formula into a cell. Autocomplete suggests the source and its fields.

=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"")

Microsoft ExcelAdd-in

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("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"")

Fields you can pull

Add a field name as the last argument to land just that value in the cell.

Raw record
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "raw_record")
Parsed.domain
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "parsed.domain")
Parsed.ttl
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "parsed.ttl")
Parsed.class
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "parsed.class")
Parsed.flags
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "parsed.flags")
Parsed.tag
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "parsed.tag")
Parsed.value
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "parsed.value")
Ca infoPremium
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "ca_info")
Ca info.name
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "ca_info.name")
Ca info.type
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "ca_info.type")
Ca info.wildcard support
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "ca_info.wildcard_support")
InterpretationPremium
=VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"", "field", "interpretation")

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

Parse CAA Records in a Cell, answered

Everything you need to wire it into a sheet.

How do I pull Parse CAA Records in a Cell into a spreadsheet?

Install the VerveSheets add-on, sign in with your key, and type =VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"") into any cell. The same function works in Google Sheets and Excel — no scripts, no API wiring.

How many credits does each Parse CAA Records in a Cell cell cost?

Each resolved cell costs 1 credit. Filling a column of ten rows costs ten times that; a cell only re-bills when it actually refreshes, so a static sheet doesn't keep charging.

Can I fill a whole column at once?

Yes. Reference a range instead of a single cell — e.g. point Parse CAA Records in a Cell at A2:A50 — and it returns a value for every row in one call, or just drag =VERVE("caaparser", "example.com. 3600 IN CAA 0 issue "letsencrypt.org"") down like any spreadsheet function.

Does Parse CAA Records in a Cell work in Excel as well as Google Sheets?

Yes. It's the same =VERVE() function with the same arguments and the same key in both — build a sheet in one and it behaves identically in the other.

How current is the data?

Parse CAA Records in a Cell is served live from APIVerve's production data engine, and cells recalculate on the refresh cadence you choose — every open, hourly, or every 30 minutes.

Where does the data come from, and what shows on my bill?

VerveSheets runs on APIVerve, our production data engine; Parse CAA Records in a Cell is one of 300+ sources on the same key. Invoices and card statements show APIVERVE.

Parse CAA Records in a Cell

Look up facts in the grid

Standardize a dataset

Join to your data

Parse CAA Records in a Cell, answered

Put Parse CAA Records in a Cell in your next spreadsheet. Add the extension, paste the formula, and the cell keeps itself current.

Scaling up?