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
Highlighted
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
Highlighted

@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
Subtotals or Vlookups or Both.
Kwesi_Quartey in Excel on
1 Replies
Excel for Mac - Point as separator in a German Excel
Mr_Geo91 in Excel on
2 Replies
Recovery & Solving the problem
Seve16640 in Excel on
0 Replies
Imported mdb tables not opened in the same Sheet
JozefMJ in Excel on
0 Replies
Excel freezes in secondary monitor
manuelzamora in Excel on
0 Replies