However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

Twitter used to provide CSV exports of your data, now it's all in machine-readable JSON. How can you use it in Excel?