# Convert product XML to CSV online

**Use case:** 

Flatten a pasted product catalog XML document into one spreadsheet-ready row per product, including attributes and nested prices.

## Input

```json
{
  "xmlText": "<catalog><product sku=\"P-100\"><name>Travel Mug</name><category>Kitchen</category><price currency=\"USD\">18.5</price></product><product sku=\"P-200\"><name>Desk Lamp</name><category>Office</category><price currency=\"USD\">34</price></product></catalog>",
  "xmlUrls": [],
  "sources": [],
  "maxRows": 100,
  "removeNamespaces": true,
  "includeAttributes": true,
  "attributePrefix": "@",
  "nestedSeparator": ".",
  "arraySeparator": " | ",
  "columns": []
}
```

## Output

```json
{
  "_sourceName": {
    "label": "Source",
    "format": "string"
  },
  "_sourceType": {
    "label": "Input type",
    "format": "string"
  },
  "_recordPath": {
    "label": "Record path",
    "format": "string"
  },
  "_recordIndex": {
    "label": "Row",
    "format": "integer"
  },
  "_sourceUrl": {
    "label": "Source URL",
    "format": "string"
  },
  "_error": {
    "label": "Parse error",
    "format": "string"
  }
}
```

## About this Actor

This example demonstrates how to use [XML to CSV and Excel Converter](https://apify.com/automation-lab/xml-to-csv-excel-converter) with a specific input configuration. Visit the [Actor detail page](https://apify.com/automation-lab/xml-to-csv-excel-converter) to learn more, explore other use cases, and run it yourself.