Comments on: Open SharePoint list in Excel + Update SharePoint List from Excel using Power Automate https://www.spguides.com/open-sharepoint-list-in-excel/ Learn SharePoint, Office 365, Nintex, PowerApps, PowerBI etc, SharePoint training and video courses Tue, 11 Jun 2024 11:15:04 +0000 hourly 1 https://wordpress.org/?v=6.6.2 By: Sasi https://www.spguides.com/open-sharepoint-list-in-excel/#comments/1040 Thu, 21 Sep 2023 06:37:10 +0000 https://www.spguides.com/?p=23243#comment-1040 Thank you. This post has been very helpful.

Now that the connection is established, can updates done in the Excel file automatically update in SharePoint. I understand updates done in SharePoint will reflect in Excel but would it be able to do that the other way around

]]> By: Maesha https://www.spguides.com/open-sharepoint-list-in-excel/#comments/1023 Tue, 11 Jul 2023 01:34:09 +0000 https://www.spguides.com/?p=23243#comment-1023 Thank you so much, this was the most helpful website

]]> By: Muhammad Kashif https://www.spguides.com/open-sharepoint-list-in-excel/#comments/988 Tue, 25 Apr 2023 21:27:43 +0000 https://www.spguides.com/?p=23243#comment-988 Hi,

Is there any way on updating excel it will automatically update the sharepoint list without using power automate?

]]> By: JB https://www.spguides.com/open-sharepoint-list-in-excel/#comments/761 Thu, 01 Sep 2022 17:39:50 +0000 https://www.spguides.com/?p=23243#comment-761 Hi I was wondering if there is a way to update the excel list once it was connected to update sharepoint list.

]]> By: Antoine https://www.spguides.com/open-sharepoint-list-in-excel/#comments/713 Mon, 20 Jun 2022 11:45:00 +0000 https://www.spguides.com/?p=23243#comment-713 In reply to Massimiliano Belletti.

Hi Mario, write data back is not possible “out of the box”.
You could do that with a 3rd party software that you install in Excel : Synchronizer for Excel and SharePoint. 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.)

]]> By: Antoine https://www.spguides.com/open-sharepoint-list-in-excel/#comments/712 Mon, 20 Jun 2022 11:44:35 +0000 https://www.spguides.com/?p=23243#comment-712 In reply to Benjamin Delos Santos.

Yes, follow the same steps.

]]> By: Antoine https://www.spguides.com/open-sharepoint-list-in-excel/#comments/711 Mon, 20 Jun 2022 11:44:15 +0000 https://www.spguides.com/?p=23243#comment-711 In reply to Swa.

Hi Swa,
it’s unfortunately impossible as Excel is not opened, it can’t change the file.
You could write some script that would open the file, refresh and save the file, but it’s getting more technical.

]]> By: Antoine https://www.spguides.com/open-sharepoint-list-in-excel/#comments/710 Mon, 20 Jun 2022 11:43:35 +0000 https://www.spguides.com/?p=23243#comment-710 In reply to Kathleen.

Hi Kathleen,
user names are usually well exported to Excel if these users are members of the site collection hosting your SharePoint list. (sorry for the late answer)

]]> By: Antoine https://www.spguides.com/open-sharepoint-list-in-excel/#comments/709 Mon, 20 Jun 2022 11:42:47 +0000 https://www.spguides.com/?p=23243#comment-709 In reply to Mario M.

Hi Mario, write data back is not possible “out of the box”.
You could do that with a 3rd party software that you install in Excel : Synchronizer for Excel and SharePoint. 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.)

]]> By: Mario M https://www.spguides.com/open-sharepoint-list-in-excel/#comments/644 Wed, 02 Mar 2022 12:12:06 +0000 https://www.spguides.com/?p=23243#comment-644 How can we write back data? Great tutorial.

]]>