JSON is a well-known and widely used format to keep and share structured data. Often, it is used to transmit data between different types of applications. CSV, on the other hand, is also used to store the data in a comma-separated format. In certain cases, you may need to import data from JSON files to CSV programmatically in Python applications. Therefore, in this article, you will learn how to convert JSON files to CSV in Python.
- Python JSON to CSV Converter - Free Download
- Steps to Convert JSON to CSV in Python
- Convert JSON Data or File to CSV
JSON to CSV Python Converter - Free Download
To convert JSON data to CSV format, we will use Aspose.Cells for Python. It is a powerful API for creating, modifying, and converting spreadsheet files using Python. You can either download the API or install it using the following pip command.
pip install aspose-cells
How to Convert JSON to CSV in Python
Aspose.Cells provides a high-speed and high-fidelity conversion of JSON files to CSV format in Python. The following are the steps to convert the JSON to CSV format using the API.
- Create a new Excel workbook and select the desired worksheet.
- Import Data from JSON to Excel worksheet.
- Save Excel workbook in CSV format.
Now, let’s have a look at how to perform these steps for JSON to CSV conversion in Python.
Convert JSON to CSV in Python
The following are the steps to convert JSON to CSV in Python.
- Create a new Workbook object.
- Get a reference of the first worksheet using Workbook.getWorksheets().get(0) method.
- 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 Python.
Input 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}]'
JSON to CSV
The following is the converted CSV file.
Export JSON to CSV in Python - Get a Free License
Get a free temporary license and export JSON data to CSV format without evaluation limitations.
Python JSON to CSV Converter - Read More
You can also explore Aspose.Cells for Python using the documentation. Also, you can ask your questions via our forum.
Conclusion
JSON and CSV files are widely used to store and transmit data. In accordance, this article covered how to convert JSON to CSV in Python. You can simply install the library, integrate the provided code, and export JSON data to CSV in Python.