Convert JSON to CSV in Node.js

readme.md

Learn how to export data from JSON to CSV in Node.js: https://blog.aspose.com/2021/09/07/convert-json-to-csv-using-nodejs/

json-to-csv.js

// load JSON data
var 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 = aspose.cells.Workbook()

// access default empty worksheet
var worksheet = workbook.getWorksheets().get(0)

// set JsonLayoutOptions for formatting
var layoutOptions = aspose.cells.JsonLayoutOptions()
layoutOptions.setArrayAsTable(true)

// import JSON data to default worksheet starting at cell A1
aspose.cells.JsonUtility.importData(jsonInput, worksheet.getCells(), 0, 0, layoutOptions)

// save resultant file
workbook.save("output.csv", aspose.cells.SaveFormat.CSV)