python – CSV new-line character seen in unquoted field error

python – CSV new-line character seen in unquoted field error

Itll be good to see the csv file itself, but this might work for you, give it a try, replace:

file_read = csv.reader(self.file)

with:

file_read = csv.reader(self.file, dialect=csv.excel_tab)

Or, open a file with universal newline mode and pass it to csv.reader, like:

reader = csv.reader(open(self.file, rU), dialect=csv.excel_tab)

Or, use splitlines(), like this:

def read_file(self):
    with open(self.file, r) as f:
        data = [row for row in csv.reader(f.read().splitlines())]
    return data

I realize this is an old post, but I ran into the same problem and dont see the correct answer so I will give it a try

Python Error:

_csv.Error: new-line character seen in unquoted field

Caused by trying to read Macintosh (pre OS X formatted) CSV files. These are text files that use CR for end of line. If using MS Office make sure you select either plain CSV format or CSV (MS-DOS). Do not use CSV (Macintosh) as save-as type.

My preferred EOL version would be LF (Unix/Linux/Apple), but I dont think MS Office provides the option to save in this format.

python – CSV new-line character seen in unquoted field error

For Mac OS X, save your CSV file in Windows Comma Separated (.csv) format.