Many people working with different kinds of data come across the problem that they need to convert between different data formats. Comma Separated Values (CSV) and the Extensible Markup Language (XML) are the most widely used formats for data, and conversion between these two formats needs often to be accomplished.

XML To CSV Converter. Use this tool to convert XML into CSV (Comma Separated Values) or Excel. You can also force double quotes around each field value or it will be determined for you. The output CSV header row is optional. In Mapforce 2005 R3, when mapping to CSV with the "First row contains field names" option UN-checked on the CSV target component settings, the characters (hex) FF FE FF FE are inserted in the beginning of the first line when running Java code autogenerated by Mapforce. In the output tab of the Mapforce application, this problem doesn't occur. In Altova MapForce I can map XML to CSV but when I append fields through the CSV Component Settings dialog it always gives a default name to the field (e.g. Field12).. I can change these default field names by changing the .mfd mapping definition file in a text editor but I'm sure there must be a way to do this through the GUI. MapForce includes support for the two most popular EDI formats, UN/EDIFACT and ANSI X12. In this how-to video, you'll learn how to use MapForce to map and convert data between EDI messages (X12 and UN/EDIFACT) and XML, databases, or text files. Learn to map EDI data with this how-to. 2) I have a program in R3 that creates input XML file in a specific directory and this XML has very complex structure. I converted complex XML to simpler XML that I need for CSV output using MAPFORCE which generaes XSLT on the background. I read quiet a bit on PI/XI but still trying to understand how I can acheive the result. How to convert XML data to CSV or plain text? Step 1: load XML data. You can copy and paste your XML data to the Source Data box, then click Load button. A