Paste from Excel to Modern list Quick Edit
Classic SharePoint lists and libraries allow you to copy and paste from Excel in an intuitive manner (e.g. copy a row of data in Excel, these will paste into the Quick Edit view of a list across multiple fields of a single item, mirroring the data structure of your spreadsheet). Additionally, when using Classic mode Quick Edit on a SharePoint List, when pasting multiple rows of data, new list items are automatically created.
However, when using the Modern mode, all data from Excel is sometimes pasted into the single, selected cell. Sometimes this happens when attempting to create new list items at the bottom of the list, other times it occurs when pasting into a cell that's in the middle of the view. An error message inconsistently appears when pasting at the bottom of the view when it's expected that additional list items will be created, "The information cannot be pasted because the paste area is not completely within the grid. Paste into a different cell or try inserting more columns and/or rows into the grid."
This is not only unintuitive and a step back for end users that need to quickly add items in bulk. Veteran SharePoint users will be unable to convert an existing, simple operation to use the Modern UI. Additionally, this causes headaches for support teams due to the inconsistent behavior, and the inconsistent display of the error message does not help end users understand why they are unable to do what they are trying to do.
Please restore the ability to create new list items when using Quick Edit in SharePoint Modern UI mode, and make it work as reliably as Quick Edit in Classic does.
J Bedford commented
+1 absolutely agree. Pasting into the new Lists experience is painful. I was able to figure out how to paste from Excel, but could only do one row at a time. Not an acceptable method.
If copy/paste can't work, it'd be fine if there was a way to import into an existing SharePoint List from Excel or CSV or whatever, but this option does not exist either.
I understand that you can export from Excel into a /new/ List, but this results in unexpected column types that then need to be fixed, and also does not address the need to add new rows in bulk to an /existing/ list.