GitHub

Excel forumlae for encoding/decoding UTF-8 codepoints

Here are 2 formulae to aid in working with UTF-8. 1 converts a code point into a UTF-8 hex string and the other converts a UTF-8 hex string into a code point. I often find myself using a spreadsheet ...
Houston Chronicle

UTF-8 Encoding for Excel Using Java

Typically, using standard formats when programming can help you migrate information between different programs. Using the Comma Separated Value file format, for example, lets you create lists of data ...
GitHub

SAS macro with Python script to import Excel spreadsheet and avoid SAS import errors due to extra newlines and non-UTF-8 characters

Excel is Unicode by default and allows newlines in cells. SAS will generate errors when importing non-UTF-8 Unicode and newlines in cells. This solution is for when the SAS program must not fail and ...
Ars Technica

Help me get UTF-8 from Excel into MySQL

Howdy fellows!<BR><BR>I have an .XLS file containing a bunch of names, some of which have non-standard characters in them (accents over the "o", stuff like that). I would very much like to get this ...