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 Outlook.com. 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:

Container: //article/div[2]/div/div/div[1]/div
Status: ../../../div[1]/div[1][contains(@class, “feature-group”)]/div[1]
Title: ./div[1]/div[1]
Description: ./div[2]/div[1]
Link: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__more-info”)]/a[1]/@href
Category 1: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][1]
Category 2: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][2]
Category 3: ./div[2]/div[2]/div[1]/div[contains(@class, “feature-item__tag”)][3]
Image: ./div[2]/div[3]/div[contains(@class, “feature-image clear-fix col-md-12”)]/img[1]/@data-original

This article does not advocate automatically polling the Office 365 Roadmap page. No one likes bots hammering their pages – you are obligated to play nice according to Microsoft.com’s terms of use. This extensions/scripts described here work on the clientside browser only. Please manually download an offline copy of the page and do your work on that.