Updating SharePoint List from Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-36525%22%20slang%3D%22en-US%22%3EUpdating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36525%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F37%22%20target%3D%22_blank%22%3E%40John%20White%3C%2FA%3E%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%20is%20there%20a%20way%20to%20update%20a%20sharepoint%20list%20from%20Excel%3F%20(other%20than%20through%203rd%20party%20tools%20like%20SoftFluent's%20Sharepoint%20list%20synchronizer%3F%20%3CA%20href%3D%22http%3A%2F%2Fwww.softfluent.com%2Fproduct%2FsharePoint-list-synchronizer%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3ESharePoint%20List%20Synchronizer)%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-36525%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-394344%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-394344%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3E%26nbsp%3BIs%20it%20possible%20to%20provide%20instruction%20on%20how%20to%20accomplish%20such%20tasks%2C%20please%3F%20I%20am%20a%20beginner%20user%20of%20SharePoint.%20I%20tried%20to%20recreate%20the%20SharePoint%20list%20with%20updated%20Excel%20file%20in%20document%20library%20using%20MS-Flow%20but%20somehow%20failed.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309870%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309870%22%20slang%3D%22en-US%22%3EI've%20used%20Flow%20to%20do%20this%20before%20as%20on%20selected%20item%20in%20a%20doc%20library%20and%20scheduled.%20You%20can%20use%20Get%20Rows%20from%20Excel%20if%20you%20store%20the%20file%20in%20a%20doc%20library%20or%20OneDrive%20and%20then%20add%20a%20create%20item%20in%20SharePoint.%20The%20Excel%20get%20rows%20has%20a%20500%20row%20limit%20so%20I%20used%20a%20loop%20to%20get%20batches%20of%20500%20and%20change%20the%20start%20row%20in%20the%20Get%20Row%20action%20based%20on%20a%20variable.%20You'll%20need%20to%20use%20a%20date%20or%20flag%20column%20in%20the%20spreadsheet%20to%20track%20which%20ones%20have%20been%20done%20and%20update%20it%20in%20the%20loop%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-309790%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-309790%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20copy%20and%20paste%20in%20Sharepoint%20265%20is%20limited%20to%2050%20rows%20at%20a%20time.%20If%20you%20copy%20more%20than%2050%20rows%20you%20may%20get%20errors.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36636%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36636%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F29128%22%20target%3D%22_blank%22%3E%40Andrew%20Koltyakov%3C%2FA%3E.%20%26nbsp%3BThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F33453%22%20target%3D%22_blank%22%3E%40Sergei%20Snitko%3C%2FA%3E.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36578%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36578%22%20slang%3D%22en-US%22%3ENothing%20to%20share%20from%20my%20side%2C%20Andrew%20and%20Sergei%20have%20explained%20very%20well%20the%20options%20you%20have%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36548%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36548%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Gilberto%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20depends%20on%20the%20usage%20scenario%20(one-time%20run%20or%20periodical%2C%20update%20by%20recreating%20all%20items%2C%20adding%20new%2C%20update%20existing%20by%20the%20key%2C%20should%20the%20list%20structure%20be%20the%20same%20or%20dynamic%2C%20amount%20of%20data%2C%20all%20of%20these%20make%20sense).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%26nbsp%3Bbasic%20cases%26nbsp%3Bone%20can%20use%20Excel's%20export%20to%20SharePoint%20list%20feature%20or%20inline%20editing%20feature%20and%20copy%20pasting%20for%20small%20data%20amount.%3C%2FP%3E%3CP%3EFor%20complex%20periodic%20and%20rollup%20data%20from%20numerous%20excel%20documents%20scenarios%20a%20customization%20probably%20is%20the%20best%20and%20only%20option.%20It%20can%20be%20the%20technology%20of%20choise%20to%20read%20data%20from%20Excel%20(let's%20say%20ClosedXML%20.Net%20library%20or%20XLSX.js%20Node.js%20or%20Excel%20COM%20automation)%20and%20technology%20to%20write%20and%20update%20data%20in%20SharePoint%20(CSOM%2C%20SSOM%20or%20REST%20APIs)%20and%20settings%20layer%20extention.%3C%2FP%3E%3CP%3EOr%203rd%20parties%2C%20as%20mentioned%20above.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-36542%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-36542%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EThere%20is%20a%20very%20simple%20solution%20and%20it%20can%20help%20you.%3C%2FP%3E%3CP%3E1.%20Open%20the%20SharePoint%20Online%20site%20in%20Internet%20Explorer%20and%20add%20in%20to%20trusted%20sites%3C%2FP%3E%3CP%3E2.%20Open%20the%20excel%20file%20and%20look%20at%20the%20columns%20and%20remember%20th%D1%83%26nbsp%3B%3CSPAN%3Esequence%20of%20them.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E3.%20Open%20the%20list%20you%20need%20in%20classic%20mode%20and%20edit%20the%20default%20view%2C%20or%20add%20a%20new%20view.%20You%20need%20to%20show%20the%20fields%20of%20the%20list%20that%20you%20need%20to%20map%20with%20excel%20columns.%20So%20as%20a%20result%2C%20you%20have%20to%20make%20the%20SharePoint%20table%20view%20the%20same%20like%20it%20looks%20in%20Excel%3C%2FP%3E%3CP%3E4.%20Click%20the%20Edit%20button%20in%20the%20table%20view%2C%20and%20the%20table%20view%20changes%20to%20the%20edit%20mode.%26nbsp%3B%3C%2FP%3E%3CP%3E5.%20Open%20the%20excel%20table%20and%20select%20the%20area%20you%20need.%20Press%20ctrl%2Bc%20on%20tha%20keyboard%3C%2FP%3E%3CP%3E6.%20Open%20the%20SharePoint%20view%2C%20select%20the%20first%20cell%20and%20press%20ctrl%2Bv%20on%20the%20keyboard.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETha%20data%20is%20imported.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-920950%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-920950%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F180%22%20target%3D%22_blank%22%3E%40Alan%20Marshall%3C%2FA%3EDo%20you%20have%20a%20Flow%20process%20for%20updating%20existing%20items%20in%20a%20list%20from%20Excel%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1039845%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039845%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F313823%22%20target%3D%22_blank%22%3E%40Ted-28%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAssuming%20you%20are%20using%20Sharepoint%20Online%20(SPO)%20or%20'19%2C%20Here%20might%20be%20the%20place%20to%20start%20for%20that%20task%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fedit-list-items-in-sharepoint-online-dac1a1c3-a80b-4082-ba57-715cf613d0f7%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fedit-list-items-in-sharepoint-online-dac1a1c3-a80b-4082-ba57-715cf613d0f7%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20are%20using%20earlier%20versions%20of%20Sharepoint%2C%20the%20process%20is%20quite%20similar%20with%20the%20exception%20%22Quick%20View%22%20is%20called%20%22Edit%20in%20Datasheet%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20likely%20get%20a%20much%20speedier%20answer%20to%20queries%20posted%20here%20if%20you%20first%20ensure%20the%20answer%20is%20not%20easily%20available%20within%20the%20Microsoft%20Help%2FSupport%2FTraining%20pages.%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Fsharepoint%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Fsharepoint%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1039899%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039899%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F458843%22%20target%3D%22_blank%22%3E%40bronniecplace%3C%2FA%3EThank%20you%20for%20looking%20for%20answers%20on%20this%20topic.%20I've%20been%20watching%20it.%20Your%20reply%20doesn't%20address%20how%20to%20make%20these%20edits%20in%20Excel.%20Meaning%2C%20if%20I%20have%20an%20Excel%20spreadsheet%20linked%20to%20SharePoint%2C%20can%20I%20have%20it%20set%20to%20update%20particular%20columns%20for%20items%20already%20added%20and%20synced.%20For%20example%2C%20if%20I%20have%20an%20inventory%20list%20in%20excel%20that%20is%20set%20to%20export%20to%20SharePoint%2C%20can%20I%20edit%20prior%20rows%20(maybe%20like%20a%20quantity%20column%20that%20has%20how%20many%20of%20the%20item%20I%20have%20on%20hand)%20and%20have%20Excel%20recognize%20that%20the%20change%20needs%20to%20update%20an%20existing%20row%20and%20not%20create%20a%20new%20row.%20The%20goal%20is%20to%20be%20able%20to%20automate%20the%20update%20to%20existing%20rows%20on%20SharePoint%20using%20a%20master%20list%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1039983%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1039983%22%20slang%3D%22en-US%22%3Ethe%20answer%20to%20this%20question%20is%20now%20well%20detailed%20on%20the%20original%20thread.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1079058%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1079058%22%20slang%3D%22en-US%22%3EI%20happen%20to%20know%20that%20January%2010%2C%202020%20..%20Fusion%20Free-Edition%20Is%20launching%2C%20and%20it%20does%20that%20and%20100%20other%20tasks%20on%20steroids!%3CBR%20%2F%3EStay%20tuned%20%3A)%3C%2Fimg%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1104085%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104085%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20is%20FINALLY%20here!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhile%20we%20are%20all%20waiting%20this%20freeware%20has%20turned%20up%20and%20does%20the%20job.%3C%2FP%3E%3CP%3Edownload%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.nocodesolution.com%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.nocodesolution.com%2F%3C%2FA%3E%3C%2FP%3E%3CP%3Efeature%20list%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.nocodesolution.com%2Ffusion%2F1%2Fen%2Ftopic%2Ffusion-feature-list%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.nocodesolution.com%2Ffusion%2F1%2Fen%2Ftopic%2Ffusion-feature-list%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%2F%20Steen%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1130771%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1130771%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4027%22%20target%3D%22_blank%22%3E%40Gilbert%20Okello%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ECreate%20Office365%20SharePoint%20List%20from%20a%20CSV%20file%20and%20get%20the%20data%20transferred%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EHere%20is%20a%204%20minute%20video%20that%20shows%20you%20-%20and%20it%20is%20ALL%20FREE!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fposts%2Fsteen-jakobsen-4462b914_create-office365-sharepoint-list-from-a-csv-activity-6627133237015654400--pZb%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fposts%2Fsteen-jakobsen-4462b914_create-office365-sharepoint-list-from-a-csv-activity-6627133237015654400--pZb%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1169014%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20SharePoint%20List%20from%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1169014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F4027%22%20target%3D%22_blank%22%3E%40Gilbert%20Okello%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Etry%20thuis%20..%20it%20is%20FREE%20and%20x10%20better%20than%20any%20suggested%20solution%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.linkedin.com%2Fposts%2Fsteen-jakobsen-4462b914_office365-sharepoint-excel-activity-6632616655111372800-efKE%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.linkedin.com%2Fposts%2Fsteen-jakobsen-4462b914_office365-sharepoint-excel-activity-6632616655111372800-efKE%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

@John White, @Juan Carlos González Martín  is there a way to update a sharepoint list from Excel? (other than through 3rd party tools like SoftFluent's Sharepoint list synchronizer? SharePoint List Synchronizer)

15 Replies
Highlighted

Hello

There is a very simple solution and it can help you.

1. Open the SharePoint Online site in Internet Explorer and add in to trusted sites

2. Open the excel file and look at the columns and remember thу sequence of them.

3. Open the list you need in classic mode and edit the default view, or add a new view. You need to show the fields of the list that you need to map with excel columns. So as a result, you have to make the SharePoint table view the same like it looks in Excel

4. Click the Edit button in the table view, and the table view changes to the edit mode. 

5. Open the excel table and select the area you need. Press ctrl+c on tha keyboard

6. Open the SharePoint view, select the first cell and press ctrl+v on the keyboard.

 

Tha data is imported. 

Highlighted

Hi Gilberto,

 

It depends on the usage scenario (one-time run or periodical, update by recreating all items, adding new, update existing by the key, should the list structure be the same or dynamic, amount of data, all of these make sense).

 

For basic cases one can use Excel's export to SharePoint list feature or inline editing feature and copy pasting for small data amount.

For complex periodic and rollup data from numerous excel documents scenarios a customization probably is the best and only option. It can be the technology of choise to read data from Excel (let's say ClosedXML .Net library or XLSX.js Node.js or Excel COM automation) and technology to write and update data in SharePoint (CSOM, SSOM or REST APIs) and settings layer extention.

Or 3rd parties, as mentioned above.

Highlighted
Nothing to share from my side, Andrew and Sergei have explained very well the options you have :)
Highlighted
Highlighted

The copy and paste in Sharepoint 265 is limited to 50 rows at a time. If you copy more than 50 rows you may get errors.

Highlighted
I've used Flow to do this before as on selected item in a doc library and scheduled. You can use Get Rows from Excel if you store the file in a doc library or OneDrive and then add a create item in SharePoint. The Excel get rows has a 500 row limit so I used a loop to get batches of 500 and change the start row in the Get Row action based on a variable. You'll need to use a date or flag column in the spreadsheet to track which ones have been done and update it in the loop
Highlighted

@Alan Marshall Is it possible to provide instruction on how to accomplish such tasks, please? I am a beginner user of SharePoint. I tried to recreate the SharePoint list with updated Excel file in document library using MS-Flow but somehow failed. Thanks in advance.

Highlighted

@Alan MarshallDo you have a Flow process for updating existing items in a list from Excel?

Highlighted

@Ted-28 

 

Assuming you are using Sharepoint Online (SPO) or '19, Here might be the place to start for that task: https://support.office.com/en-us/article/edit-list-items-in-sharepoint-online-dac1a1c3-a80b-4082-ba5...

 

If you are using earlier versions of Sharepoint, the process is quite similar with the exception "Quick View" is called "Edit in Datasheet"

 

You will likely get a much speedier answer to queries posted here if you first ensure the answer is not easily available within the Microsoft Help/Support/Training pages.  https://support.office.com/en-us/sharepoint

 

 

Highlighted

@bronniecplaceThank you for looking for answers on this topic. I've been watching it. Your reply doesn't address how to make these edits in Excel. Meaning, if I have an Excel spreadsheet linked to SharePoint, can I have it set to update particular columns for items already added and synced. For example, if I have an inventory list in excel that is set to export to SharePoint, can I edit prior rows (maybe like a quantity column that has how many of the item I have on hand) and have Excel recognize that the change needs to update an existing row and not create a new row. The goal is to be able to automate the update to existing rows on SharePoint using a master list in Excel.

Highlighted
the answer to this question is now well detailed on the original thread.
Highlighted
I happen to know that January 10, 2020 .. Fusion Free-Edition Is launching, and it does that and 100 other tasks on steroids!
Stay tuned :)
Highlighted

It is FINALLY here!!!

 

While we are all waiting this freeware has turned up and does the job.

download: https://www.nocodesolution.com/

feature list: https://docs.nocodesolution.com/fusion/1/en/topic/fusion-feature-list

 

 

// Steen

Highlighted

@Gilbert Okello 

 

Create Office365 SharePoint List from a CSV file and get the data transferred

Here is a 4 minute video that shows you - and it is ALL FREE!

 

https://www.linkedin.com/posts/steen-jakobsen-4462b914_create-office365-sharepoint-list-from-a-csv-a...

Highlighted