Nirmion
Помощь Найдите инструмент

LOCAL DATA CONVERTER / XML TO CSV

XML to CSV

Turn repeated flat XML records into a formula-protected CSV table while preserving scalar attributes and direct child-element text.

Processed in this browserOne UTF-8 .xml file up to 5 MB, limited to 50,000 records, 200 discovered columns, 1,000,000 cells, and 20 MB output. DTD, entities, nested fields, and mixed content are rejected.

Step 1 / source

Choose the source

XML - 50,000 records

Drop one file here

Choose XML with one root and repeated records of the same element type, using scalar attributes or direct child elements.

Checking publication status...

01
No file upload

This operation runs with browser APIs. Nirmion receives catalogue requests, not the selected source bytes.

02
Original stays unchanged

The converter creates a separately named output. It never writes back into the source file.

03
Bounded work

One UTF-8 .xml file up to 5 MB, limited to 50,000 records, 200 discovered columns, 1,000,000 cells, and 20 MB output. DTD, entities, nested fields, and mixed content are rejected.

Plain-language method

How flat XML becomes a table

Nirmion validates the XML without DTD or entity declarations, requires one root with a single repeated record element, discovers scalar attributes and direct child elements as columns, protects formula-like cell prefixes, and writes one CSV row per record. Nested arrays and mixed content stop the conversion.

  1. 01
    Choose a valid source

    Use a structure such as <records><record><name>Ada</name></record></records>. Flatten nested addresses, lists, or repeated child tags before conversion.

  2. 02
    Review the conversion choices

    Comma is the widest default. Semicolon can suit regional imports, while pipe helps when ordinary text contains many commas.

  3. 03
    Inspect the separate result

    The UTF-8 CSV includes a BOM for spreadsheet compatibility. Attribute columns are labelled with @, and missing fields remain empty.

Useful when

Practical jobs this tool handles

  • Move a simple XML export into a spreadsheet.
  • Review repeated XML records as rows and columns.
  • Prepare flat source data for a CSV-based import.

Before converting

Check the record shape

  • Confirm the root contains one repeated element type.
  • Flatten nested child elements and repeated fields.
  • Review formula-protected cells before importing elsewhere.

Know the boundary

Hierarchical XML cannot fit a flat CSV safely

Nested elements, repeated fields inside one record, and mixed text require an explicit mapping. This tool rejects them instead of duplicating rows or silently discarding hierarchy.

Quick answers

Questions before you convert

A narrow shape prevents surprising data loss.

How are XML attributes represented?

Each scalar attribute becomes a column prefixed with @.

Why are DTD and ENTITY blocked?

They are unnecessary for this local table conversion and can introduce unsafe or external resolution behavior.

Can it flatten deeply nested XML?

No. Flatten the structure with a reviewed mapping before using this converter.