Sharepoint lists - duplicate rows when uploading/importing excel file

Occasional Visitor

Hello! 

 

Has anyone else experienced SharePoint automatically duplicating list items when uploading the list via an excel workbook/csv? I've encountered this problem 100% of the time and am not sure why it's duplicating everything 3 times each time a list is created... 

 

I do want to note that this only happens when I upload the excel/lists under my organization's SharePoint channels - when I uploaded this under "my lists," it didn't seem to happen. Your suggestions/insight is greatly appreciated!  

 

My test excel:

cinna103_6-1676361225853.png

 

My steps to creating the sharepoint list: 

cinna103_0-1676360782811.png

cinna103_1-1676360806959.png

everything is duplicated 3 times: 

cinna103_7-1676361260855.png

 

 

 

4 Replies

@cinna103 I just tried following same steps and creating a list by importing excel file in both SharePoint site as well as in "My Lists". I am unable to reproduce this issue on our SharePoint tenant.

 

Can you creating list by:

  1. Using another M365 tenant (if you have any)
  2. Using Different SharePoint site in same tenant
  3. Clearing browser cache and cookies

If it does not work, raise support ticket with Microsoft directly: Get M365 Support - Online Support 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

I'm also having this exact issue! Completely identical. No probs uploading Excel table to My Lists, but using the Sharepoint site/channel it triplicates the first 50 rows or so. It's very frustrating.

Edit: it started with my co-op student having the issue. The problem persisted when I tried it as well. We got the same "we can't reproduce the issue" response.

Edit 2: Did you figure it out or are you still having the issue?

I am experiencing the exact problem!
Hi, same problem here.
First 50 rows are triplicated each time a list is created from Excel.
It started from a single user and now it has spreaded throughout the whole organization.
Very frustrating and strange behaviour.