Simon Willison’s Weblog

20th August 2008 - Link Blog

UnicodeDictWriter - write unicode strings out to Excel compatible CSV files using Python. Stuart Langridge and I spent quite a while this morning battling with Excel. The magic combination for storing unicode text in a CSV file such that Excel correctly reads it is UTF-16, a byte order mark and tab delimiters rather than commas.

Posted 20th August 2008 at 12:19 pm

Recent articles

Datasette Agent - 21st May 2026
Gemini 3.5 Flash: more expensive, but Google plan to use it for everything - 19th May 2026
The last six months in LLMs in five minutes - 19th May 2026

This is a link post by Simon Willison, posted on 20th August 2008.

byteordermark 1 csv 32 excel 5 i18n 14 python 1250 stuart-langridge 26 unicode 35 unicodedictwriter 1 utf16 1

Monthly briefing

Sponsor me for $10/month and get a curated email digest of the month's most important LLM developments.

Pay me to send you less!

Sponsor & subscribe