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
A popular spreadsheet application distributed with Microsoft Office suite
XML integrated development environment
A sophisticated Linux source code editor for programmers
A sophisticated Mac source code editor for programmers
Integrated development tool and source code editor for Windows, Mac and Linux