XML to CSV Using XSLT

Question

I have the following XML document    lt projects gt     lt project gt      lt name gt Shockwave lt  name gt       lt language gt Ruby lt  language gt       lt owner gt Brian May lt  owner gt       lt state gt New lt  state gt       lt startDate gt 31 10 2008 0 00 00 lt  startDate gt      lt  project gt     lt project gt      lt name gt Other lt  name gt       lt language gt Erlang lt  language gt       lt owner gt Takashi Miike lt  owner gt       lt state gt  Canceled  lt  state gt       lt startDate gt 07 11 2008 0 00 00 lt  startDate gt      lt  project gt        And I d like to get this from the transformation  XSLT  result   Shockwave Ruby Brian May New 31 10 2008 0 00 00 Other Erlang Takashi Miike Cancelled 07 11 2008 0 00 00   Does anyone know the XSLT to achieve this  I m using  net in case that matters

User · Answer

Here is a version with configurable parameters that you can set programmatically    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl output method  text  encoding  utf-8    gt      lt xsl param name  delim  select         gt     lt xsl param name  quote  select    amp quot      gt     lt xsl param name  break  select    amp  xA      gt      lt xsl template match     gt       lt xsl apply-templates select  projects project    gt     lt  xsl template gt      lt xsl template match  project  gt       lt xsl apply-templates   gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   break    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match     gt       lt  -- remove normalize-space   if you want keep white-space at it is -- gt        lt xsl value-of select  concat  quote  normalize-space     quote     gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   delim    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match  text      gt   lt  xsl stylesheet gt

User · Answer

Found an XML transform stylesheet here  wayback machine link  site itself is in german   The stylesheet added here could be helpful    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt   lt xsl output method  text  encoding  iso-8859-1   gt    lt xsl strip-space elements       gt    lt xsl template match     child     gt   lt xsl for-each select  child     gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt        lt  xsl if gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt   lt xsl text gt  amp  xD  lt  xsl text gt   lt  xsl if gt   lt  xsl for-each gt   lt  xsl template gt    lt  xsl stylesheet gt    Perhaps you want to remove the quotes inside the xsl if tags so it doesn t put your values into quotes  depending on where you want to use the CSV file

User · Answer

Found an XML transform stylesheet here  wayback machine link  site itself is in german   The stylesheet added here could be helpful    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt   lt xsl output method  text  encoding  iso-8859-1   gt    lt xsl strip-space elements       gt    lt xsl template match     child     gt   lt xsl for-each select  child     gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt        lt  xsl if gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt   lt xsl text gt  amp  xD  lt  xsl text gt   lt  xsl if gt   lt  xsl for-each gt   lt  xsl template gt    lt  xsl stylesheet gt    Perhaps you want to remove the quotes inside the xsl if tags so it doesn t put your values into quotes  depending on where you want to use the CSV file

User · Answer

Here is a version with configurable parameters that you can set programmatically    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl output method  text  encoding  utf-8    gt      lt xsl param name  delim  select         gt     lt xsl param name  quote  select    amp quot      gt     lt xsl param name  break  select    amp  xA      gt      lt xsl template match     gt       lt xsl apply-templates select  projects project    gt     lt  xsl template gt      lt xsl template match  project  gt       lt xsl apply-templates   gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   break    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match     gt       lt  -- remove normalize-space   if you want keep white-space at it is -- gt        lt xsl value-of select  concat  quote  normalize-space     quote     gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   delim    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match  text      gt   lt  xsl stylesheet gt

User · Answer

Here is a version with configurable parameters that you can set programmatically    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl output method  text  encoding  utf-8    gt      lt xsl param name  delim  select         gt     lt xsl param name  quote  select    amp quot      gt     lt xsl param name  break  select    amp  xA      gt      lt xsl template match     gt       lt xsl apply-templates select  projects project    gt     lt  xsl template gt      lt xsl template match  project  gt       lt xsl apply-templates   gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   break    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match     gt       lt  -- remove normalize-space   if you want keep white-space at it is -- gt        lt xsl value-of select  concat  quote  normalize-space     quote     gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   delim    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match  text      gt   lt  xsl stylesheet gt

User · Answer

This xsl stylesheet can use a specified list of column headers and will ensure that the rows will be ordered correctly    lt  xml version  1 0   gt   lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  xmlns csv  csv csv  gt       lt xsl output method  text  encoding  utf-8    gt       lt xsl strip-space elements       gt        lt xsl variable name  delimiter  select         gt        lt csv columns gt           lt column gt name lt  column gt           lt column gt sublease lt  column gt           lt column gt addressBookID lt  column gt           lt column gt boundAmount lt  column gt           lt column gt rentalAmount lt  column gt           lt column gt rentalPeriod lt  column gt           lt column gt rentalBillingCycle lt  column gt           lt column gt tenureIncome lt  column gt           lt column gt tenureBalance lt  column gt           lt column gt totalIncome lt  column gt           lt column gt balance lt  column gt           lt column gt available lt  column gt       lt  csv columns gt        lt xsl template match   property-manager properties  gt           lt  -- Output the CSV header -- gt           lt xsl for-each select  document       csv columns    gt                   lt xsl value-of select      gt                   lt xsl if test  position      last    gt                       lt xsl value-of select   delimiter   gt                   lt  xsl if gt           lt  xsl for-each gt           lt xsl text gt  amp  xa  lt  xsl text gt            lt  -- Output rows for each matched property -- gt           lt xsl apply-templates select  property    gt       lt  xsl template gt        lt xsl template match  property  gt           lt xsl variable name  property  select       gt            lt  -- Loop through the columns in order -- gt           lt xsl for-each select  document       csv columns    gt               lt  -- Extract the column name and value -- gt               lt xsl variable name  column  select       gt               lt xsl variable name  value  select   property   name      column     gt                lt  -- Quote the value if required -- gt               lt xsl choose gt                   lt xsl when test  contains  value    amp quot     gt                       lt xsl variable name  x  select  replace  value    amp quot       amp quot  amp quot      gt                       lt xsl value-of select  concat   amp quot     x    amp quot      gt                   lt  xsl when gt                   lt xsl when test  contains  value   delimiter   gt                       lt xsl value-of select  concat   amp quot     value    amp quot      gt                   lt  xsl when gt                   lt xsl otherwise gt                       lt xsl value-of select   value   gt                   lt  xsl otherwise gt               lt  xsl choose gt                lt  -- Add the delimiter unless we are the last expression -- gt               lt xsl if test  position      last    gt                   lt xsl value-of select   delimiter   gt               lt  xsl if gt           lt  xsl for-each gt            lt  -- Add a newline at the end of the record -- gt           lt xsl text gt  amp  xa  lt  xsl text gt       lt  xsl template gt    lt  xsl stylesheet gt

User · Answer

Here is a version with configurable parameters that you can set programmatically    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl output method  text  encoding  utf-8    gt      lt xsl param name  delim  select         gt     lt xsl param name  quote  select    amp quot      gt     lt xsl param name  break  select    amp  xA      gt      lt xsl template match     gt       lt xsl apply-templates select  projects project    gt     lt  xsl template gt      lt xsl template match  project  gt       lt xsl apply-templates   gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   break    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match     gt       lt  -- remove normalize-space   if you want keep white-space at it is -- gt        lt xsl value-of select  concat  quote  normalize-space     quote     gt       lt xsl if test  following-sibling     gt         lt xsl value-of select   delim    gt       lt  xsl if gt     lt  xsl template gt      lt xsl template match  text      gt   lt  xsl stylesheet gt

User · Answer

Found an XML transform stylesheet here  wayback machine link  site itself is in german   The stylesheet added here could be helpful    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt   lt xsl output method  text  encoding  iso-8859-1   gt    lt xsl strip-space elements       gt    lt xsl template match     child     gt   lt xsl for-each select  child     gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt        lt  xsl if gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt   lt xsl text gt  amp  xD  lt  xsl text gt   lt  xsl if gt   lt  xsl for-each gt   lt  xsl template gt    lt  xsl stylesheet gt    Perhaps you want to remove the quotes inside the xsl if tags so it doesn t put your values into quotes  depending on where you want to use the CSV file

User · Answer

This CsvEscape function is XSLT 1 0 and escapes column values       and newlines like RFC 4180 or Excel  It makes use of the fact that you can recursively call XSLT templates    The template EscapeQuotes replaces all double quotes with 2 double quotes  recursively from the start of the string  The template CsvEscape checks if the text contains a comma or double quote  and if so surrounds the whole string with a pair of double quotes and calls EscapeQuotes for the string    Example usage  xsltproc xmltocsv xslt file xml  gt  file csv   lt  xml version  1 0  encoding  UTF-8   gt   lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl output method  text  encoding  UTF-8   gt      lt xsl template name  EscapeQuotes  gt       lt xsl param name  value   gt       lt xsl choose gt         lt xsl when test  contains  value   amp quot     gt       lt xsl value-of select  substring-before  value   amp quot      gt       lt xsl text gt  amp quot  amp quot  lt  xsl text gt       lt xsl call-template name  EscapeQuotes  gt         lt xsl with-param name  value  select  substring-after  value   amp quot      gt       lt  xsl call-template gt         lt  xsl when gt         lt xsl otherwise gt       lt xsl value-of select   value   gt         lt  xsl otherwise gt       lt  xsl choose gt     lt  xsl template gt      lt xsl template name  CsvEscape  gt       lt xsl param name  value   gt       lt xsl choose gt       lt xsl when test  contains  value       gt         lt xsl text gt  amp quot  lt  xsl text gt         lt xsl call-template name  EscapeQuotes  gt       lt xsl with-param name  value  select   value   gt         lt  xsl call-template gt         lt xsl text gt  amp quot  lt  xsl text gt       lt  xsl when gt       lt xsl when test  contains  value   amp  xA     gt         lt xsl text gt  amp quot  lt  xsl text gt         lt xsl call-template name  EscapeQuotes  gt       lt xsl with-param name  value  select   value   gt         lt  xsl call-template gt         lt xsl text gt  amp quot  lt  xsl text gt       lt  xsl when gt       lt xsl when test  contains  value   amp quot     gt         lt xsl text gt  amp quot  lt  xsl text gt         lt xsl call-template name  EscapeQuotes  gt       lt xsl with-param name  value  select   value   gt         lt  xsl call-template gt         lt xsl text gt  amp quot  lt  xsl text gt       lt  xsl when gt       lt xsl otherwise gt         lt xsl value-of select   value   gt       lt  xsl otherwise gt       lt  xsl choose gt     lt  xsl template gt      lt xsl template match     gt       lt xsl text gt project name language owner state startDate lt  xsl text gt       lt xsl text gt  amp  xA  lt  xsl text gt       lt xsl for-each select  projects project  gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space name    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space language    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space owner    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space state    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space startDate    gt  lt  xsl call-template gt         lt xsl text gt  amp  xA  lt  xsl text gt       lt  xsl for-each gt     lt  xsl template gt   lt  xsl stylesheet gt

User · Answer

Found an XML transform stylesheet here  wayback machine link  site itself is in german   The stylesheet added here could be helpful    lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt   lt xsl output method  text  encoding  iso-8859-1   gt    lt xsl strip-space elements       gt    lt xsl template match     child     gt   lt xsl for-each select  child     gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt        lt  xsl if gt   lt xsl if test  position      last    gt   lt xsl value-of select  normalize-space      gt   lt xsl text gt  amp  xD  lt  xsl text gt   lt  xsl if gt   lt  xsl for-each gt   lt  xsl template gt    lt  xsl stylesheet gt    Perhaps you want to remove the quotes inside the xsl if tags so it doesn t put your values into quotes  depending on where you want to use the CSV file

User · Answer

This CsvEscape function is XSLT 1 0 and escapes column values       and newlines like RFC 4180 or Excel  It makes use of the fact that you can recursively call XSLT templates    The template EscapeQuotes replaces all double quotes with 2 double quotes  recursively from the start of the string  The template CsvEscape checks if the text contains a comma or double quote  and if so surrounds the whole string with a pair of double quotes and calls EscapeQuotes for the string    Example usage  xsltproc xmltocsv xslt file xml  gt  file csv   lt  xml version  1 0  encoding  UTF-8   gt   lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  gt     lt xsl output method  text  encoding  UTF-8   gt      lt xsl template name  EscapeQuotes  gt       lt xsl param name  value   gt       lt xsl choose gt         lt xsl when test  contains  value   amp quot     gt       lt xsl value-of select  substring-before  value   amp quot      gt       lt xsl text gt  amp quot  amp quot  lt  xsl text gt       lt xsl call-template name  EscapeQuotes  gt         lt xsl with-param name  value  select  substring-after  value   amp quot      gt       lt  xsl call-template gt         lt  xsl when gt         lt xsl otherwise gt       lt xsl value-of select   value   gt         lt  xsl otherwise gt       lt  xsl choose gt     lt  xsl template gt      lt xsl template name  CsvEscape  gt       lt xsl param name  value   gt       lt xsl choose gt       lt xsl when test  contains  value       gt         lt xsl text gt  amp quot  lt  xsl text gt         lt xsl call-template name  EscapeQuotes  gt       lt xsl with-param name  value  select   value   gt         lt  xsl call-template gt         lt xsl text gt  amp quot  lt  xsl text gt       lt  xsl when gt       lt xsl when test  contains  value   amp  xA     gt         lt xsl text gt  amp quot  lt  xsl text gt         lt xsl call-template name  EscapeQuotes  gt       lt xsl with-param name  value  select   value   gt         lt  xsl call-template gt         lt xsl text gt  amp quot  lt  xsl text gt       lt  xsl when gt       lt xsl when test  contains  value   amp quot     gt         lt xsl text gt  amp quot  lt  xsl text gt         lt xsl call-template name  EscapeQuotes  gt       lt xsl with-param name  value  select   value   gt         lt  xsl call-template gt         lt xsl text gt  amp quot  lt  xsl text gt       lt  xsl when gt       lt xsl otherwise gt         lt xsl value-of select   value   gt       lt  xsl otherwise gt       lt  xsl choose gt     lt  xsl template gt      lt xsl template match     gt       lt xsl text gt project name language owner state startDate lt  xsl text gt       lt xsl text gt  amp  xA  lt  xsl text gt       lt xsl for-each select  projects project  gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space name    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space language    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space owner    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space state    gt  lt  xsl call-template gt         lt xsl text gt   lt  xsl text gt         lt xsl call-template name  CsvEscape  gt  lt xsl with-param name  value  select  normalize-space startDate    gt  lt  xsl call-template gt         lt xsl text gt  amp  xA  lt  xsl text gt       lt  xsl for-each gt     lt  xsl template gt   lt  xsl stylesheet gt

User · Answer

This xsl stylesheet can use a specified list of column headers and will ensure that the rows will be ordered correctly    lt  xml version  1 0   gt   lt xsl stylesheet version  1 0  xmlns xsl  http   www w3 org 1999 XSL Transform  xmlns csv  csv csv  gt       lt xsl output method  text  encoding  utf-8    gt       lt xsl strip-space elements       gt        lt xsl variable name  delimiter  select         gt        lt csv columns gt           lt column gt name lt  column gt           lt column gt sublease lt  column gt           lt column gt addressBookID lt  column gt           lt column gt boundAmount lt  column gt           lt column gt rentalAmount lt  column gt           lt column gt rentalPeriod lt  column gt           lt column gt rentalBillingCycle lt  column gt           lt column gt tenureIncome lt  column gt           lt column gt tenureBalance lt  column gt           lt column gt totalIncome lt  column gt           lt column gt balance lt  column gt           lt column gt available lt  column gt       lt  csv columns gt        lt xsl template match   property-manager properties  gt           lt  -- Output the CSV header -- gt           lt xsl for-each select  document       csv columns    gt                   lt xsl value-of select      gt                   lt xsl if test  position      last    gt                       lt xsl value-of select   delimiter   gt                   lt  xsl if gt           lt  xsl for-each gt           lt xsl text gt  amp  xa  lt  xsl text gt            lt  -- Output rows for each matched property -- gt           lt xsl apply-templates select  property    gt       lt  xsl template gt        lt xsl template match  property  gt           lt xsl variable name  property  select       gt            lt  -- Loop through the columns in order -- gt           lt xsl for-each select  document       csv columns    gt               lt  -- Extract the column name and value -- gt               lt xsl variable name  column  select       gt               lt xsl variable name  value  select   property   name      column     gt                lt  -- Quote the value if required -- gt               lt xsl choose gt                   lt xsl when test  contains  value    amp quot     gt                       lt xsl variable name  x  select  replace  value    amp quot       amp quot  amp quot      gt                       lt xsl value-of select  concat   amp quot     x    amp quot      gt                   lt  xsl when gt                   lt xsl when test  contains  value   delimiter   gt                       lt xsl value-of select  concat   amp quot     value    amp quot      gt                   lt  xsl when gt                   lt xsl otherwise gt                       lt xsl value-of select   value   gt                   lt  xsl otherwise gt               lt  xsl choose gt                lt  -- Add the delimiter unless we are the last expression -- gt               lt xsl if test  position      last    gt                   lt xsl value-of select   delimiter   gt               lt  xsl if gt           lt  xsl for-each gt            lt  -- Add a newline at the end of the record -- gt           lt xsl text gt  amp  xa  lt  xsl text gt       lt  xsl template gt    lt  xsl stylesheet gt

[xml] XML to CSV Using XSLT

Examples related to xml

Examples related to xslt

Examples related to csv