There is a custom list with students' identification numbers, branches will update the student applications in particular SharePoint list. all applications are processing at centralized unit. branch staff needs to check the status of such applications.

Centralized staff have to update each item in the sharepoint list. can we update specific amount of applications at one time by uploading excel file in to that sharepoint list. is there a option ?

  • 1
    Did you try copy paste from excel to your SharePoint List in Quick edit mode ? – Karthik Jaganathan Dec 12 '19 at 13:12

I agree with Karthik's method, you can try to copy the data in excel directly and paste it into the list in a quick edit mode.

enter image description here

In addition, set up the same column in the list as in excel files.

enter image description here

  • how to map such applications in Share point, I have to filter one by one and then paste – Sameera Dec 14 '19 at 18:34
  • If the number of files is large, it is recommended to refer to the synchronization method provided by Karthikeyan – Binggo_ MSFT Dec 16 '19 at 2:30

Approach 1:

Using two-way synchronization, we can achieve the requirement. I have shared below the reference link

Ref: https://www.synchronizer-for-excel-and-sharepoint.com/product-documentation/

Approach 2 :

  1. Add additional column to list and hide it into the view.
  2. Export the list to excel(Click Refresh All to get recent data).
  3. Please update the excel where you want
  4. Build Powershell and use PS to push the updated values into list based upon additional column.

Note: Periodically schedule the PS/ Run PS manually

Ref : https://support.office.com/en-us/article/export-to-excel-from-sharepoint-bfb2ea48-6118-4fa9-abb6-cced9424e5d9

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.