In this SharePoint tutorial, we will discuss how to open a SharePoint list in Excel or export a SharePoint list to Excel. I will also show how to update Excel from a SharePoint list automatically.
Whenever integrating data sources like Excel sheets and SharePoint, you may want to update the newly added data in Excel to the existing SharePoint list.
In this Power Automate tutorial, I will explain how to create a new item in the SharePoint list from Excel data and how to update the SharePoint list from Excel using Power Automate.
Open SharePoint list in Excel
Now, let’s see how to Open the SharePoint list in Excel. We will connect with the SharePoint Online site using Excel.
I have created a custom list of Employees on my SharePoint Online site. The list looks like the one below, with some data.
Now, let us see how to open this SharePoint Online list in Excel.
First of all, Open an Excel file on your desktop.
Then click on Data -> Get Data -> From Online Services -> From SharePoint Online List like below:
Then, it will ask you to provide the SharePoint Online Site URL, as shown below. You can also provide the list URL, but you might get an error.
Once you click on OK, it will ask you to enter the Credentials. Here, first select Microsoft account.
It will show the Sign-in button if you have not already signed in with a Microsoft 365 account.
Click on the Sign-in button, and then it will ask you to enter the username and password.
Then, it will show you Signing in as a different user. Then select the SharePoint site where your list exists.
Then click on the Connect button.