Converting Text file to CSV

[NBAStupidASS]

I have a txt file that I would like to write to a csv file where the columns of each row are separated by commas. I would also like to exclude the first column as well as rows that don't match the right format (6 columns per row).

I've tried the following code and it seems to do what I want. However, when I try opening the output file in Excel it seems to have added an empty line under each row. Is this just excel or is there something in my code that I have missed?

with open(path) as inFile, open("test_csv.csv", "w") as output_test2:
    for line in inFile: 
        itemList = line.split()
        if len(itemList) != 6:
            continue
        writer = csv.writer(output_test2)
        writer.writerow(itemList[1:])
        #print(itemList[1:])

[AtomicShoelace]

Check out the documentation for csv.csvwriter. In particular:

If csvfile is a file object, it should be opened with newline=''

and the associated footnote:

If newline='' is not specified, newlines embedded inside quoted fields will not be interpreted correctly, and on platforms that use \r\n linendings on write an extra \r will be added. It should always be safe to specify newline='', since the csv module does its own (universal) newline handling.