Skip Links

Making XML human-readable

Dr. Internet By , Network World
February 02, 2004 12:06 AM ET
Steve Blass

Network World - In last week's column you discussed converting comma-delimited files to XML. What about converting XML to a readable format?

At first glance this looks like an easy problem to solve using XML Stylesheet Language Transformation (XSLT).

We match the document root with <xsl:template match="/"> and walk through the rows of CSV data records and columns of data fields printing the contents of each field followed by a comma, with line breaks between records as follows:

<xsl:for-each select="record"><xsl:for-each select="*"><xsl:apply-templates /></xsl:for-each></xsl:for-each><br /></xsl:template>.

For more examples using this kind of approach, search the Web for 'xml2csv.'

Converting XML to CSV can help you get started with XSLT. To convert large numbers of files or complex XML files, check out tools such as XMLSpy for their file Import/Export features.

One reasonably robust and free XML-to-CSV converter is in a utilities package named Poof! at www.kilowattsoftware.com. The program, a Windows command-line utility named xml2csv, reads XML files then lists the column fieldnames in the file or writes the CSV file, with or without column headers.

Read more about software in Network World's Software section.

Our Commenting Policies
Latest News
rssRss Feed
View more Latest News