You can convert JSON files to Microsoft Excel CSV file formats using this hidden built-in feature. We show you how to do it.

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 ...

Here's how you can use SQL Server's OpenJson function to dismantle JSON structures into relational tables targeting either transactional systems or data warehouses. JSON is great for moving data ...

How to convert XLS and JSON files to CSV in Linux with csvkit Your email has been sent Sometimes you just need a quick means of converting a spreadsheet to a comma-separated values file. When you ...

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 ...