Next
1. Read File2. Write File3. Append to File4. Read CSV File5. Write CSV File6. JSON Read7. JSON Write8. File Copy9. File Rename10. Read Binary File11. Write Binary File12. Count Words in File13. Count Lines in File14. Count Characters in File15. Search Substring in File16. Iterate File Lines17. File Metadata18. File Compression19. File Decompression20. Delete File

Read CSV File in Python

Read a CSV file and print each row using the csv module.

BeginnerFile Handling ProgramsExample 4 of 20
read-csv-file.py
Run in browser
1# Program to read a CSV file
2

3import csv
4

5filename = input("Enter CSV filename: ")
6

7try:
8    with open(filename, newline="", encoding="utf-8") as f:
9        reader = csv.reader(f)
10        for row in reader:
11            print(row)
12except FileNotFoundError:
13    print("CSV file not found.")

Output

Enter CSV filename: data.csv
['name', 'age']
['Alice', '25']
['Bob', '30']

What's going on

Uses csv.reader to parse comma-separated values into Python lists per row.

PreviousAppend to FileNextWrite CSV File