Working with CSV and JSON Files: Complete Guide for Beginners

Modern applications constantly exchange and store structured data. Two of the most widely used file formats for this purpose are CSV (Comma-Separated Values) and JSON (JavaScript Object Notation). Python provides built-in modules that make it easy to read, write, and process these files.

CSV files are commonly used to store tabular data such as student records, sales reports, and datasets. JSON files are widely used for APIs, configuration files, web applications, and data exchange because they can represent complex hierarchical data.

Whether you are working in data analytics, web development, automation, or machine learning, understanding CSV and JSON files is an essential Python skill.

In this lesson, you will learn what CSV and JSON files are, why they are important, compare their features, import Python’s built-in modules, and explore their real-world applications.

Learning Objectives

After completing this lesson, you will be able to:

• Understand CSV and JSON files.
• Differentiate between CSV and JSON.
• Import the csv and json modules.
• Identify common applications of CSV and JSON.
• Choose the appropriate file format for different situations.
• Avoid common beginner mistakes.

What is a CSV File?

CSV (Comma-Separated Values) is a simple text file format used to store tabular data. Each row represents one record, and commas separate individual values.

Example of a CSV file:

Name,Course,Marks
Rahul,Python,92
Priya,Data Analytics,95
Amit,SQL,88

CSV files are widely supported by spreadsheet software such as Microsoft Excel, Google Sheets, and many database systems.

Characteristics of CSV Files

• Stores tabular data.
• Easy to create and edit.
• Human-readable.
• Small file size.
• Supported by almost every programming language.

What is a JSON File?

JSON (JavaScript Object Notation) is a lightweight data-interchange format used to represent structured information as key-value pairs.

Example of a JSON file:

{
    "name": "Rahul",
    "course": "Python",
    "marks": 92
}

JSON is widely used in web applications, REST APIs, cloud services, mobile applications, and configuration files.

Characteristics of JSON Files

• Stores structured data.
• Uses key-value pairs.
• Supports nested objects and arrays.
• Human-readable.
• Ideal for data exchange.

Why are CSV and JSON Important?

CSV and JSON files allow different applications and systems to exchange data efficiently.

For example:

• A school exports student records as CSV files.
• A website receives customer information in JSON format.
• A machine learning model loads CSV datasets.
• A mobile application communicates with a server using JSON.

CSV vs JSON Comparison

Feature	CSV	JSON
Data Format	Rows and Columns	Key-Value Pairs
Supports Nested Data	No	Yes
Human Readable	Yes	Yes
Common Usage	Datasets, Reports	APIs, Web Applications
Best For	Tabular Data	Structured Data
File Extension	.csv	.json

Importing the CSV Module

Python provides the built-in csv module for working with CSV files.

Syntax

import csv

No installation is required because the module is included with Python.

Importing the JSON Module

Python provides the built-in json module for working with JSON data.

Syntax

import json

The json module is also part of Python’s standard library.

Real-World Applications

Application	CSV	JSON
Student Records	✔	✔
Sales Reports	✔
REST APIs		✔
Machine Learning Datasets	✔
Configuration Files		✔
Web Applications		✔

Practical Example

import csv
import json

print("CSV Module Imported Successfully")

print("JSON Module Imported Successfully")

Output

CSV Module Imported Successfully

JSON Module Imported Successfully

Execution Flow

Consider the following program.

import csv

import json

print("Modules Loaded")

Execution Steps

1. Python imports the csv module.
2. Python imports the json module.
3. Both modules become available for use.
4. The confirmation message is displayed.

Output

Modules Loaded

Common Beginner Mistakes

• Confusing CSV files with Excel (.xlsx) files.
• Using CSV for storing complex nested data.
• Using JSON when simple tabular data is sufficient.
• Assuming JSON stores only text instead of structured objects.
• Trying to install the csv or json modules using pip, even though they are built into Python.

Chunk Summary

In this section, you learned what CSV and JSON files are, their characteristics, differences, and real-world applications. You also learned how to import Python’s built-in csv and json modules and understand when each file format should be used. In the next section, you will learn how to read and write CSV files using csv.reader() and csv.writer(), write multiple rows, work with different delimiters, and apply CSV processing in practical Python programs.

In the previous section, you learned what CSV files are, why they are important, and how Python provides the built-in csv module for working with them. CSV files are one of the most common formats used in data analytics, reporting systems, and spreadsheet applications because they store tabular data in a simple, readable format.

In this section, you will learn how to read CSV files using csv.reader(), write data using csv.writer(), write multiple rows, work with different delimiters, and apply these techniques in practical Python programs.

Reading CSV Files

Python uses the csv.reader() function to read data from CSV files.

Suppose students.csv contains:

Name,Course,Marks
Rahul,Python,92
Priya,Data Analytics,95
Amit,SQL,88

Example

import csv

file = open("students.csv", "r")

reader = csv.reader(file)

for row in reader:
    print(row)

file.close()

Output

['Name', 'Course', 'Marks']
['Rahul', 'Python', '92']
['Priya', 'Data Analytics', '95']
['Amit', 'SQL', '88']

Each row is returned as a list.

Skipping the Header Row

Most CSV files contain a header. You can skip it using the next() function.

import csv

file = open("students.csv", "r")

reader = csv.reader(file)

next(reader)

for row in reader:
    print(row)

file.close()

Output

['Rahul', 'Python', '92']
['Priya', 'Data Analytics', '95']
['Amit', 'SQL', '88']

Writing CSV Files

The csv.writer() function writes data into CSV files.

Example

import csv

file = open("employees.csv", "w", newline="")

writer = csv.writer(file)

writer.writerow(["Name", "Department", "Salary"])

writer.writerow(["Neha", "HR", 50000])

file.close()

Contents of employees.csv

Name,Department,Salary
Neha,HR,50000

Writing Multiple Rows

The writerows() method writes multiple records at once.

import csv

rows = [
    ["Name", "Course", "Marks"],
    ["Rahul", "Python", 92],
    ["Priya", "Data Analytics", 95],
    ["Amit", "SQL", 88]
]

file = open("students.csv", "w", newline="")

writer = csv.writer(file)

writer.writerows(rows)

file.close()

Contents of students.csv

Name,Course,Marks
Rahul,Python,92
Priya,Data Analytics,95
Amit,SQL,88

Understanding the newline="" Parameter

When writing CSV files, it is recommended to use newline="". This prevents extra blank lines from appearing in the output file, especially on Windows systems.

file = open("students.csv", "w", newline="")

Working with Different Delimiters

Although commas are the default separator, CSV files can also use other delimiters such as semicolons or tabs.

Example Using Semicolon

import csv

file = open("students.csv", "w", newline="")

writer = csv.writer(file, delimiter=";")

writer.writerow(["Name", "Marks"])

writer.writerow(["Rahul", 92])

file.close()

Contents of students.csv

Name;Marks
Rahul;92

Practical Example 1: Student Database

import csv

rows = [
    ["Roll No", "Name", "Course"],
    [101, "Rahul", "Python"],
    [102, "Priya", "SQL"]
]

file = open("student_database.csv", "w", newline="")

writer = csv.writer(file)

writer.writerows(rows)

file.close()

print("Student Database Created")

Output

Student Database Created

Practical Example 2: Sales Report

import csv

file = open("sales.csv", "w", newline="")

writer = csv.writer(file)

writer.writerow(["Product", "Quantity", "Amount"])

writer.writerow(["Laptop", 5, 275000])

writer.writerow(["Mouse", 20, 16000])

file.close()

Contents of sales.csv

Product,Quantity,Amount
Laptop,5,275000
Mouse,20,16000

Best Practices

• Always import the csv module before working with CSV files.
• Use newline="" while writing CSV files.
• Use next() to skip header rows when needed.
• Use writerows() when writing multiple records.
• Close the file after completing operations.

Execution Flow

Consider the following program.

import csv

file = open("students.csv", "r")

reader = csv.reader(file)

for row in reader:
    print(row)

file.close()

Execution Steps

1. Python imports the csv module.
2. The CSV file is opened in read mode.
3. csv.reader() creates a reader object.
4. The for loop reads one row at a time.
5. Each row is returned as a list and displayed.
6. The file is closed.

Output

['Name', 'Course', 'Marks']
['Rahul', 'Python', '92']
['Priya', 'Data Analytics', '95']
['Amit', 'SQL', '88']

Common Beginner Mistakes

• Forgetting to import the csv module.
• Not using newline="" when writing CSV files.
• Confusing writerow() with writerows().
• Trying to process the header row as actual data.
• Using the wrong delimiter while reading or writing CSV files.

Chunk Summary

In this section, you learned how to read CSV files using csv.reader(), write records using csv.writer(), create multiple records using writerows(), skip header rows, and work with custom delimiters. You also explored practical examples, best practices, execution flow, and common beginner mistakes. In the next section, you will learn how to work with JSON files using the json module, including json.load(), json.dump(), converting Python dictionaries to JSON, pretty-printing JSON data, and handling structured data efficiently.

In the previous section, you learned how to read and write CSV files using Python’s csv module. While CSV files are ideal for storing tabular data, many modern applications require a more flexible format that supports nested structures and key-value pairs. This is where JSON (JavaScript Object Notation) becomes extremely useful.

JSON is one of the most widely used data formats in web development, REST APIs, cloud applications, mobile apps, and configuration files. Python provides the built-in json module to easily read, write, and manipulate JSON data.

In this section, you will learn how to read JSON files, write JSON files, convert Python dictionaries to JSON, format JSON output, and explore practical real-world applications.

Reading JSON Files

Python reads JSON files using the json.load() function.

Suppose student.json contains:

{
    "name": "Rahul",
    "course": "Python",
    "marks": 92
}

Example

import json

file = open("student.json", "r")

student = json.load(file)

print(student)

file.close()

Output

{'name': 'Rahul', 'course': 'Python', 'marks': 92}

The JSON data is converted into a Python dictionary.

Accessing JSON Values

After loading a JSON file, you can access values using dictionary keys.

import json

file = open("student.json", "r")

student = json.load(file)

print(student["name"])

print(student["marks"])

file.close()

Output

Rahul

92

Writing JSON Files

The json.dump() function writes Python objects into a JSON file.

Example

import json

student = {
    "name": "Priya",
    "course": "Data Analytics",
    "marks": 95
}

file = open("student.json", "w")

json.dump(student, file)

file.close()

Contents of student.json

{"name": "Priya", "course": "Data Analytics", "marks": 95}

Writing Pretty JSON

For better readability, use the indent parameter.

import json

student = {
    "name": "Priya",
    "course": "Data Analytics",
    "marks": 95
}

file = open("student.json", "w")

json.dump(student, file, indent=4)

file.close()

Contents of student.json

{
    "name": "Priya",
    "course": "Data Analytics",
    "marks": 95
}

Converting a Python Dictionary to JSON

The json.dumps() function converts a Python object into a JSON-formatted string.

Example

import json

student = {
    "name": "Rahul",
    "marks": 92
}

json_data = json.dumps(student)

print(json_data)

Output

{"name": "Rahul", "marks": 92}

Notice that dumps() returns a string instead of writing to a file.

Converting JSON to a Python Dictionary

The json.loads() function converts a JSON string into a Python dictionary.

Example

import json

json_text = '{"name":"Rahul","marks":92}'

student = json.loads(json_text)

print(student)

Output

{'name': 'Rahul', 'marks': 92}

Practical Example 1: Employee Database

import json

employee = {
    "id": 101,
    "name": "Neha",
    "department": "HR"
}

file = open("employee.json", "w")

json.dump(employee, file, indent=4)

file.close()

print("Employee Record Saved")

Output

Employee Record Saved

Practical Example 2: Reading Configuration Data

Suppose config.json contains:

{
    "theme": "dark",
    "language": "English"
}

import json

file = open("config.json", "r")

config = json.load(file)

print(config["theme"])

file.close()

Output

dark

Performance Tips

• Use json.load() for reading JSON files.
• Use json.dump() for writing JSON files.
• Use indent=4 for readable JSON output.
• Store structured data in JSON instead of CSV.
• Close files immediately after reading or writing.

Real-World Applications

Application	Purpose
REST APIs	Exchange data between client and server.
Web Applications	Store configuration settings.
Mobile Apps	Transfer structured information.
Cloud Services	Store application configurations.
Machine Learning	Save model settings.
Data Analytics	Store hierarchical datasets.

Execution Flow

Consider the following program.

import json

file = open("student.json", "r")

student = json.load(file)

print(student["name"])

file.close()

Execution Steps

1. Python imports the json module.
2. The JSON file is opened.
3. json.load() converts JSON into a Python dictionary.
4. The value associated with the name key is accessed.
5. The result is displayed.
6. The file is closed.

Output

Rahul

Common Beginner Mistakes

• Confusing json.load() with json.loads().
• Confusing json.dump() with json.dumps().
• Forgetting to import the json module.
• Writing invalid JSON syntax.
• Trying to access a key that does not exist.

Chunk Summary

In this section, you learned how to read JSON files using json.load(), write JSON files using json.dump(), convert Python dictionaries to JSON strings with json.dumps(), and convert JSON strings back into Python objects using json.loads(). You also explored pretty-printing JSON, practical examples, performance tips, execution flow, and common beginner mistakes. In the final section, you will review the complete lesson through a lesson summary, key takeaways, FAQs, coding exercises, interview questions, a mini project, and a preview of the next lesson on File Paths, Directories, and OS Module.

Lesson Summary

In this lesson, you learned how to work with two of the most commonly used file formats in Python: CSV (Comma-Separated Values) and JSON (JavaScript Object Notation). These formats are widely used for storing, exchanging, and processing structured data in modern software applications.

You began by understanding what CSV and JSON files are, their characteristics, and the differences between them. You learned that CSV files are ideal for storing tabular data such as spreadsheets and datasets, while JSON files are better suited for structured and hierarchical data used in APIs and web applications.

Next, you explored Python’s built-in csv module to read and write CSV files using csv.reader(), csv.writer(), writerow(), and writerows(). You also learned how to skip header rows and use different delimiters.

Finally, you learned how to work with JSON files using Python’s json module. You used json.load() and json.dump() to read and write JSON files, explored json.loads() and json.dumps() for string conversion, and learned how to create readable JSON using the indent parameter.

These skills are essential for data analytics, machine learning, web development, automation, cloud computing, and software engineering, where exchanging structured data is a common requirement.

Key Takeaways

• CSV files store tabular data in rows and columns.
• JSON files store structured data using key-value pairs.
• Use the csv module to read and write CSV files.
• Use csv.reader() to read CSV records.
• Use csv.writer(), writerow(), and writerows() to create CSV files.
• Use the json module to process JSON data.
• json.load() reads JSON files into Python objects.
• json.dump() writes Python objects to JSON files.
• json.loads() and json.dumps() work with JSON strings.
• Use indent=4 to create readable JSON files.

Frequently Asked Questions (FAQs)

1. What does CSV stand for?

CSV stands for Comma-Separated Values.

2. What is JSON?

JSON (JavaScript Object Notation) is a lightweight format for storing and exchanging structured data.

3. Which module is used for CSV files?

The built-in csv module.

4. Which module is used for JSON files?

The built-in json module.

5. What does csv.reader() return?

It returns each row of a CSV file as a list.

6. What is the difference between writerow() and writerows()?

writerow() writes a single row, while writerows() writes multiple rows.

7. What does json.load() do?

It reads a JSON file and converts it into a Python object.

8. What does json.dump() do?

It writes a Python object into a JSON file.

9. Why should indent=4 be used?

It formats JSON data to make it easier for humans to read.

10. When should JSON be preferred over CSV?

Use JSON when working with nested, hierarchical, or API-based data structures.

Coding Exercises

1. Create a CSV file containing student records.
2. Read and display all records from a CSV file.
3. Skip the header row while reading a CSV file.
4. Write multiple rows to a CSV file using writerows().
5. Create a CSV file using a semicolon (;) delimiter.
6. Create a JSON file containing employee information.
7. Read a JSON file and display a specific value.
8. Convert a Python dictionary into a JSON string using json.dumps().
9. Convert a JSON string into a Python dictionary using json.loads().
10. Create a formatted JSON file using indent=4.

Interview Questions

1. What is the difference between CSV and JSON?
2. When should you use CSV instead of JSON?
3. Explain the purpose of the csv module.
4. What is the difference between writerow() and writerows()?
5. Why is newline="" recommended while writing CSV files?
6. Explain the difference between json.load() and json.loads().
7. Explain the difference between json.dump() and json.dumps().
8. How can you make JSON output more readable?
9. Why is JSON widely used in REST APIs?
10. What are the advantages of using JSON over CSV?

Mini Project: Student Data Manager using CSV & JSON

Create a Python application that stores and retrieves student information using both CSV and JSON files.

Your program should:

• Accept student details such as ID, name, course, and marks.
• Save all records in a CSV file.
• Create a JSON file containing the same student information.
• Read and display records from both files.
• Allow users to add new student records.
• Display the total number of students stored.
• Handle file-related errors using try and except.

Sample Output

========== STUDENT DATA MANAGER ==========

1. Add Student

2. View CSV Records

3. View JSON Records

4. Exit

Enter Student ID : 101

Enter Name : Rahul

Enter Course : Python

Enter Marks : 92

Record Saved Successfully

------------------------------------------

CSV Records

101,Rahul,Python,92

------------------------------------------

JSON Records

{
    "id": 101,
    "name": "Rahul",
    "course": "Python",
    "marks": 92
}

==========================================

What’s Next?

Congratulations! You have learned how to work with CSV and JSON files in Python. You now understand how to read and write structured data using Python’s built-in csv and json modules, making you ready to handle real-world datasets and API responses.

In the next lesson, you will learn File Paths, Directories, and the OS Module: Complete Guide for Beginners. You will explore how to work with folders, navigate directories, create and delete directories, manage file paths, and use Python’s powerful os and os.path modules for file system operations.