Building a bot using rest web services

Hello community, I am to building a bot where I must use REST web services, when I use this package the information comes in HTML format, so, how can I convert it into XML format and then transfer it to an Excel file. Example: “ <td>Hilary</td><td>Freeberne</td><td>hfreeberne5g@un.org</td><td>RothIRA</td><td>2865739058</td><td>$33377.28</td></tr><tr class='data'><td>2084</td><td>Marvin</td><td>Mackelworth</td><td>mmackelworth5p@hostgator.com</td><td>RothIRA</td><td>3049611855</td><td>$239240.36</td></tr><tr class='data'><td>7180</td><td>Merle</td>”.