Reading CSV Files in Python: A Step-by-Step Guide

What a CSV file is and why Python reads them

A CSV file (comma-separated values) is a plain text document where each line is a row of data and commas separate the columns. Python can read these files because they are straightforward text — no special software needed. The most straightforward way is to use Python's built-in csv module, which handles the parsing for you so you do not have to split strings by hand.

CSV files are everywhere: spreadsheet exports, database dumps, survey results, sensor logs. When you read data from a website or receive it from another system, it often arrives as CSV. Python's csv module turns those rows and columns into data structures you can loop through, filter, or pass to other parts of your program.

Key Takeaways

The csv module is built into Python, so you import it at the top of your script with no installation needed.
csv.reader() turns each line into a list of values; csv.DictReader() turns each line into a dictionary with column names as keys.
Always open the file with open() and use a with statement so the file closes automatically when you are done.
The first row of your CSV file determines whether you use reader() or DictReader() — if row one contains headers, use DictReader().
Pandas is a separate library that loads CSV into a table-like structure, useful if you need to filter, sort, or do math on columns.

Using csv.reader() for straightforward row-by-row reading

Open your Python file and import the csv module at the top. Then open your CSV file using the open() function with a with statement. The with statement ensures Python closes the file automatically when you are finished, even if an error occurs.

Here is the basic structure:

import csv with open('data.csv') as file: reader = csv.reader(file) for row in reader: print(row)

Replace 'data.csv' with the actual filename. Each row is a list. If your file is in a different folder, include the path: 'folder/subfolder/data.csv' on Windows or Mac. When you run this code, each row prints as a list of strings: ['John', '28', 'Engineer']. You can access individual values by index — row[0] is the first column, row[1] is the second, and so on.

This approach works well when you have a small file or when you only need to read through the data once. If your CSV has no header row, or if the header is just a comment you want to skip, csv.reader() is the simplest choice.

Using csv.DictReader() when your file has column headers

If the first row of your CSV contains column names (like Name, Age, Job), use csv.DictReader() instead. It reads that first row as keys and turns each data row into a dictionary. This way you reference columns by name instead of by number.

import csv with open('data.csv') as file: reader = csv.DictReader(file) for row in reader: print(row['Name'], row['Age'])

Now each row is a dictionary. row['Name'] gives you the value in the Name column for that row. This is much clearer than row[0] because you can see exactly which column you are reading. If a column name has a space in it (like 'First Name'), use row['First Name'] — the space is part of the key.

DictReader() automatically skips the header row, so your loop only processes actual data. If your CSV does not have headers in the first row, DictReader() will treat the first data row as headers, which is usually wrong — use csv.reader() instead in that case.

Handling files in different locations and with different delimiters

If your CSV file is not in the same folder as your Python script, provide the full path. On Windows, use forward slashes or double backslashes: 'C:/Users/YourName/Documents/data.csv' or 'C:\\Users\\YourName\\Documents\\data.csv'. On Mac or Linux, use forward slashes: '/Users/YourName/Documents/data.csv'.

Some CSV files use semicolons or tabs instead of commas as separators. Tell the reader what delimiter to expect by adding the delimiter parameter:

reader = csv.reader(file, delimiter=';')

Or for tab-separated files:

reader = csv.reader(file, delimiter='\t')

If you are not sure what delimiter your file uses, open it in a text editor and look at the first line. You will see the separator between values. The csv module defaults to comma, so if your file uses commas, you do not need to specify delimiter at all.

Storing data in a list for later use

If you need to use the data after reading the file, store each row in a list instead of just printing it. This lets you loop through the data multiple times or pass it to other functions.

import csv data = [] with open('data.csv') as file: reader = csv.DictReader(file) for row in reader: data.append(row) for person in data: print(person['Name'])

The append() method adds each row to the data list. After the file closes, data contains all rows as dictionaries. You can now loop through it, filter it, or search it without reopening the file.

Be careful with very large files — storing everything in memory can slow your program down. For files with millions of rows, process one row at a time inside the with block instead of storing them all.

Using pandas for more complex operations

If you need to filter rows, sort by a column, or do calculations across columns, the pandas library is faster and clearer than the csv module. Pandas is not built in, so you install it first by running pip install pandas in your terminal or command prompt.

import pandas as pd df = pd.read_csv('data.csv') print(df)

This loads your entire CSV into a table-like structure called a DataFrame. You can then filter, sort, and manipulate it easily:

engineers = df[df['Job'] == 'Engineer'] sorted_by_age = df.sort_values('Age') average_age = df['Age'].mean()

Pandas is overkill for reading a straightforward CSV once, but it shines when you need to work with the data afterward. It also handles missing values, data type conversion, and large files more gracefully than the csv module.

Common mistakes and how to avoid them

The most common error is forgetting to import csv at the top of your file. If you see "NameError: name 'csv' is not defined", add import csv as the first line. Another frequent mistake is using the wrong filename or path — Python will raise "FileNotFoundError" if the file does not exist. Double-check the spelling and location.

If you use csv.DictReader() but your file has no headers, the first data row becomes the header keys, and you lose that data. Check your file first — open it in a text editor or spreadsheet program and confirm the first row contains column names.

Forgetting the with statement means the file stays open in memory. While Python eventually closes it, it is bad practice. Always use with open() so the file closes when ready. If you see strange characters or encoding errors, your file might use a different character encoding. Add encoding='utf-8' to the open() call: open('data.csv', encoding='utf-8').

Frequently Asked Questions

What is the difference between csv.reader() and csv.DictReader()?

csv.reader() returns each row as a list, so you access values by position: row[0], row[1]. csv.DictReader() returns each row as a dictionary, so you access values by column name: row['Name']. Use DictReader() if your file has headers; use reader() if it does not or if you prefer working with positions.

How do I skip the first few rows if they contain comments or metadata?

Open the file normally and loop through it, skipping rows manually. For example, skip the first two rows with a counter: skip = 0; for row in reader: if skip < 2: skip += 1; continue. Or use itertools.islice() to skip rows more cleanly. If you use DictReader(), it automatically skips the header, so you only need to skip additional rows.

Can I write data back to a CSV file after reading it?

Yes, use csv.writer(). Open the file in write mode ('w') and use writer.writerow() for a single row or writer.writerows() for multiple rows. Be careful — write mode overwrites the entire file. If you want to add rows to an existing file, open it in append mode ('a') instead.

What should I do if my CSV file is very large?

Do not store all rows in memory. Instead, process one row at a time inside the with block. If you need to filter or sort, use pandas with the chunksize parameter to read the file in smaller pieces, or use a database instead of CSV for very large datasets.

Why am I getting encoding errors when I read the file?

Your file uses a character encoding that is not UTF-8. Add the encoding parameter: open('data.csv', encoding='latin-1') or encoding='cp1252'. If you are not sure which encoding, try 'latin-1' first — it handles most Western text. You can also open the file in a text editor and check its encoding in the settings.

This guide is for general information only and is not medical, financial, legal, or other professional advice. For decisions specific to your situation, consult a qualified professional. See our Editorial Policy.