How to convert CSV to XML

CSV and XML are both widely used formats for storing and exchanging data. They are quite different in structure, but you can easily convert CSV to XML with Easy Data Transform (including ‘escaping’ special characters):

• Install Easy Data Transform on your PC or Mac, if you haven’t done so already. It will only take a minute. There is a fully functional free trial and you don’t have to give us your email or sign up to anything.
• Start Easy Data Transform. Make sure the Auto Run button is pressed in.

• Drag the CSV file you wish to convert onto Easy Data Transform. A pink input item will be added.
• Ensuring the pink input item is selected, click the To File button in the Left pane (scroll to the bottom of the Left pane).

• A window will appear. Set the new file name and location. Select XML file as the file type.

• A green output item is added and selected.

• The XML file is created immediately, no need to ‘run’ anything.
• In the Right pane you can set the XML file Encoding.

Example CSV input:

CustomerID,CompanyName,ContactName
ALFKI,Alfreds Futterkiste,Maria Anders
ANATR,Ana Trujillo Emparedados y helados,Ana Trujillo
ANTON,Antonio Moreno Taquería,Antonio Moreno

Example XML output:

<?xml version="1.0" encoding="UTF-8"?>
<!-- File created by Easy Data Transform v1.6.0 at 2020-06-16 12:52:09. -->
<root>
  <record>
    <CustomerID>ALFKI</CustomerID>
    <CompanyName>Alfreds Futterkiste</CompanyName>
    <ContactName>Maria Anders</ContactName>
  </record>
  <record>
    <CustomerID>ANATR</CustomerID>
    <CompanyName>Ana Trujillo Emparedados y helados</CompanyName>
    <ContactName>Ana Trujillo</ContactName>
  </record>
  <record>
    <CustomerID>ANTON</CustomerID>
    <CompanyName>Antonio Moreno Taquería</CompanyName>
    <ContactName>Antonio Moreno</ContactName>
  </record>
</root>

To output values as XML attributes or nested nodes see the XML documentation.

If you have a large number of files to convert you can do it using the batch processing feature.

As well as changing file format, Easy Data Transform also allows you to combine 66 transforms (such as join, filter and dedupe) to quickly and easily create complex data transformations.