# Convert a public XML file to Excel-ready rows

**Use case:** 

Download a public XML catalog, select each plant record, and prepare its fields for Excel or a data pipeline.

## Input

```json
{
  "xmlText": "<catalog><book id=\"bk-101\"><title>Practical Data Pipelines</title><price currency=\"USD\">29.95</price></book><book id=\"bk-102\"><title>XML in Practice</title><price currency=\"USD\">24.50</price></book></catalog>",
  "xmlUrls": [
    "https://www.w3schools.com/xml/plant_catalog.xml"
  ],
  "sources": [],
  "recordPath": "CATALOG.PLANT",
  "maxRows": 50,
  "removeNamespaces": true,
  "includeAttributes": true,
  "attributePrefix": "@",
  "nestedSeparator": ".",
  "arraySeparator": " | ",
  "columns": [
    "COMMON",
    "BOTANICAL",
    "ZONE",
    "LIGHT",
    "PRICE",
    "AVAILABILITY"
  ]
}
```

## 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.