Fix Excel to Microsoft Lists Import Stopping at 300 Rows
Question details
The user is attempting to import an Excel spreadsheet containing over 3,000 rows into Microsoft Lists, but the resulting list only populates 300 items.
- Product
- Microsoft Excel and Microsoft Lists
- Device & OS
- not provided
- Scenario
- Importing a large Excel table dataset into a new or existing Microsoft List or SharePoint site.
- Observed behavior
- The import process indicates a successful completion, yet the final list is truncated at exactly 300 rows, despite the platform officially supporting up to 20,000 rows.
Ensure your Excel data is strictly formatted as an official Excel Table (using Ctrl+T) and that you have sufficient permissions to create or edit lists on the target SharePoint site.
Verify and Remove Unsupported Data Types
Certain complex data types in Excel can silently break the export process to SharePoint, causing the import to stop prematurely.
Microsoft Lists handles standard text, numbers, and dates perfectly, but complex Excel data types (like nested arrays, certain linked data types, or heavily formatted rich text) may not map correctly to SharePoint columns.
Identifying and simplifying these columns ensures a complete data transfer.
Review your data starting around row 300 for any unusual formatting, custom data types, or complex formulas that evaluate to unsupported objects.
Select your entire table, press Ctrl+C to copy, then right-click and choose 'Paste as Values' to remove complex formulas.
Ensure all date columns are set to a standard 'Short Date' format and convert any specialized linked data types back to plain text.
Save the cleaned workbook and try importing it into Microsoft Lists again using the 'From Excel' option.
Use the Export to SharePoint Feature in Excel
Instead of pulling the data from the Microsoft Lists web interface, try pushing the data directly from the Excel desktop application.
Test with a Clean Workbook and SharePoint Site
Isolate the issue by testing the data import on a fresh workbook and a different SharePoint site to rule out file corruption or site-specific restrictions.
Manage Massive Spreadsheets Easily with WPS Office
While Microsoft Lists handles your online databases, managing, cleaning, and preparing large Excel datasets before import requires a reliable spreadsheet editor. WPS Office is a highly compatible, fast, and free alternative to Microsoft Office that easily handles workbooks with thousands of rows.
- 1. Download and install: Get WPS Office for free from the official website and follow the simple installation prompts.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your large .xlsx file containing the 3,000+ rows.
- 3. Clean and format data: Use WPS Spreadsheets' robust tools to quickly clean unsupported formats, remove blank rows, and prepare your table perfectly for export.
Frequently Asked Questions
What is the maximum number of rows Microsoft Lists can import from Excel?
Microsoft Lists officially supports creating a list from an Excel table containing up to 20,000 rows. A limit stopping exactly at 300 rows usually indicates a data formatting error rather than a platform limitation.
Do blank cells cause an Excel to SharePoint import to fail?
Blank cells within your data columns do not typically stop the import. However, if your Excel Table range extends far beyond your actual data to include completely blank rows, it can cause processing errors. Ensure your table boundaries strictly enclose your data.
Why does my Excel table not show up when importing to Lists?
Microsoft Lists can only import data that is explicitly formatted as an Excel Table. If your data is just in standard cells, select the data and press Ctrl+T in Excel to format it as a Table before attempting the import.
