HSBC Previous Statements converted to spreadsheet

MrMur

Hi,

I was frustrated by the fact that I couldn't download my previous statements into a spreadsheet format, so I wrote my own program to do it. I thought I would share it as it might be useful to other people (assuming I didn't miss how to do it an easier way).

If you are tech savvy, you can compile it yourself from the provided source, which I would recommend so you can assure yourself my code doesn't do anything untoward with your bank statements.

Unfortunately, you will need to be able to use the command line as I went for function over form. I've tested it on Ubuntu; it should work on Windows, etc.)

The idea is that you save your statements as html files into a folder and then this program produces a single CSV file of ALL of the statements which can be imported into LibreOffice or Excel for your further analysis. I advice sorting the first column, as the original file will not be in statement order.

Usage is:-
java -jar hsbcextract.jar <FolderNameToStatementHtml(s)> > HSBC.csv

e.g.

java -jar hsbcextract.jar c:\hsbcstatements > c:\HSBC.csv

I can't post the link, so I will ask a mod to do it for me.

Hope this is of help to someone.

EDIT: If you google "hsbcextract" as one word, then you will find it as the first entry, on GitHub.

You will need Java to run it.

MrMur

I forgot to say, you will need to have Java installed.