SharePoint List excel import - This table exceeds the maximum number of supported rows


You receive error "This table exceeds the maximum number of supported rows" while creating a new SharePoint custom List from Excel. This error will occur in Modern experience and not in Classic SharePoint experience.

SharePoint excel list error - This table exceeds the maximum number of supported rows.PNG
SharePoint excel list error - This table exceeds the maximum number of supported rows


There is no problem in the excel spreadsheet table data. Data formatted as table, no blank rows, no blank cells for Title column, but still getting error.
Check how many rows you have in the selected table. Is it over 20000 ?


This is a limit set by Microsoft. You can import maximum 20000 rows from Excel table. You will receive the error if there are more than 20000 rows in your excel.

If you have more than 20000 entries, the best approach is to select less than 20000 rows in the excel table and then add more rows using the Quick Edit option.

⭐ USEFUL - Detailed steps to create custom SharePoint list based on excel spreadsheet


  • I liked the Grid view (earlier Quick edit) idea for more than 20k rows. How many rows can I copy at a time from excel? Having 70k entries to be inserted.
    anon 01 Nov 2020 07:12:33 GMT
  • I cannot import more than 5000 excel rows, the table always selects only 5000 rows.
    anon 13 Oct 2020 21:43:10 GMT
  • I created a one time workflow using Power Automate. That is easier.
    anon 27 Aug 2020 13:58:25 GMT
  • Further comments disabled!
Try Out Code2care Dev Tools:


Android Java Linux Microsoft Google Python macOS Notepad++ Microsoft Teams CSS PHP SharePoint Html Linux C Programs Bootstrap jQuery Sublime Android Studio Facebook Eclipse WhatsApp News MySQL Json HowTos JavaScript FTP S3


Code2care is an initiative to publish and share varied knowledge in programming and technical areas gathered during day-to-day learnings and development activities.

Students and Software Developers can leverage this portal to find solutions to their various queries without re-inventing the wheel by referring to our easy to understand posts. Technical posts might include Learnings, Tutorials, Trouble-Shooting steps, Video Tutorials, Code Snippets, How Tos, Blogs, Articles, etc.
🎉 We are celebrating the 10th years of Code2care! Thank you for all your support! We hope we made a difference.
We strong support Gender Equality & Diversity.

We stand in solidarity with Ukraine - Make a donation to UNHCR -