Excel to SPO Import - This table exceeds the maximum number of supported rows

Ramonet 41 Reputation points
2020-11-27T18:29:52.983+00:00

Hi,

Please, help.

I need to import more than 5K items from an Excel sheet into a SharePoint List. What is the issue?

Every time I tried to do it I get this message (error):

This table exceeds the maximum number of supported rows.

How can I bypass this limitation?

Thanks in advanced.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,819 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,657 questions
0 comments No comments
{count} votes

Accepted answer
  1. Emily Du-MSFT 42,346 Reputation points Microsoft Vendor
    2020-11-30T08:06:10.4+00:00

    @Ramonet
    This is a limit set by Microsoft, the list view threshold means that you can't have more than 5000 items in a view. I suggest you select less than 5000 rows in the excel table and then add more rows by using quick edit option.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


1 additional answer

Sort by: Most helpful
  1. Ramonet 41 Reputation points
    2020-12-08T13:37:08.543+00:00

    Important note: Classic experience is required in order to paste multiple records using Quick Edit. Otherwise, it won't work. I switched to classic, pasted the remaining records, then switched back to modern.

    0 comments No comments