Get data using sharepoint

Thanks Ritaf1983 for your quick reply. I have the editing access to the file and all.  The link looks something like this. I didn't understand this part "Enter the URL of the SharePoint site (not the file itself) and navigate to the folder containing the Excel file" . Exactly which part of the URL should I enter the SiteURL . 

I tried putting the root URL till the personal/<useremail> part but getting this error

Thanks ThomasWeppler 

Hi again, you don't need all the paths.
Please refer to the linked video:
https://www.youtube.com/watch?v=F6hUJNluBu8

(from minute 2 )

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

Thanks Ritaf1983 . The video helped