Most dedicated XML editors also contain a special HTML to XML conversion tool that should help you with translating HTML to XML code. One of such software is for example XML:Wrench, but text editors like Sublime Text might be enough for your purposes.
This is often used to transfer tables saved in .html files to .xml based format. With a little copy and paste, you can do the same with Excel or other spreadsheet editor.
Open HTM file Open XML file