Now, opening a JSON file is not hard, however, it would make more sense to convert it to the Microsoft Excel (CSV) format for easier use. The question is, how does one convert a JSON file to Excel?

While I could switch to using SQL Server's new ability to convert query results into JSON, the existing code has that whole "working" feature that people like so much -- I have no desire to replace it ...

Click the Convert to table button in the ribbon. This gives you a single column view of the JSON records, which you can now use to choose the elements you want to use in your final spreadsheet.

Build your own custom Python script to automate the measurement of key speed and performance metrics for your website with this beginner-friendly guide.