Home » XML » [Video] Convert XML to Excel

[Video] Convert XML to Excel

by Maciek

Maciek is the Co-founder of Sonra. He has a knack for turning messy semi-structured formats like XML, JSON, and XSD into readable data. With a brain wired for product and data architecture, Maciek is the magic ingredient to making sure your systems don’t just work—they shine.

Published on July 11, 2017
Updated on November 20, 2024

Converting XML to Excel without writing any Code

In this video we will show you how Flexter’s powerful XML Converter and Excel work together to unlock insights hidden in XML. We process the XML files in the Flexter. Flexter generates tab separated text files (TSV) as output. Flexter automatically generates the relationships and keys between data sets. We can join and analyse the output files using Excel.
You can download the XML files that we use in the video from our website.

The XML conversion goes through the following sequence of steps

• Upload XML files to Flexter
• Convert the XML to text files (Tab Separated Values, TSV)
• Import the text files to Excel
• Join the data sets in Excel
• Analyse the data in an Excel PowerPivot table

Which data formats apart from XML also give you the heebie jeebies and need to be liberated? Please leave a comment below or reach out to us.

About the author:

Maciek

Co-founder of Sonra

Maciek is the Co-founder of Sonra. He has a knack for turning messy semi-structured formats like XML, JSON, and XSD into readable data. With a brain wired for product and data architecture, Maciek is the magic ingredient to making sure your systems don’t just work—they shine.

Follow Maciek: