Forum Discussion
Importing data from a parent SharePoint site into excel
Hi, I'm trying to get data into an Excel worksheet from a list in SharePoint Online. I'm doing so through Data tab --> New Query --> From Other Sources --> From SharePoint List At the beginning, I ...
In SharePoint Online, the path to My sites is https://tenantname-my/sharepoint.com so I assume you are referring to Mysite as being your tenant.
All of the personal sites are not subsites directly so you can't get all subsites and you should be able to list any lists at that URL but it won't then traverse subsites.
If you are referring to the top level SharePoint site it will be your https://tenantname-my.sharepoint.com
All of the personal sites are not subsites directly so you can't get all subsites and you should be able to list any lists at that URL but it won't then traverse subsites.
If you are referring to the top level SharePoint site it will be your https://tenantname-my.sharepoint.com
- Just to add to that, the my sites top level URL wouldn't have any lists as it is just the navigation point with a specific template for hosting my sites.