Can I parse response (JSON, XML, whatever) into cells without VBA? | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		ComodoHacker on May 24, 2024 \| parent \| context \| favorite \| on: Regular expression functions in Excel Can I parse response (JSON, XML, whatever) into cells without VBA?

xnx on May 24, 2024 | [–]

With some effort, probably: =FILTERXML() https://support.microsoft.com/en-us/office/filterxml-functio...

Could also do some crude/fragile parsing with aforementioned regex functions.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact