Please FIX Quick Edit Mode (so it doesn't create duplicate items!)

---

Chris Gullicksen wrote:
I usually recommend pasting in about 100 rows of data at a time and then teaching the users to watch the little pre-loader validate and save each row after their paste. They also need to know that the order of the columns, formatting and required columns in the SharePoint list should be something they should be aware of to reduce any errors doing this work.

---

The testing I did yesterday with half that data (~50 rows) resulted in duplicates. And, yes, I was watching the pre-loader. In reality, though, how many end users do you support that will actually chunk their data like that and be patient. Those types of people are few and far between in the Higher Ed market (we're a University).

As it turns out, I did find a workaround: go to Classic Mode. The Quick Edit function in SP2013/Classic mode - in the 10 tests I did - did NOT create duplicates. It still took a long time to import the items, but it did so cleanly. Maybe in a couple years, Microsoft will have all of the bugs worked out of "Modern" lists, libraries and pages, but until then, we need to keep telling people to use Classic, which is frankly embarrassing. "Hey, check out this new SharePoint...doesn't it look great? Oh, but for this, this and that other thing, you need to switch to Classic mode." I'm glad we get to pay Microsoft for the experience of beta testing their products.