Excel to XML conversion can be used to create an XML structured document from the Excel spreadsheet. This XML can be used to import data into some external system or for a data storage.
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.
For saving Excel spreadsheet into XML we transform columns of the table into the nested structure of the XML document.
There is a possibility to customize the output of the Excel to XML Converter by defining the specific rules for the data transformation.
Read the following article from our blog to find out more details:
Convert Excel to Structured XML document with nested levels.
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.
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 should have correctly defined names, starting with a character, and not a number.
not valid: <1stWeekData>
There are defined start-tag (or opening tag): <Products>
and end-tag (or closing tag): </Products>.
XML document can have only one root element. Root element is a start-tag and end-tag, and the rest of the XML content should be placed inside those tags.
..xml content here
Special characters inside XML like <, >, &, ' and " should be escaped as follows:
- < represents "<"
- > represents ">"
- & represents "&"
- ' represents "'"
- " represents '"'
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".
Use our Excel to XML Converter
to convert any Excel file to XML format.
Steps to use Excel to XML Converter:
- Upload Excel file
- Click 'Run Conversion' button
- when the file is converted - download the XML file