1

I'm trying to paste data from an excel spreadsheet to an already existing SharePoint 2013 list. The spreadsheet and the list have the same format and there are no conflicting values.

The problem is that the spreadsheet contains upwards of 10.000 entries and everytime I try to paste the data into the list the browser (Internet Explorer 11) freezes.

Is there any other way to copy the data into the list?

  • 1
    Test pasting few rows, I've found that Sharepoint struggles to update a lot of rows at once. e.g. try pasting 50, then 100 and see how it goes. You could also try pasting fewer columns and see if it can handle more rows that way. Then paste in the other remaining column values later. – Tally Jan 22 '18 at 12:00
2

I tried to do the same as you (1000+ rows) and the behavior of the browser was exactly the same. After reading more carefully the documentation Software boundaries and limits for SharePoint 2013 I found the following row for bulk operations via user interface:

The user interface allows a maximum of 100 items to be selected for bulk operations.

I think that is applicable and for pasting data in quick edit mode. When I paste less than 100 rows, everything works fine.

You can try to import the data with PowerShell script, or to use some third party tool for import. I don't think you will be able to import large data through the user interface of SharePoint.

  • I can confirm this behavior. Pasting in lots of rows from an Excel sheet results in IE getting very slow or freezing (same happens with Chrome btw). We are currently working on a (Nintex) Workflow to offer users a way to import larger XLS files automatically. Might be a workaround for you? – AM2FTW Jan 23 '18 at 9:15
0

You could try exporting the from SharePoint as an Excel spreadsheet. Then edit it in excel and recreate the list using the completed excel sheet.

https://support.office.com/en-us/article/Create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-988a-c2b9bea574fa

I haven't tried this yet so I would recommend a running test first to ensure it works correctly.

Note that this requires an additional Microsoft app and is not entirely an OOTB solution.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.