Upload XML
Paste XML
Mapping
Output
Column Mapping
F.A.Q
How do I select the correct repeating node for mapping?
After analyzing, pick the node path that represents a single record to ensure each Excel row maps to one entry.
How can I include or remove XML namespaces from my headers?
Use the "XML Namespaces" option: "Include Namespaces" preserves prefixes, "Ignore Namespaces" strips them for cleaner column names.
How do I automatically generate and customize column mappings?
Click "Analyze XML", then in the Mapping tab trigger auto-detect by changing the repeating node. Adjust headers, data types, and defaults as needed.
How can I reorder columns in the output?
Drag the ☰ handle next to each mapping row to reposition columns; the final Excel column order matches the list order.
How do I set default values for missing or empty nodes?
Specify a default in the "Default Value" field of a mapping row to fill cells when the XML node is absent or blank.
How do I extract XML attributes as separate columns?
In Column Mapping, attribute paths are listed with an '@' prefix; select any to map its value as a separate column.
How do I handle nested repeating elements while preserving parent data?
Choose the deepest repeating node to generate rows, then add additional mappings for parent-level paths to include context in each row.
Can I map the same XML node multiple times with different formats?
Yes—click "Add Column" again, select the same XML path, and then set different Header Name, Data Type, or Default Value for each instance.
How do I preserve leading zeros in numeric codes (e.g., zip codes)?
Select "Text" as the Data Type for those columns so Excel treats values as text and keeps leading zeros intact.
How can I ensure Excel recognizes dates or currency correctly?
Set the Data Type to "Date" or "Currency" in the mapping; Excel will then apply native cell formatting on download.
Why are some expected columns missing after mapping?
Re-run "Analyze XML" to refresh the node list, check namespace handling (include/ignore), and ensure your XML path matches the actual XML structure.
Is my data kept private, or is anything sent to a server?
All conversion runs entirely in your browser; your XML files and results never leave your computer.
☰