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 ...
The task of converting JSON to an Excel CSV file won’t take a long time. We suspect it can take less than a minute if you move fast enough and have the relevant knowledge. From the standard import ...