I am trying to import an Excel Spreadsheet that is stored on sharepoint online. Data - Get Data - From Sharepoint Folder.

It then asks you for Sharepoint Site Url.

The folders are then listed but I cannot find a way to locate a specific workbook within a folder within the site.

This was straightforward when spreadsheet was stored on Onedrive.

Can anyone help?

There is very little on google searches. Mostly talks about importing to Power BI.