cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
CoboleiroBr Regular Visitor
Regular Visitor

Import Data from an Excel sheet in SharePoint

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."

 

Erro.png

 

- 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!

2 ACCEPTED SOLUTIONS

Accepted Solutions
sfibaek Frequent Visitor
Frequent Visitor

Re: Import Data from an Excel sheet in SharePoint

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 Regular Visitor
Regular Visitor

Re: Import Data from an Excel sheet in SharePoint

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 !

 

 

2 REPLIES 2
sfibaek Frequent Visitor
Frequent Visitor

Re: Import Data from an Excel sheet in SharePoint

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 Regular Visitor
Regular Visitor

Re: Import Data from an Excel sheet in SharePoint

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 !