An XML to Excel converter reads structured XML data and outputs an .xlsx spreadsheet. CodBolt's tool parses your XML entirely in the browser, maps elements to columns, and generates a downloadable Excel file — no server upload required.
In Flatten mode, repeated child elements (arrays) are expanded into separate rows — one row per record — and duplicate rows are automatically removed. In Non-flatten mode, all data is placed in a single row per parent element, and multiple values for the same field are joined with a semicolon (; ).
Nested elements are flattened into column names using underscore prefixes. For example, <address><city>Delhi</city></address> becomes a column named address_city in the Excel sheet.
You can upload XML files up to 50 MB. Files larger than 50 MB will be rejected with an error message. For best performance with large files, paste your XML directly into the editor instead of uploading.
Yes. The converter detects numeric values and stores them as actual numbers in Excel so formulas and sorting work correctly. Values with leading zeros (like product codes or zip codes) are preserved as text strings to prevent Excel from dropping the leading zeros.
Duplicate row removal applies only in Flatten mode. After expanding nested arrays into rows, the tool compares all column values in each row and removes any row that is an exact duplicate of a previous row, keeping your Excel output clean and free of redundant data.