Excel to XML Converter

Import screens for ERP, e-commerce and accounting systems often want XML, while the data lives in Excel. Choose an .xlsx, .xls, .ods or .csv file, pick the sheet, and get XML with the root and row element names you need: each row becomes an element and each column a child element or attribute named after its header. Or produce Excel 2003 XML (SpreadsheetML), which keeps cell types. The file is converted in your browser and never uploaded.

How to use this tool

1. Choose the Excel file.
2. Enter a sheet name or number, or leave it empty for the first sheet.
3. Choose your own XML structure or Excel 2003 XML.
4. Name the root and row elements and choose elements or attributes for the columns.
5. Download the .xml file or copy the text.

Formula

<root> → one <row> per spreadsheet row → <header>value</header> (or header="value") per cell

Headers are turned into valid XML names (spaces and symbols become _, names starting with a digit or "xml" get an _ prefix, duplicates are numbered) and every value is escaped. "As shown in Excel" writes cells the way they are displayed (for example 1,234.50 or 3/14/2025); "Raw" writes the stored value, with dates as YYYY-MM-DD. SpreadsheetML marks each cell as String, Number, Boolean or DateTime.

Example

A sheet with the header row name, age and the rows Ada 36 and Lin 29 becomes <rows> with two <row> elements such as <row><name>Ada</name><age>36</age></row>; with attributes it is <person name="Ada" age="36"/>. As SpreadsheetML the same sheet is a <Workbook> with one <Worksheet ss:Name="Sheet1"> and three <Row>s, the ages typed as Number.