Are you sure there never was an option like this?

[prabha_friend]

An option to save/export data to a JSON File..
On the entire span of Ms Office tools..

 

[theDBguy]

Does this help answer your question?

Parse text as JSON or XML (Power Query) - Microsoft Support

Deconstruct the contents of a column with text strings that contain JavaScript Object Notation (JSON) or Extensible Markup Language (XML).

support.microsoft.com

 

[isladogs]

The OP was asking about exporting to JSON.
Whilst you can IMPORT JSON files into Excel using Get and Transform, you cannot export data to JSON from Office programs

 

[theDBguy]

The OP was asking about exporting to JSON.
Whilst you can IMPORT JSON files into Excel using Get and Transform, you cannot export data to JSON from Office programs

I haven't looked at this one. How about this one?

Output Excel data as JSON - Office Scripts

Learn how to output Excel table data as JSON to use in Power Automate.

learn.microsoft.com

 

[theDBguy]

Looks like there may be an Excel add-in too?

https://appsource.microsoft.com/en-us/product/office/WA104380263?src=office&corrid=60f1f2ed-b547-4f81-24a3-a5333bb2f823&omexanonuid=&referralurl=

 

[isladogs]

No I hadn't seen either of those before.
Unless I'm mistaken, the first link is just for flat file structures.
The second one says it supports nested structures but doesn't show any examples of that.

More complex JSON files can have several levels of subarray nested within each other. Achieving that would be a real challenge

 

[gemma-the-husky]

It's quite hard to find VBA information relating to JSON.

Writing both JSON and XML files is relatively straightforward from first principles, but you need to understand the file structure you are creating, hence the first issue noted.