Turn XML into JSON from a cell. =VERVE("xmltojson", A2) returns structured JSON down a column — Google Sheets or Excel, no code.
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.
Fill =VERVE("xmltojson", "<?xml version="1.0"?><root><item>value</item></root>") beside a column of input and get the converted value back for every row — a batch conversion done in one drag.
Turn one format into another right in the cell instead of round-tripping through a script or an online tool.
Pipe the converted value straight into the formula or chart that needs it.
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("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>")
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("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>")Add a field name as the last argument to land just that value in the cell.
=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "status")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "error")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data.note")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data.note.children")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data.note.children[].to.content")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data.note.children[].from.content")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data.note.children[].heading.content")=VERVE("xmltojson", "<?xml version="1.0" encoding="UTF-8"?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>", "field", "data.note.children[].body.content")Everything you need to wire it into a sheet.
=VERVE("base64", "Hello World")
=VERVE("colorconverter", "FF0000")
=VERVE("csvtojson", "name,age,city
John,30,New York
Jane,25,Los Angeles")
=VERVE("jsontocsv", "[{"name":"John","age":30},{"name":"Jane","age":25}]")
=VERVE("meetingtimeconverter", "14:30", "America/New_York", "Europe/London")
=VERVE("numberbaseconverter", "255")