(This doesn't necessarily relate to Endings, since it's for the WEA, but this is something that might be broadly useful for other HCMC projects and I want to record it somewhere.) 

For WEA, we need to convert a massive, complex spreadsheet and turn it into a simple CSV to be ingested by Asana. That's fairly straightforward usually: download the spreadsheet in ODS, either unzip it or convert it to FODS, and then manipulate the underlying XML. But this spreadsheet was more difficult, as it used a HYPERLINK formula, which contains information that we want in our Asana descriptions. And since the underlying XML of these things is complex, I wanted to use an existing conversion process (like in OxGarage) that gets rid of the majority of the cruft. 

But most of these don't process the HYPERLINK function. A simple solution that I've stumbled on looks something like this:

1. First download the spreadsheet as Excel
2. Then, do a control find for =HYPERLINK and search in formula
3. Simply replace =HYPERLINK with `=HYPERLINK

Save that, and now it can get passed through OxGarage with the `=HYPERLINK as literal text in a cell that can be manipulated simply using a Regex. 

It's a completely brute force method of handling it, but it seems like the simplest for a conversion process.