6] Convert to table The final thing you will want to do here is to convert the JSON data to a table. Do this by clicking on Into Table, then hit Close & Load.

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

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...