Sharepoint Quick Edit creates duplicates

Question

Hello, I am currently using Sharepoint online for office 365. I am not familiar with it as I used Sharepoint 2010 in my previous job. I have a list that I am copying data over from excel in quick edit. When I paste the data into sharepoint it is creating duplicate items randomly in the list. It duplicates the entire thing so I have double of every item in there. Please help.

Answer 1

I found the same issue, pasting a simple 47 row, 3 column table from excel to a custom list in SharePoint online. Using Edge from the latest version of Windows 10 x64. This has not been the case when using quick edit previously. 

One of my columns contains a lookup, which I suspect may be the culprit. 

A possible workaround, that at least worked in my case, was to first copy only the content of the "Title" column, effectively creating a number of empty items. Then I could paste the remaining columns without any duplicates being created.

Answer 2

I have had this issue as well.  I found that this will duplicate every four entries.  The only workaround I have found is to ONLY PASTE 3 ROWS at a time.  This made updating 80 rows cumbersome, but it beats overwriting existing data and losing it forever.  I highly suggest backing up lists in SP regularly.

Answer 3

Sharepoint is very poorly engineered and many things that are supposed to work are unreliable and inconsistent. Can you try with a few rows from a spreadsheet and describe the exact steps you take and what exactly the results are?