Categories
advanced

How to extract data from an XML file using Google sheets

Create Google sheets

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.

Categories
google

How to add Google Sheets to your dock

I’ve started using Google Sheets a lot lately. You can┬ámake a link straight to Google Sheets on your desktop or dock so that you can access it more easily. Read on to find out how.