How to Export Microsoft 365 Roadmap to a CSV File


Slice and Dice the Roadmap

As reported earlier this week, Microsoft has merged the Office 365 Roadmap into a new Microsoft 365 Roadmap. The ability to filter roadmap items via feature (like Outlook) or service (like SharePoint Online) has always been in the roadmap, but it’s even more useful to use the Download button to write the filtered items (or the entire roadmap) to a CSV file that can be analyzed using Excel or imported into Power BI. This was supported for Office 365 in the past, now you can include Windows 10 and Enterprise Mobility & Security roadmap items.

The downloaded file is named Microsoft365RoadMap_Features_date.csv.

Each line in the file holds the information about a single roadmap item. The following fields are included:

  • Id: A five-digit identifier for the roadmap item.
  • Title: Headline descriptor for the item. For example, “SharePoint mobile: organizational news support.”
  • Description: Notes about what the roadmap item involves. For example, “As you tap into the SharePoint mobile app News tab, you’ll now see support for organizational news – which brings more greater control, process and reach to how news can be published throughout your organization.”
  • Status: The current deployment status for the roadmap item. This will be “Launched” or “In development” or “Rolling out.”
  • MoreInfoLink: If available, the URL to a page containing extra information about the roadmap item.
  • Tags: One or more tags to identify the parts of Microsoft 365 that the roadmap item belongs to. For example, “O365, SharePoint” or “Exchange.”
  • Added Date: The date that Microsoft originally added the item to the roadmap.  The date is in U.S. format, so 8/29/2018 is 29 August 2018.
  • Last Modified: The date that Microsoft last updated the item.
  • PublicDisclosureAvailabilityDate: The time frame that Microsoft expects the roadmap item to be available to customers. This might be as specific as a month or use a longer period, such as Q4 CY2018 (fourth quarter of calendar year 2018).

Microsoft intends that customers can use the information in the download file to help plan for the introduction of Microsoft 365 features into their tenant. Given the number of changes that happen within Office 365 and the other Microsoft 365 components, it’s a worthwhile advice.

Head over to the Microsoft 365 roadmap, download items, and start analyzing…

We cover the topic of keeping up to date with Microsoft 365 in Chapter 1 of the Office 365 for IT Pros eBook. But keeping up to date is what we’re all about, so the entire book reflects our best effort at documenting what’s current inside Office 365. We hope that you like that.

2 Replies to “How to Export Microsoft 365 Roadmap to a CSV File”

  1. Hi Tony, do you have any idea how we can make it auto export the Microsoft 365 roadmap instead of having to manual clicking on the download button?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.