Import Data from an Excel sheet in SharePoint

[CoboleiroBr]

Hello guys!

Could you help me connecting to a spreadsheet in SharePoint Online?

Here are the steps I'm following:

1 - Get data from web

2 - Paste the URL as follows:

     https://XXXXX.sharepoint.com/sites/XXXXX/_layouts/15/WopiFrame.aspx?sourcedoc=%7B00943100-b4ff-484a-...

3 - I got the below error:

     "Unable to connect: We encountered an error while trying to connect. Details: URL is invalid."

- In the first time trying to connect, it was asked to start the session with SharePoint, and it was ok;

- I have access to Sharepoint, both published site and spreadsheet

- If I try to open this URL in a new tab in Browser, it opens normally

- I tried to remove "&action=default" from URL, but I got the same problem

- I also tried to connect using bothlinks "to view" and "to edit", provided by SharePoint when you click "..." at the right side of the the file

What I'm doing wrong?

Thanks!

[sfibaek · Accepted solution]

I just faced the exact same problem. Solved it by getting the link to the Excel file on Sharepoint (right click -> get a link). You then need to manipulate the link a bit:

From:

 https://abcdef.sharepoint.com/sites/.../Shared%20Documents/Miscellaneous/dataset.xlsx?d=w81492e34112...

To:

https://abcdef.sharepoint.com/sites/.../Shared Documents/Miscellaneous/

Then get data -> Excel -> past the link above -> select the file.

/Sune

[sfibaek · Accepted solution]

I just faced the exact same problem. Solved it by getting the link to the Excel file on Sharepoint (right click -> get a link). You then need to manipulate the link a bit:

From:

 https://abcdef.sharepoint.com/sites/.../Shared%20Documents/Miscellaneous/dataset.xlsx?d=w81492e34112...

To:

https://abcdef.sharepoint.com/sites/.../Shared Documents/Miscellaneous/

Then get data -> Excel -> past the link above -> select the file.

/Sune

[CoboleiroBr · Accepted solution]

I can't connect as you explained, in the folder, then get data -> Excel. 

BUT after sucessive attempts, it worked changing the link as you described, like we are used to do in Windows Explorer, and the filename in the end, like that:

https://XXXXX.sharepoint.com/sites/XXXXX/Documentos Compartilhados/Book Gestão/File.xls

Thanks @sfibaek !