2

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

3
  • 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 Apr 26, 2017 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, 2017 at 10:02
  • @Danny'365CSI'Engelman, sorry for very late answer, but indeed you can sync 2-way, with a 3rd party software, Synchronizer for Excel and SharePoint, synchronizer-for-excel-and-sharepoint.com. It will export your existing list to Excel, let you add rows in Excel, then sync it back to SharePoint as often as you want. After the sync, Excel also gets the updates from SharePoint, so that both always stay in Sync (Disclaimer: It is developed and maintained by my company.) Jun 20, 2022 at 11:40

1 Answer 1

2

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

2
  • I'm getting problem with exporting it to excel. But how will I have a sharepoint list option in sources
    – Rojan
    Apr 26, 2017 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. Apr 26, 2017 at 12:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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