Step 1 / source
Choose the source
Drop one file here
Choose the flat record xml you want to turn into styled xlsx worksheet.
Checking publication status...LOCAL DATA CONVERTER / XML TO EXCEL
XML to Excel
Convert repeated flat XML records into a genuine styled XLSX worksheet while blocking DTD and entity declarations.
Processed in this browserOne UTF-8 .xml file up to 5 MB. The document must have one root containing repeated flat records within 50,000 records, 200 columns, 1,000,000 cells, and 20 MB output.
XML - flat repeated records
No file upload
This operation runs with browser APIs. Nirmion receives catalogue requests, not the selected source bytes.
Original stays unchanged
The converter creates a separately named output. It never writes back into the source file.
Bounded work
One UTF-8 .xml file up to 5 MB. The document must have one root containing repeated flat records within 50,000 records, 200 columns, 1,000,000 cells, and 20 MB output.
Plain-language method
How XML to Excel works
Nirmion validates well-formed XML without DTDs or custom entities, identifies one repeated record element, projects scalar attributes and child elements to columns, and writes a frozen, filterable worksheet. Formula-like text is neutralized.
- 01Choose a valid source
Use one root containing one repeated record element. Each record may contain scalar attributes and scalar child elements only.
- 02Review the conversion choices
The worksheet name is cleaned to Excel rules and limited to 31 characters.
- 03Inspect the separate result
The result ends in _nirmion_tools_workbook.xlsx and contains values only, not XML hierarchy, schemas, comments, or processing instructions.
WORKED EXAMPLE / REVIEW BEFORE RELYING
XML to Excel: a small review pass
Use a short, non-sensitive sample first. This example shows the checkpoints to apply before moving an authorised dataset into the destination workflow.
- XMLSource
Choose sample.xml with a header and two representative, non-sensitive records.
- Review the conversion choices
Keep the documented defaults, convert once, and compare the preview or result count with the XML sample.
- XLSXResult
Open the separate Excel download and verify two records, field names, nulls, encoding, and destination compatibility.
Useful when
Practical jobs this tool handles
- Review a flat XML feed in a spreadsheet.
- Prepare repeated XML records for manual cleanup.
- Create a filterable handoff from legacy XML.
Before converting
Check the source and destination rules
- Remove DTD and ENTITY declarations.
- Confirm records share one repeated element name.
- Keep the original XML for hierarchy and metadata.
Know the boundary
Know what the destination format cannot keep
Nested elements, mixed content, repeated child fields, namespaces with complex structures, schemas, and comments cannot be represented as one rectangular worksheet and are rejected or omitted by contract.
Quick answers
Questions before you convert
The conversion contract is deliberately explicit.
Are XML attributes included?
Yes. Scalar attributes become columns prefixed with @.
Are nested child records flattened?
No. Nested records are rejected to avoid ambiguous columns.
Will formulas execute in Excel?
No. Generated cells are values, and formula-like text is neutralized.