What is XML?

Verbose, strict, and still holding up enormous amounts of the world - government feeds, financial messaging, publishing, office documents. JSON took the web from it, but anywhere with schemas and validators and twenty years of history, XML is what's on the wire.

What is JSON?

The format the web runs on. Nested objects and arrays, real types, and a syntax small enough to fit on a postcard. It maps badly onto a grid, which is why converting deeply nested JSON to a spreadsheet always involves losing something.