Openpyxl Unicode Values

It looks like either openpyxl or Excel is encoding carriage returns (\r, ASCII 0Dh) in that manner. You can convert them back or split on them as well:

>>> s=u'Test1_x000D_\nTest2_x000D_\nTest3_x000D_'
>>> s.split('_x000D_\n')
[u'Test1', u'Test2', u'Test3_x000D_']     # This misses the final one.
>>> s.replace('_x000D_','').splitlines()  # Better...
[u'Test1', u'Test2', u'Test3']