rmeekers/convertXMLtoHtml.md

## convertXMLtoHtml.md

      
    Raw
  

              convertXMLtoHtml.md
            
          
    This describes how you can convert an XML file to a simple HTML table.
The table can then be copy/pasted into a Google Sheet for example for further manipulation.
Install Saxon

brew install saxon
Convert XML file to HTML

saxon -s:input.xml -xsl:stylesheet.xsl -o:result.html
Sample XSL

<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">

<xsl:template match="/">
<html>
<body>
  <table>
    <tr>
      <th>url</th>
      <th>event_date</th>
    </tr>
    <xsl:for-each select="rss/channel/item">
    <tr>
      <td><xsl:value-of select="link" /></td>
      <td><xsl:value-of select="event_date" /></td>
    </tr>
    </xsl:for-each>
  </table>
</body>
</html>
</xsl:template>
</xsl:stylesheet>