Convert JSON to CSV in C#

readme.md

Learn how to convert JSON data or files to CSV format using C#: https://blog.aspose.com/2021/10/04/convert-json-to-csv-using-csharp/

json-to-csv.cs

// load JSON data
string jsonInput = "[{'nodeId':1,'reputation':1134},{'nodeId':2,'reputation':547},{'nodeId':3,'reputation':1703},{'nodeId':4,'reputation':-199},{'nodeId':5,'reputation':-306},{'nodeId':6,'reputation':-49},{'nodeId':7,'reputation':1527},{'nodeId':8,'reputation':1223}]";

// create a blank Workbook object
var workbook = new Workbook();

// access default empty worksheet
var worksheet = workbook.Worksheets[0];

// set JsonLayoutOptions for formatting
var layoutOptions = new JsonLayoutOptions();
layoutOptions.ArrayAsTable = true;

// import JSON data to CSV
JsonUtility.ImportData(jsonInput, worksheet.Cells, 0, 0, layoutOptions);

// save CSV file
workbook.Save("output.csv", SaveFormat.CSV);