Convert XML to Excel (XLS) Online

Convert large XML files (up to 1Gb) to Excel (XLS, XLSX) format.

Please set options below and click the Run Conversion button
1
Select a file
Browse
2
Click button to run conversion
Rating
NaN - votes

You may help others to find this website - Share your experience!

How XML to Excel Converter works?

When you think to import XML file in Excel, it is much easier to convert created xml file into Excel format and open it in Microsoft Office Excel.

XML Validation
As a first step, we open an XML source file and validate it. During the validation process, we check the data structure of the XML for errors. If there are a lot of errors in the XML file structure - we couldn't process such file.
XML Data Parsing
On the parsing step we import XML data file, read and understand the data structure and extract the data from the XML.
Data Transformation
When the data from the source XML file is extracted, the next step is to transform the data from XML-based representation into the table-representation such as the Excel format.
XML to Excel converter uses the following rules to transform the data:
  • Every XML tag represents the separate table column
  • Every XML attribute represents the separate table column
  • Data is combined based on the upper level XML tags
Saving to Excel file
Once the data is transformed into table representation and combined based on the XML to Excel converter rules, it is saved into the Excel file.

XML File Format

XML Format
XML is an abbreviation from "Extensible Markup Language".
XML is both machine-readable and human-readable format and can be edited in any text editor.
XML Tags
XML Tags should have a correctly defined names, starting with a character, and not a number.
For example,
valid: <Products>
not valid: <1stWeekData>
Special Characters Escaping
Special characters inside XML like <, >, &, ' and " should be escaped as follows:
  • &lt; represents "<"
  • &gt; represents ">"
  • &amp; represents "&"
  • &apos; represents "'"
  • &quot; represents '"'
XML Encoding
XML encoding is defined in the XML file as the first line:
<?xml version="1.0" encoding="UTF-8"?>
We support all encoding formats. The most popular encoding is "UTF-8".

Excel File Format

Excel Format
Excel format is the file format used in Microsoft Office Excel program.
File in Excel format has extension: .xls or .xlsx, depending on the Excel version.
Excel Limits
Excel has the following limits when user open the file in Microsoft Office Excel program:
  • Max number of rows: 1,048,576 rows
  • Max number of columns: 16,384 columns
  • Column width: 255 characters
  • Max number of characters in cell: 32,767 characters
  • Max number of Hyperlinks in a worksheet: 66,530 hyperlinks
If you experience issues related to the Excel format limits - consider using CSV format and our XML to CSV converter.
  1. Logging in to the user account is the most secure way to work with your files. Register your account now!
  2. Conversion time depends on the source file size. Please be patient while the conversion is being processed. We are working on the performance improvement.
  3. To provide the reliable operation of the service there are limits defined for the number of conversions per day and file size per conversion. Limits depends on the Conversion Plan that you will use. You can check available Conversion Plans on the Pricing page.
  4. Unregistered users has the following limits: 10 conversions per day, 10 Mb per uploaded file. Register your account now to extend the limits for free.
  5. We can help to Automate the conversion process. Find out more on this page.
  6. If you would like to convert a larger file or if you experience problems converting your file - feel free to contact us, our team is able to solve almost any conversion problem.