Flatten namespaced order XML into Excel columns
Created by
Stas Persiianenko
Strip XML namespace prefixes, select order nodes, include attributes, and keep a controlled set of nested columns for recurring spreadsheet imports.
XML to CSV and Excel Converterautomation-lab/xml-to-csv-excel-converter
Source
Input type
Record path
Row
+2 fieldsTextNumberBooleanListObject
Input
Batch sources
Source name:August orders
XML text:<erp:orders xmlns:erp="urn:sample:erp"><erp:order id="SO-1001"><erp:customer><erp:name>Northwind Demo</erp:name><erp:region>West</erp:region></erp:customer><erp:total currency="USD">125.4</erp:total></erp:order><erp:order id="SO-1002"><erp:customer><erp:name>Contoso Sample</erp:name><erp:region>East</erp:region></erp:customer><erp:total currency="USD">89</erp:total></erp:order></erp:orders>
Record node path:orders.order
Remove namespace prefixes:true
Include XML attributes:true
Columns to keep:@id+4
Maximum rows:1000
Output fields
Source
Input type
Record path
Row
Source URL
Parse error
Sign up on Apify01
Create your Apify account to access the XML to CSV and Excel Converter.
Start the run02
The Actor will start running based on the input automatically.
Receive the output03
Monitor the progress in real-time. You will be notified as soon as your dataset is complete and ready for review.
Integrate into your workflow04
The final output is delivered in JSON, CSV, or Excel format, ready to be plugged into your workflow.
