How to output the Office 365 Roadmap as a spreadsheet
If you want to stay on top of what’s coming soon for Office 365, the Office blog will be the source for major announcements, but you’ll also want to keep an eye on the Office 365 roadmap – which also covers Office Online and . If the Office blog is going to cover a feature, the news will be there first, but smaller features may only be covered in the roadmap.
A bit of a friction I’ve run into quite a bit, is that because there’s so much goodness in the pipeline that it’s kind of clunky to try and advise people as to what’s on deck, what’s been launched and everything in between – clearly some of the major new feature sets getting launched are pretty hard to miss as there will generally be a major post on the Office blogs about it. However, often the peripheral improvements are useful to have good optics on.
Everyone loves tabular data, so let’s get this sucker into a spreadsheet so we can crunch the data easier!
Due to the number of features in the mix, it’s kind of essential to get the info from those two sources into a spreadsheet to be able to crunch it and also track it in the long term (monitor for changes).
I used a few Chrome Extensions, primarily “Data Scraper”, whipped up the XPath formulas required and exported as CSV.
Chrome Extensions Used:
Data Scraper: https://chrome.google.com/webstore/detail/scraper/nndknepjnldbdbepjfgmncbggmopgden?utm_source=chrome-app-launcher-info-dialog
Recipe Creator: https://chrome.google.com/webstore/detail/recipe-creator/icadidhenmiokjlmpdgjikdoknhfgkhg?utm_source=chrome-app-launcher-info-dialog
Xpath Helper: https://chrome.google.com/webstore/detail/xpath-helper/hgimnogjllphhhkhlmebbmlgjoejdpjl?utm_source=chrome-app-launcher-info-dialog
Here’s the Data Scraper rules I used – the XPath pattern used is to define the main repeating container of info, then divvy up the contents as they will be added as columns in Excel:
Status: ../../../div/div[contains(@class, “feature-group”)]/div
Link: ./div/div/div/div[contains(@class, “feature-item__more-info”)]/a/@href
Category 1: ./div/div/div/div[contains(@class, “feature-item__tag”)]
Category 2: ./div/div/div/div[contains(@class, “feature-item__tag”)]
Category 3: ./div/div/div/div[contains(@class, “feature-item__tag”)]
Image: ./div/div/div[contains(@class, “feature-image clear-fix col-md-12”)]/img/@data-original