...
OpenRefine or RefinePro ease the creation of API calls based on spreadsheet data, and come with HTML parsing functions that are sufficient for basic XML parsing
XSLT
Tutorials
Codecademy: APIs (tutorials for each specific API come with a “how to use APIs” lesson; coding languages vary)
...