Ever wondered how to make Microsoft Excel open UTF8 encoded CSVs properly? Me, too. The Problem Recently we had a problem with a client whereby their MySQL DB was UTF8, all controllers, models and views were UTF8, the Content-Transfer-Encoding was UTF8, but still Excel converted them to ISO Latin 1. The Solution The solution took me […]