I have a problem on how will I connect my excel to SharePoint. I have created a list in SharePoint and I need those data sync in excel that I want to create. I'm using excel 2016 and SharePoint 2016. Please refer to this link because I think this is what I supposed to do. The problem there is that I can't see the "SharePoint List" option in my excel.

enter image description here

  • Excel can't sync to SharePoint, you can open a SharePoint list read-only in Excel, and that is it Microsoft Access can do read/write operations to SharePoint – Danny '365CSI' Engelman Apr 26 '17 at 10:00
  • how can I open it as ready only Sir? actually I need only to get the data and put it in my excel and when I make a changes in my sharepoint list it will also update in the excel – Rojan Apr 26 '17 at 10:02

Follow the steps in this article: https://support.office.com/en-gb/article/Export-a-list-to-Excel-in-SharePoint-Online-40f4b5cd-cb8a-4106-817e-4a0bf7cd68b5

If your list on the sharePoint gets updated, you will need to Refresh connection in excel in order to get the updated data from the SharePoint List.

enter image description here

  • I'm getting problem with exporting it to excel. But how will I have a sharepoint list option in sources – Rojan Apr 26 '17 at 11:51
  • Did you follow the steps in the article? What is the error? you need to provide more details for a precise answer. – SharePointer Apr 26 '17 at 12:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.