Convert XML to Excel using Swift XML Converter

Swift XML Converter allows you to import XML data and export it to a variety of formats including Excel, Access, CSV, etc. XML can be imported from a single file or data can be merged from multiple XML files at once. You can then select the data you want to export to Excel. This article takes you through a walk through illustrating the procedure.

Swift XML Converter Data Preview.
Swift XML Converter

  • Start Swift XML Converter and click on the "Import XML" button on the toolbar.

    Starting Screen of Swift XML

  • In the XML File selection box, click on "Add File" and browse to the XML file location and select the XML file to import. Click Next to begin importing the XML file into Swift.

    Import XML File in Swift XML

  • If the XML file is large, the processing could take some time. You can stop the processing at any time by clicking on "Abort." If there are any errors importing the XML file, an entry is added in the "Error Encountered" list. You can double-click on the entry to get details of the error.

    Once the processing is complete click "Finish" to preview the imported data.

    Processing the XML File in Swift
			       XML Converter

  • The hierarchy of tables imported from XML is shown on the left "Tables" panel. Right-click in this panel and select "Expand All" to show all tables and columns imported from the XML elements and attributes.

    XML elements and attributes
			       imported as tables and columns are
			       shown in the left panel in Swift XML

  • To view the data in a table, Right-click on the table and click "Show Data". The data will be shown in the main window on the right. Details about the columns in the table will be shown in the "Columns" panel at the bottom. Shown are the type of the column: Attribute (from an XML attribute), Element (from an XML element) or Virtual (added by Swift during processing to track parent and child tables). The XPath of the column is also shown here along with the size of the column in characters.

    Previewing data imported from XML
			       in Swift XML Converter

  • To export the data in this particular table to Excel, right click in the Data Browser and select "Export to Excel".

    Export XML data to Excel in Swift
			       XML Converter

  • In the Excel Output Wizard, select the type of Excel output: Enhanced or Standard. The Enhanced output type exports with visual styles but may cause problems with data truncation. If that happens, select the "Standard" output type which uses ODBC to export the data to Excel.

    You can also specify the location where the output is to be saved by clicking on "Browse". Once that is done, click "Next" to begin saving the Excel spreadsheet. If the output size is large, the saving could take some time. Once that is completed, click Finish to view the output in Excel.

    Exporting XML data to Excel in
			       Swift XML Converter Processing output: export XML data
			       to Excel in Swift XML Converter

  • The XML data exported to Excel is shown here. Note that whatever columns you have selected have been exported to Excel.

    Viewing XML data exported to Excel
			       using in Swift XML Converter

  • In this walkthrough, we imported XML data from a file and exported data from a selected table to Excel. In a further article, we will see how to export all the data imported from XML into Excel.

Argon DataViz

Create Pivot Tables and Pivot Charts from Large Datasets.

Swift XML Converter

Query & extract XML data into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult Standard

Convert XML into Microsoft Excel (XLS), Microsoft Access (MDB or ACCDB), or CSV.

Exult SQL Server

Shred and import XML into SQL Server.

Exult MySQL

Import XML data into automatically created MySQL tables.

Exult Oracle

Import XML into Oracle.