Automating data from a form (of some sort) into a SharePoint list

[sincy]

Hi all,

My workplace keeps a SharePoint List as a tracker of all incoming work requests on our 'new work form' which is an Excel sheet.

The problem is that an employee has to sit an manually read the information from the excel sheet and then type the necessary information into the relevant fields on the SharePoint list.

Is there a way to set something up so that the new work form can be 'read' by the SharePoint and the relevant fields extracted into the SharePoint from the excel list?

(I know one answer could be to just allow the person writing the new work form to write directly into the SharePoint but this creates control issues)

Thanks!!!

 

[JonXL]

You can use Quick Edit/edit in list view on the SP list and then basically copy-paste the excel rows into the bottom of the list (columns should be arranged the same on both).

Edit list items

Edit a single item in list view, or be more productive by editing several items in grid view.

support.microsoft.com

Other options, too, but that might be the quickest.