How to query data from SharePoint Online list in Excel

I am trying to import data into Excel from a list on SharePoint Online. I am able to connect to the list using the standard data connections feature in Excel, which allows connection to various web s...