(CkPython) Write utf-8 CSV Compatible with Excel

See more CSV Examples

A CSV containing non-English characters that is saved using the utf-8 character encoding must include a BOM (also known as a preamble) if it is to be correctly loaded into Excel. See https://en.wikipedia.org/wiki/Byte_order_mark

This example shows how to save the CSV to a file using utf-8 with a BOM.

Note: This example requires Chilkat v9.5.0.93 or later.

Chilkat Python Downloads install with pip pip3 install chilkat or download... Python Module for Windows, MacOS, Linux, Alpine Linux, Solaris

import sys
import chilkat

# This example program loads a file (japanese.csv)
# that contains this content:
# 
# year,color,country,food
# 2001,red,France,cheese
# 2005,blue,"United States",hamburger
# 2008,green,Italy,pasta
# 1998,orange,Japan,sushi
# 2010,silver,"",""
# 

csv = chilkat.CkCsv()
csv.put_HasColumnNames(True)
success = csv.LoadFile2("qa_data/csv/test.csv","utf-8")
if (success != True):
    print(csv.lastErrorText())
    sys.exit()

# To save the CSV using utf-8 with a BOM/preamble, 
# add "EMIT_BOM" to the UncommonOptions.
# (This feature was added in Chilkat v9.5.0.93)

csv.put_UncommonOptions("EMIT_BOM")
success = csv.SaveFile2("qa_output/test.csv","utf-8")
if (success != True):
    print(csv.lastErrorText())
    sys.exit()

print("OK, try to load the CSV in Excel to see if the non-English chars are correct.")