Simon Willison’s Weblog


32 items tagged “csv”


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.

# 20th August 2008, 12:19 pm / byteordermark, csv, excel, i18n, internationalisation, python, stuart-langridge, unicode, unicodedictwriter, utf16


Guide to the Dabble DB Plugin API (via) This is really nice—Dabble POSTs your plugin script a bunch of CSV values, your script returns CSV for the derived fields. Doesn’t seem to state which flavour of CSV though.

# 9th January 2007, 11:37 am / api, chad-fowler, csv, dabbledb, plugins