http://simonwillison.net/2008-08-20T12:19:59+00:00Simon Willison2008-08-20T12:19:59+00:002008-08-20T12:19:59+00:00https://simonwillison.net/2008/Aug/20/excel/#atom-tag

<p><strong><a href="http://www.djangosnippets.org/snippets/993/">UnicodeDictWriter - write unicode strings out to Excel compatible CSV files using Python</a></strong></p> 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. <p>Tags: <a href="https://simonwillison.net/tags/byteordermark">byteordermark</a>, <a href="https://simonwillison.net/tags/csv">csv</a>, <a href="https://simonwillison.net/tags/excel">excel</a>, <a href="https://simonwillison.net/tags/i18n">i18n</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/stuart-langridge">stuart-langridge</a>, <a href="https://simonwillison.net/tags/unicode">unicode</a>, <a href="https://simonwillison.net/tags/unicodedictwriter">unicodedictwriter</a>, <a href="https://simonwillison.net/tags/utf16">utf16</a></p>