How to make an XML element for each line from CSV

2026-05-05
Problem

There is a CSV with products. You need to get XML, where each line will become a Product element.

Short answer

Use the XML editor: select the source node, configure transformations, upload conditions and target fields.

Sample task

The data below is educational. They show the conversion form, not the users' actual files.

It was

sku,name,price
SKU-1,Product 1,1200
SKU-2,Product 2,900

It became

<Products>
  <Product>
    <SKU>SKU-1</SKU>
    <Name>Product 1</Name>
    <Price>1200</Price>
  </Product>
  <Product>
    <SKU>SKU-2</SKU>
    <Name>Product 2</Name>
    <Price>900</Price>
  </Product>
</Products>

How to set up

  1. Upload CSV or XLSX as a table source.
  2. Open the table editor and check that the column headings are recognized correctly.
  3. In the settings of the desired column, open the block "Transformations".
  4. If the entire line must be excluded, set the rule in a block "Unloading conditions".
  5. Save the settings and download the result in the desired format.

Process data faster with Eofferix

Create a free account to automate catalogs and price lists around your own rules.

Sign up