JSON is an immensely used format to store structured data. In various cases, JSON files are used to transmit data between applications. Alongside, CSV is also used to store the data as comma separated values. In this article, you will learn how to import data from JSON files to CSV programmatically. Particularly, the article will cover how to convert JSON data to CSV using C#.
C# API for JSON to CSV Conversion
In order to convert JSON data to CSV, we will use Aspose.Cells for .NET. It is a powerful API for creating, modifying, and converting spreadsheet files from within .NET applications. You can either download the API or install it using NuGet.
PM> Install-Package Aspose.CellsConvert a JSON Data or File to CSV
The following are the steps to convert JSON data to CSV format using C#.
- Create a new Workbook object.
- Get reference of the first worksheet using Workbook.Worksheets[0] collection.
- Create an object of JsonLayoutOptions class to set additional options.
- Import data from JSON to CSV using JsonUtility.ImportData() method.
- Save the CSV file using Workbook.Save(string, SaveFormat.CSV) method.
The following code sample shows how to convert JSON data to CSV format.
JSON Data
The following is the JSON data that we used in the above code sample.
[{"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}]'Converted CSV
The following is the converted CSV file.
Get a Free License
Get a temporary license and use Aspose.Cells for .NET without evaluation limitations.
Conclusion
JSON and CSV files are widely used to store and exchange data within applications. Accordingly, this article covered how to convert JSON data or files to CSV using C#. Besides, you can also explore Aspose.Cells for .NET using the documentation. Also, you can ask your questions via our forum.
