Forum Discussion

CoboleiroBr's avatar
CoboleiroBr
Helper I
9 years ago
Solved

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.sha...
Need Help
sfibaek's avatar
sfibaek
Regular Visitor
9 years ago

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=w81492e3411244b26812306664d2a54f4

 

To:

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

 

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

 

/Sune

  • CoboleiroBr's avatar
    CoboleiroBr
    Helper I
    9 years ago

    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 !