Syncing SharePoint Lists to Excel

Question

Hello,

I would like to know if anyone can sync a SharePoint list to Excel.

I saw this video where there was an option to link, but I do not see it anymore in the newer versions of Excel:
How To Connect a SharePoint List To Excel - YouTube

Ideally, I would link the SharePoint list to any Excel sheets to refer to the data entries.

Thank you!

Answer 1

Hi @John Bae

Thank you for posting your question in the Microsoft Q&A forum. 

Based on description, look likes you are missing Get Data under Data tab.

Get Data is a feature using Power Query add-in.

First, may I know which Excel version are you using?

Please know that if you are using Excel on the web, this feature is not available.

For Excel 2010 and 2013, these versions require Power-Query add-in. You can download it via Download Microsoft Power Query for Excel from Official Microsoft Download Center

For Excel 2016 or newer, and Excel 365, where Power Query capabilities are integrated within the Data tab.

You can find more details at A History of Power Query in Excel.

Please provide more information so I can assist you better.

I'm looking forward for your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.