The resulting CSV file data.csv will look like this: id,name,age,department 1,John Doe,30,IT 2,Jane Smith,35,Marketing 3,Bob Johnson,40,Sales For each employee in the JSON data, we get the values of the dictionary using the values() method and pass them as a list to the writer.writerow() method.įinally, we close the CSV file using the close() method.

We write the data rows to the CSV file using a for loop. We write the header row to the CSV file using the writer.writerow() method and passing the keys of the first employee in the JSON data as a list. We also set the newline parameter to an empty string to avoid issues with line endings. We open a new CSV file data.csv in write mode using the open() function and the csv.writer() method. We load the JSON data from the file data.json using the json.load() method and store it in the variable data. We start by importing the json and csv modules. Here is the Python code to convert the above JSON data to CSV format: import json import csv # Load JSON data with open('data.json') as f: data = json.load(f) # Open CSV file for writing with open('data.csv', 'w', newline='') as f: writer = csv.writer(f) # Write header row writer.writerow(data.keys()) # Write data rows for employee in data: writer.writerow(employee.values()) Then, we can open a CSV file using the csv.writer() method and write the header row and data rows to the CSV file.

We will use the built-in json and csv modules in Python to convert this JSON data to CSV format.įirst, we need to load the JSON data into a Python dictionary using the json.loads() method. In this article, we will discuss how to convert JSON data to CSV format using Python.Įxample JSON data: JSON is commonly used for data exchange between client and server applications, while CSV is widely used for storing and exchanging tabular data. JSON (JavaScript Object Notation) and CSV (Comma Separated Values) are two popular file formats used for storing and exchanging data.

Converting json to csv python