The file comes out as a tilde delimited file, it needs to be edited to become a CSV.
This is what I used to get a successful upload, with a little manual work in there as well.
import pandas as pd
df = pd.read_csv('File from Unix Name', sep='~')
df.to_csv('output file name.csv', index=False)
I then had to drop the column that remained on the end of the file, but after that it was good to upload.