Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Convert JSON to CSV in Java
// 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
Workbook workbook = new Workbook();
// access default empty worksheet
Worksheet worksheet = workbook.getWorksheets().get(0);
// set JsonLayoutOptions for formatting
JsonLayoutOptions layoutOptions = new JsonLayoutOptions();
layoutOptions.setArrayAsTable(true);
// export JSON data to CSV
JsonUtility.importData(jsonInput, worksheet.getCells(), 0, 0, layoutOptions);
// save CSV file
workbook.save("output.csv", SaveFormat.CSV);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment