Happy Spring!
I have a SharePoint List with InfoPath forms all set up but need to get many records that are in Excel spreadsheets, with columns not formatted correctly. I tried just copying and pasting the columns. It actually wasn't too bad, at least to start. I had to go down the columns where the imported data wasn't formatted correctly and fix each cell using Quick Edit - the quick edit cells had drop down controls to facilitate that and it went quick. It all looked pretty good until I was ready to stop editing. Then it told me that I cannot create new records in quick edit because I don't have all required fields. I displayed the ID field. I will not allow me to create a new ID. Not sure about other 'required' fields.
Is there any way to create new records in Quick Edit?
Is the any way to get excel data into and already created List?
Thanks