reference: https://stackoverflow.com/questions/46551955/python-3-csv-utf-8-encoding

with open('sample.csv', 'w', newline='', encoding='utf-8') as csvfile:
    csvfile.write('\ufeff')

do this at the start of csv writer to ad BOM


0 Comments

Leave a Reply

Your email address will not be published.