XML is a format that some applications use to share data. For example I use a metronome called ‘Tempo’ on my iPhone. It allows me to share the tempos of all my songs by exporting an ‘XML’ file to an email.

This document can be read by the tempo app and it contains all the information about my tempos but it’s very hard to read and I would like to share the tempos with other people in a clearer format.

Here’s how to get the data out of such a file and into a spreadsheet.  This should work for any XML file that you need to parse.

Continue reading ⟩