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.

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,363 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
6,457 questions
Accepted answer
  1. Emily Du-MSFT 26,636 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
Most helpful Newest Oldest
  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.