convert your XML data to Excel format using this free online tool to.
Excel files can be opened directly by your favorite spreadsheet program and allows
you to view the data in a convenient way, optimized for onscreen reading and printing.
Also available is a XML to CSV converter which might
be better suited when you intend to use the converted XML data for system purposes
like data export and import scenarios.
For each "table/entity" found in the uploaded XML data, a new worksheet
is created and added to the Excel workbook, so check each worksheet when you think
your data has mysteriously disappeared.
Note that it may take a considerable amount of time to convert a large XML file
to Excel format and that the maximum size allowed is set to 4mb.
- Click the "Browse..." button, then locate and
point to the XML file you want to convert on your computer. Click the button "Open"
to select the XML file.
- Advanced options: if you are familiar with XML and want
to use the available advanced options, click the link "Advanced options".
You can indicate that the system should attempt to resolve issues with conflicting
XML element names. You can also upload a DTD (Document Type Definition) file here
in case required by the XML file. Note that in your XML file the reference to the
DTD file should just indicate the exact name of the DTD file name without any directory
specification. For example:
- Back on the web page and with the XML file selected, click
the button "Convert XML to Excel". Wait until the conversion has completed.
This may take a while so please be patient.
- Once the conversion is complete the page will refresh itself.
A link "Download converted XML file" has appeared as a large blue link.
Click on this link.
- Specify the location where you want to save the converted
file. The conversion results are combined into a.zip archive for your convenience.
For now I assume you saved the zip file to your Windows or Mac desktop.
- Go to your desktop and double click the Zip file. Its content,
an xlsx Excel 2007/2010 file, will appear in a new window. Drag and drop the contents
to a folder of your choice or simply double-click the xlsx file and it will open
with your default spreadsheet editor if you have one installed on your computer.
- The Excel file is now ready to be used.
- You can download a free
MS Windows Excel viewer. Newer versions of Mac OS X open xlsx files natively
using pre-installed software.