top of page
Writer's pictureSarah Angell

How to output the Office 365 Roadmap as a spreadsheet

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

roadmap-650-80

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

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>/divStatus: ../../../div<1>/div<1>/div<1>Title: ./div<1>/div<1>Description: ./div<2>/div<1>Link: ./div<2>/div<2>/div<1>/div/a<1>/@hrefCategory 1: ./div<2>/div<2>/div<1>/div<1>Category 2: ./div<2>/div<2>/div<1>/div<2>Category 3: ./div<2>/div<2>/div<1>/div<3>Image: ./div<2>/div<3>/div/img<1>/@data-original Note: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.

2 views0 comments

Recent Posts

See All

M365 Community Content

There is a huge amount of great content available at https://docs.microsoft.com/en-ca/microsoft-365/community/ This repository is here...

Comments


bottom of page