I recently opened a new business account with Santander UK, and was generally finding the experience not too terrible until I decided to export my transaction history.
Somewhat surprisingly, not only do they not offer CSV export, but when you select XLS what you in fact receive is a rather dodgy HTML file, containing your data in a terrible HTML table. Whoops.
Even worse, this problem has been going on a while…
Since Santander didn’t seem interested in resolving this, I took the obvious next step and bitched about the issue on Twitter. Once done, I then wrote a script to fix it. Enjoy.