Tag: Google Sheets
Automatically update the name of a Google sheet
There are some times that I use Google Sheets instead of Numbers. One example is to create our weekly run sheets for church. A runsheet looks like this: You will notice the tabs across the bottom of the spreadsheet. It was getting a bit tedious changing the tab name every week. So I wrote/modified/hacked together…
How to extract data from an XML file using 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…