Convert XML to CSV using XSLT

Question

How to convert XML to CSV (to be shown in Excel file) using XSLT?

Provided XML value itself contains comma, e.g.

<name>The,Bad Boy</name>

My logic considers "The" & "Bad boy" as separate values as it goes in different columns after opening in Excel file.

possible duplicate of convert xml document to comma delimited (CSV) file using xslt stylesheet. — user357812
– user357812, Commented Oct 28, 2010 at 14:28

Community · Accepted Answer · 2017-05-23 11:47:40Z

4

It's not that this type of question would not have been answered before:

By the way, "CSV" does not mean that values cannot contain commas or must be separated by commas.

Excel can understand CSV that is separated by other characters than comma (tab, for example), and values that contain the separator can be enclosed in quotes.

edited May 23, 2017 at 11:47

CommunityBot

11 silver badge

answered Oct 28, 2010 at 12:30

Tomalak

339k68 gold badges547 silver badges635 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert XML to CSV using XSLT

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related