Need to convert your tabular data from a spreadsheet into a machine-readable format like XML for further processing by a program? Our Excel to XML Converter can help solve this problem.

XML, or Extensible Markup Language, is a machine-readable text format that is widely used for storing and exchanging data. It has several benefits over Excel, including its ability to store data in a hierarchical structure and its high level of customization. This makes XML a great choice for organizing and sharing data in a logical and easily navigable way.

Reading Excel file

Excel file has the data stored in a form of spreadsheets or tables, and the styles which define how the data should be visually represented.

Saving XML file

For saving Excel spreadsheet into XML we transform columns of the table into the nested structure of the XML document.

Example of the Conversion

Source file:

Result data:

Using the Custom Excel to XML Converter allows you to customize the output by defining specific rules for data transformation.

Read the following article to learn more about it: Convert Excel to Structured XML document with nested levels.

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.

Data inside Excel file is stored in a form of spreadsheets or tables.

Data Format

XML is both machine-readable and human-readable format and can be edited in any text editor.

Tags

The names of the tags should be properly defined, beginning with a character rather than arithmetic value.

For instance,

• valid: <Product>
• not valid: <1stWeekData>

Start and End Tags

There are defined a start-tag or opening tag, for example: <Product>,

and a corresponding end-tag or closing tag, for example: </Product>.

Root Element

There can be only one root element in an XML document. The root element consists of a start tag and an end tag, and the rest of the content should be inserted between these tags.

An example of the root element is shown below:

  <Products>
    ..the content goes here
  </Products>

Special Characters Escaping

Special characters in the content, like <, >, &, ' and " should be escaped as follows:

• < stands for <
• > stands for >
• & stands for &
• ' stands for '
• " stands for "

Encoding

XML encoding specifies how the characters in an XML document are represented. It is defined in the XML file as the first line, as shown below:

  <?xml version="1.0" encoding="UTF-8"?>