Convert CSV-data to XML-files

Here’s a tool I developed that transforms CSV-data into XML-data based on a template.

You can use it to, for example:

You can use it to convert any type of CSV-data into text files (e.g. HTML, XML, etc).

Converting CSV data to XML files using a template

To convert files, you need

A CSV-data file. You can use any text editor or save your Excel spreadsheet as a CSV file.
An XML-template file.

Ensure that the CSV file has headers, because the first line in the CSV does not get converted.
Verify which type of separator the file has (comma, semicolon, or tab)

In the example file (data.csv), the data looks like this:

Heading;Paragraph
Heading A;Paragraph A
Heading B;Paragraph B
Heading C;Paragraph C
Heading D;Paragraph D
Heading E;Paragraph E
Heading F;Paragraph F

In the XML template, you add HTML comments wherever you want to insert data from a column in the CSV file.

In the example file (template.xml) I’ve inserted one column in the H1 and another one in the P-tag:

 <html>
 <body>
 <h1><!--[0]--></h1>
 <p><!--[1]--></p>
 </body>
 </html>

Use the following syntax to create files based on the examples above.

CSVtoXMLconverter.exe "data.csv" "template.xml" "" "0.htm" ";"

The CSVtoXMLconverter takes 5 arguments to run

The source CSV-data, (e.g. “c:dataCSVdata.csv”)
The XML-template, (e.g. “c:dataXMLtemplate.xml”)
The destination folder (e.g. “C:datastuff”). If left blank, the files are created in the same folder as the .exe file.
The file name column (e.g. “0.htm” will create .htm files using the data in the first column as the file name)
The type of separator (e.g. “,” or “;”, or “tab”). If left blank, “;” is used.

Did you find this useful? Let me know!

Found a few bugs? Let me know! 🙂

Good luck and have fun converting!