JSON (JavaScript Object Notation) and CSV (Comma-Separated Values) are two widely used data formats for storing and exchanging data. There are many scenarios where you might need to convert JSON data into CSV format. In this article, you will learn how to convert JSON data to CSV in C#.
- C# JSON to CSV Converter
- Steps to Convert JSON to CSV
- Convert JSON Data or File to CSV
- Convert JSON to CSV Online
C# Library to Convert JSON to CSV
Aspose.Cells for .NET and feature-rich library for working with Excel files in C#. It provides comprehensive support for creating, manipulating, and converting Excel files, but it can also be used for working with other data formats, including CSV and JSON. You can either download the API or install it using NuGet.
PM> Install-Package Aspose.Cells
Steps to Convert JSON to CSV
Aspose.Cells for .NET provides the easiest way of converting JSON files to CSV format. Below are the steps to perform this conversion.
- Create a new Excel file.
- Read data from JSON file.
- Import JSON data into the Excel file and save it in CSV format.
Let’s now write the C# code to convert a JSON file to CSV format.
Convert JSON Data to CSV in C#
The following are the steps to convert JSON data to CSV format in C#.
- Create a new Workbook object.
- Get a 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 export JSON data to CSV in C#.
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.
Convert JSON to CSV Online
Use our free online JSON to CSV converter and transform your JSON data into comma separated values.
Free JSON Data to CSV Converter
Get a free temporary license and export JSON files to CSV format without evaluation limitations.
You can also explore Aspose.Cells for .NET using the documentation. Also, you can ask your questions via our forum.
Conclusion
Converting JSON data to CSV in C# with Aspose.Cells for .NET is a straightforward process, thanks to the powerful features and capabilities of the library. Aspose.Cells simplifies the handling of Excel files and other data formats, making it a valuable tool for data manipulation in .NET applications. Whether you are working with JSON, Excel, CSV, or other data formats, Aspose.Cells can help you efficiently accomplish your tasks. Simply follow the guidelines provided in this blog and convert JSON data to CSV in your .NET applications.