How to write UTF-8 in a CSV file

by

It’s very simple for Python 3.x (docs).

import csv

with open('output_file_name', 'w', newline="", encoding='utf-8') as csv_file:
    writer = csv.writer(csv_file, delimiter=";")
    writer.writerow('my_utf8_string')

For Python 2.x, look here.

More Related Contents:

  1. ‘utf-8’ codec can’t decode byte 0xa0 in position 4276: invalid start byte
  2. Python 3 CSV file giving UnicodeDecodeError: ‘utf-8’ codec can’t decode byte error when I print
  3. Changing default encoding of Python?
  4. Why should we NOT use sys.setdefaultencoding(“utf-8”) in a py script?
  5. Working with UTF-8 encoding in Python source [duplicate]
  6. Reading a UTF8 CSV file with Python
  7. Url decode UTF-8 in Python
  8. How to convert a file to utf-8 in Python?
  9. Dangers of sys.setdefaultencoding(‘utf-8’)
  10. How do I check if a string is unicode or ascii?
  11. General Unicode/UTF-8 support for csv files in Python 2.6
  12. How to print UTF-8 encoded text to the console in Python < 3?
  13. Why doesn’t Python recognize my utf-8 encoded source file?
  14. Why declare unicode by string in python?
  15. Should I use encoding declaration in Python 3?
  16. Python ascii utf unicode
  17. Loading UTF-8 file in Python 3 using numpy.genfromtxt
  18. Python DictWriter writing UTF-8 encoded CSV files
  19. ElementTree and unicode
  20. UnicodeDecodeError: ‘ascii’ codec can’t decode byte 0xc3 in position 23: ordinal not in range(128)
  21. Why does this Python program send empty emails when I encode it with utf-8? [duplicate]
  22. Changing the “locale preferred encoding” in Python 3 in Windows
  23. Convert “\x” escaped string into readable string in python
  24. python encoding utf-8
  25. Python – dealing with mixed-encoding files
  26. UnicodeDecodeError when performing os.walk
  27. Pandas df.to_csv(“file.csv” encode=”utf-8″) still gives trash characters for minus sign
  28. u’\ufeff’ in Python string
  29. How to do row-to-column transposition of data in csv table?
  30. Row count in a csv file

Leave a Comment