Office 365 Advent Calendar – 05 Exporting large SharePoint Online List to Excel

Scenario You have a list in SharePoint Online with more than 5,000 items, potentially much more than that. And you now plan to export all that data into Excel, for example for further analysis. The question now is – how do you get all that data out of SharePoint and into Excel? When you create a view to show all items, you’ll get a “The number of items in this list exceeds the Details