Sharepoint List updating from Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1905055%22%20slang%3D%22en-US%22%3ESharepoint%20List%20updating%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1905055%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20List%20setup%20that%20I%20want%20to%20update%20from%20an%20Excel%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20have%20an%20Actions%20Register%20in%20Excel%20that%20we%20update%20frequently%2C%20I%20would%20like%20to%20have%20my%20SharePoint%20list%20updating%20based%20upon%20edits%20made%20to%20the%20Excel%20table.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI.e.%20I%20open%20the%20SharePoint%20list%20each%20day%20and%20press%20refresh%20and%20it%20will%20populate%20based%20upon%20any%20changes%20or%20additions%20made%20to%20the%20Excel%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20how%20to%20copy%20and%20paste%20between%20the%202%2C%20how%20to%20export%26nbsp%3B%20a%20table%20to%20a%20new%20SharePoint%20list%2C%20how%20to%20export%20a%20list%20from%20SharePoint%20to%20Excel%20so%20please%20don't%20suggest%20any%20of%20these.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20sure%20there%20is%20a%20way%20to%20do%20what%20I%20want%20somehow%20as%20I%20have%20seen%20it%20done%20in%20the%20past%20from%20bigger%20companies%20I%20worked%20for%20where%20there%20is%20two-way%20connections%20between%20SharePoint%20and%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20knows%20how%20to%20do%20this%20please%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1905055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1905733%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20List%20updating%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1905733%22%20slang%3D%22en-US%22%3EFor%20sure%20this%20can%20be%20done%20programmatically%20by%20for%20instance%20creating%20a%20SPFx%20extension%20for%20your%20list%20that%20has%20the%20code%20required%20to%20read%20the%20Excel%20file%20and%20update%20the%20list.%20Another%20possibility%20you%20could%20explore%20here%20is%20if%20Power%20Automate%20could%20help%20to%20do%20the%20same%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

I have a SharePoint List setup that I want to update from an Excel list.

 

We have an Actions Register in Excel that we update frequently, I would like to have my SharePoint list updating based upon edits made to the Excel table.

 

I.e. I open the SharePoint list each day and press refresh and it will populate based upon any changes or additions made to the Excel list.

 

I know how to copy and paste between the 2, how to export  a table to a new SharePoint list, how to export a list from SharePoint to Excel so please don't suggest any of these.

 

I'm sure there is a way to do what I want somehow as I have seen it done in the past from bigger companies I worked for where there is two-way connections between SharePoint and Excel.

 

If anyone knows how to do this please help!

 

Thanks

1 Reply
For sure this can be done programmatically by for instance creating a SPFx extension for your list that has the code required to read the Excel file and update the list. Another possibility you could explore here is if Power Automate could help to do the same