Convert Excel to XML

Want to convert Excel file to XML file?

Try Withdata Data File Converter, a desktop Excel to XML converter for Windows, MacOS, and Linux, Convert Excel to XML, Easy and Fast.

Download Withdata DataFileConverter Download DataFileConverter

Convert Excel to XML

Choose Excel file -> Set XML file -> Convert Excel to XML

“Start a New Convert” for “Excel to XML”.

convert Excel file to XML file - task window

Select From “File” “Excel” To “File” “XML”.

create XML file by Excel file - select type

1. Open source Excel file.

Support large Excel file ( > 4GB ).

transform Excel file to XML file - open a Excel file

Source Excel file’s content is like this:

Excel to XML converter - source Excel file

2. Config target XML file.

generate XML file by Excel file - config XML file

3. Set rows options.

convert Excel file to XML file - summary

4. Convert Excel to XML.

convert Excel file to XML file - convert file

After converting, you can view the output XML file.

convert Excel file to XML file - view XML file


More about Excel to XML converter

See Video: Convert Excel file to XML file in a few clicks

See also:

EXCEL → XML reference

Type mapping

Value kindin EXCELin XML
Int1234 (a real numeric cell)<int>1234</int>
Bigint9007199254740993 (exact only while the cell stays text)<bigint>9007199254740993</bigint>
Decimal1234.56 (numeric cell, format controls the displayed decimals)<decimal>1234.56</decimal>
Float1.234E+10 (numeric cell)<float>1.234e10</float>
Texttext cell; leading zeros survive only if the column is text<char>text</char>
Long texttext cell; wraps inside the cell rather than the row<text>multi-line text</text> (entities for &amp; &lt;)
Datea serial number plus a date cell format<date>2026-09-18</date> (xs:date with an XSD)
Datetimea serial number plus a date-time cell format<datetime>2026-09-18T14:30:00Z</datetime> (xs:dateTime)
Binarynot representable as data<blob>base64...</blob> (xs:base64Binary)
BooleanTRUE / FALSE (a real boolean cell)<bool>true</bool>
JSONa text cell; the quotes are part of the valueescaped inside an element, or its own sub-tree

Dialect differences

Both EXCEL and XML are file formats, so what differs below is how each one chooses to represent a value.

Propertyin EXCELin XML
identifiersNot applicable; a cell holds exactly one valueAttribute values in quotes; entities (&amp; &lt; &gt;) for ...
datesStored as a serial number; only the cell format makes it lo...Text (xs:date / xs:dateTime when an XSD is in play)
binaryOnly as text or an embedded object, not as a data columnbase64Binary / hexBinary inside text
separatorCells, not delimitersTags, not delimiters
encodingUTF-8 internally, declared in the packageDeclared in the XML declaration
typingReal cell types: text, number, date, boolean, errorNone in the markup itself
shapeMultiple sheets, each a flat gridArbitrary tree
ceiling1,048,576 rows x 16,384 columns per sheet; 255 sheets per w...Whole document is usually parsed into memory

Convert Excel to XML the easy way

Use the Excel to XML converter — an offline desktop app for Windows, macOS and Linux. Nothing to upload, large files and batch runs supported (free trial).


Posted

in

by