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

We're going to need default hard budget caps on pretty much everything - 3rd October 2026
OpenAI DevDay 2026 live blog - 29th September 2026
2026 in LLMs (so far) - 27th September 2026

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

byteordermark 1 csv 33 excel 5 i18n 14 python 1,284 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