SharePoint List Missing Records

Question

I tried to create a SharePoint List by importing an Excel file with 10,805 rows. The SharePoint List appears to be stuck at 450 records although everything I read indicates that a List can have far more than 10,805 rows. Does anyone know why this is happening? I checked the List settings and there is no limit to the total number of records allowed. Thanks!

Answer 1

Dear Karen,

Yes, 10,805 rows can should be OK. I did a test and I can't reproduce the issue in our environment.

If it is convenient, I suggest you create a new list from the Excel table again to see the result.

If the issue persists, I think that it may be an issue related to the Import feature in your tenant and may need to involve our related team to be fixed directly.

If you aren't the administrator, I suggest you contact the administrator in your company and let him follow the steps in Get support - Microsoft 365 admin | Microsoft Learn to open a support ticket to our related team as soon as possible.

About admin roles in the Microsoft 365 admin center - Microsoft 365 admin | Microsoft Learn

How do I find my Microsoft 365 admin? - Microsoft Support

The administrator should be able to open the support ticket from Help & support in the Microsoft 365 admin center.

Then you can select the Phone support or the Email support as follows.

To simplify the process, I'd like to summarize the issue as follows.

Issue Symptom:

===============

When importing the Excel rows with 10,805 rows to a SharePoint Online list, the process will be stuck in 405 rows.

Issue Environment:

=================

SharePoint Online

What users may done:

=================

Let users import the data again with a new SharePoint Online list to see the result.

Next Step:

==================

Open a support ticket to our related team to check the logs further and fix the issue directly.

Thanks for your effort and hope that the issue can be soon resolved by our related team.

Sincerely

Cliff | Microsoft Community Moderator