Resolve MIME types by the row. Returns the content type and category for any extension — 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("mimetypelookup", "pdf") beside your keys and pull the reference value for each into its own cell — one trusted lookup per row.
Replace hand-maintained lookup tables with a live one so your reference values never drift out of date.
Use MIME Type Lookup's output as a lookup column your other formulas can VLOOKUP or reference directly.
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("mimetypelookup", "pdf")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("mimetypelookup", "pdf")Add a field name right after the inputs to land just that value in the cell.
=VERVE("mimetypelookup", "pdf", "count")=VERVE("mimetypelookup", "pdf", "results.0.extension")=VERVE("mimetypelookup", "pdf", "results.0.mimeType")=VERVE("mimetypelookup", "pdf", "results.0.category")=VERVE("mimetypelookup", "pdf", "results.0.compressible")=VERVE("mimetypelookup", "pdf", "results.0.source")=VERVE("mimetypelookup", "pdf", "results.0.extensions")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.