Home

How to update a sharepoint list from excel table?

%3CLINGO-SUB%20id%3D%22lingo-sub-749584%22%20slang%3D%22en-US%22%3EHow%20to%20update%20a%20sharepoint%20list%20from%20excel%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749584%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%202013%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20lot%20of%20working%20excel%20workbooks%2C%20that%20are%20update%20on%20daily%20basis%20from%20several%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20wish%20to%20push%20to%20a%20Sharepoint%20list%20a%20standard%20content%20(table)%20in%20order%20to%20create%20only%20one%20table%20for%20making%20reports%20and%20comparisons%20among%20all%20worksheets%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20previous%20Excel%20version%20there%20was%20an%20add-on%20available%20to%20do%20this%20job%20(syncronizewssandexcel.xlam)%2C%20but%20now%20I%20am%20not%20able%20to%20find%20it%20(seems%20deprecated).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20out%20from%20this%20stumbling%20block%3F%20There%20is%20another%20supported%20method%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-749584%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754443%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20update%20a%20sharepoint%20list%20from%20excel%20table%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754443%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F374656%22%20target%3D%22_blank%22%3E%40Danimat%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUnfortunately%2C%20over%20the%20course%20of%20the%20last%20few%20years%2C%20the%20previously%20strong%20link%20between%20Excel%20workbooks%20and%20SharePoint%20lists%20has%20been%20neglected.%20It%20is%20now%20no%20longer%20easy%20to%20synchronize%20changes%20in%20an%20Excel%20workbook%20to%20a%20SharePoint%20list.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20are%20using%20SharePoint%20online%20with%20an%20Office%20365%20plan%20that%20includes%20Flow%2C%20you%20can%20build%20a%20flow%20to%20update%20a%20SharePoint%20list%20item%20when%20the%20Excel%20file%20is%20changed.%20The%20mechanics%20of%20this%20has%20many%20moving%20parts%2C%20though%2C%20and%20requires%2C%20if%20not%20programming%20skills%2C%20at%20least%20a%20programmer's%20understanding%20of%20how%20data%20is%20stored%20and%20retrieved.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Danimat
Occasional Visitor

Excel 2013

 

I have lot of working excel workbooks, that are update on daily basis from several users.

 

I wish to push to a Sharepoint list a standard content (table) in order to create only one table for making reports and comparisons among all worksheets data.

 

In the previous Excel version there was an add-on available to do this job (syncronizewssandexcel.xlam), but now I am not able to find it (seems deprecated).

 

How can I get out from this stumbling block? There is another supported method?

 

1 Reply

@Danimat 

Unfortunately, over the course of the last few years, the previously strong link between Excel workbooks and SharePoint lists has been neglected. It is now no longer easy to synchronize changes in an Excel workbook to a SharePoint list.

 

If you are using SharePoint online with an Office 365 plan that includes Flow, you can build a flow to update a SharePoint list item when the Excel file is changed. The mechanics of this has many moving parts, though, and requires, if not programming skills, at least a programmer's understanding of how data is stored and retrieved.

 

Related Conversations