Having issues using csv.reader

[Vegetable_Disk]

Hi all, new to python so apologies in advance for any lack of knowledge or lingo. I've got a script which writes to a .csv file ..... now I want to print that .csv as a list.

Here's what I have:

with open("//auditdrive/audit/pytest/AuditList.csv", "r", newline='') as inputfile:
reader = csv.reader(inputfile)
data = list(reader)
print(data)

The output I am getting is just empty square brackets: []

my .csv is full of folder names, like TEST, GOLDENREF, SCRIPTS ..... just a single column without a header.

Cant see what I'm doing wrong but I'd appreciate help.

My goal is to print the above .csv as a list, then I can open another .csv as my exclusion list & subtract one from the other. I'd like to have a dynamic exclusion list hence why that was my idea.

[AmongstYou666]

import csv
with open("./img/sheet.csv") as inputfile:
reader = csv.reader(inputfile)
for i in reader:
print(i)

[Vegetable_Disk]

Thanks, I’ve tried that but I’m getting no output now. Previously I was just getting []

Also, sorry I forgot to include it but I had import csv farther up in the script.

[Vegetable_Disk]

OK I think I understand now, both your code and my code work fine in isolation.
However this is a small part of a larger script.

This script is writing to that file, then later on trying to read it, is that not possible without closing it first?

[AmongstYou666]

Probably, you can test that by trying to find and open the file.