Updating data in Sharepoint 2019 on prem List using excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2595652%22%20slang%3D%22en-US%22%3EUpdating%20data%20in%20Sharepoint%202019%20on%20prem%20List%20using%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595652%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20a%20list%20in%20SP2019%20on%20prem.%20I%20need%20to%20update%20a%20lot%20of%20fields%20that%20broke%20during%20the%20SharePoint%20migration.%20For%20example%2C%20data%20in%20an%20entire%20column%20is%20messed%20up.%20Instead%20of%20opening%20each%20item%20in%20the%20list%20and%20editing%20(I%20have%20hundreds%20of%20rows)%20I%20am%20wondering%20if%20there%20is%20a%20way%20to%20synch%20the%20list%20with%20excel%20so%20I%20can%20drag%20and%20copy%20rows%20that%20would%20have%20the%20same%20data.%20The%20problem%20is%20that%20the%20SP%20site%20is%20live%20and%20lots%20of%20people%20use%20it%2C%20so%20I%20cannot%20do%20an%20export%20to%20excel%2C%20fix%20the%20data%20and%20reupload%20because%20I%20would%20override%20the%20changes%20that%20are%20happening%20in%20the%20site%20while%20I%20am%20working.%20I%20can't%20freeze%20the%20site%20either.%3C%2FP%3E%3CP%3EIs%20there%20a%20functionality%20similar%20to%20the%20way%20we%20can%20open%20MS%20Teams%20files%20in%20excel%20and%20edit%20them%20in%20excel%3F%20I%20tried%20creating%20a%20channel%20in%20Teams%20and%20open%20it%20in%20SharePoint%20but%20it%20will%20not%20let%20me%20because%20our%20company's%20Teams%20is%20on%20the%20cloud%20and%20our%20SP%20is%20on%20prem...%20So%2C%20any%20suggestions%20on%20how%20I%20can%20edit%20a%20lot%20of%20data%20in%20the%20SharePoint%20List%20easily%2C%20without%20having%20to%20open%20one%20by%20one%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2595652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%202019%20On-Prem%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello, I have a list in SP2019 on prem. I need to update a lot of fields that broke during the SharePoint migration. For example, data in an entire column is messed up. Instead of opening each item in the list and editing (I have hundreds of rows) I am wondering if there is a way to synch the list with excel so I can drag and copy rows that would have the same data. The problem is that the SP site is live and lots of people use it, so I cannot do an export to excel, fix the data and reupload because I would override the changes that are happening in the site while I am working. I can't freeze the site either.

Is there a functionality similar to the way we can open MS Teams files in excel and edit them in excel? I tried creating a channel in Teams and open it in SharePoint but it will not let me because our company's Teams is on the cloud and our SP is on prem... So, any suggestions on how I can edit a lot of data in the SharePoint List easily, without having to open one by one? Thanks!

0 Replies