Data Import & Export

How to Fix a Blank SharePoint List After Importing Excel Data

Olivia Miller Oct 14, 2026 869 views

Question details

The user imported an Excel workbook containing about 1,500 records into SharePoint, but the resulting list only shows column names with no data rows.

How to Fix a Blank SharePoint List After Importing Excel Data

Product: Excel
Device & OS: not provided
Scenario: Importing a large dataset from an Excel workbook into a SharePoint list.
Observed behavior: The SharePoint list is created with correct column headers, but it appears completely blank with no imported items displaying.

Before you start

Ensure your Excel data is properly formatted as an official Table with distinct column headers, and verify that the file is saved locally or in an accessible location before attempting the export.

Solution 1Recommended

Export the Excel Table Directly to SharePoint

Instead of importing the file from the SharePoint web interface, push the data directly from the desktop spreadsheet application to ensure the records are properly created.

Exporting directly from the spreadsheet application is often more reliable for larger datasets (like 1,500 records) and prevents browser timeout issues that can result in blank lists.

Format Data as a Table

Open your workbook, select your entire data range, navigate to the 'Home' tab, and click 'Format as Table'. Ensure the 'My table has headers' box is checked.

Initiate Export

Click anywhere inside your new table, go to the 'Table Design' tab on the ribbon, select 'Export', and choose 'Export Table to SharePoint List'.

Enter SharePoint Site Details

In the dialog box, paste the web address (URL) of your target SharePoint site. Provide a recognizable name and description for your new list, then click 'Next'.

Complete and Verify

Review the data columns and data types in the confirmation window. Click 'Finish' to begin the export, then open your SharePoint site to verify the list is fully populated with your 1,500 records.

Export the Excel Table Directly to SharePoint

Export Successful: A success message will appear in your spreadsheet once the records have been successfully transferred to the SharePoint list.

Solution 2

Check SharePoint List View Filters and Validation Settings

Verify if the data actually imported successfully but is being hidden by default view filters or blocked by strict validation rules.

Free Microsoft Office alternative

Manage Your Spreadsheet Data seamlessly with WPS Office

If you frequently work with large datasets and encounter compatibility issues, consider WPS Office. It is a free, lightweight, and highly compatible alternative to Microsoft Office that makes editing, managing, and exporting large spreadsheet tables incredibly easy.

1. Download and Install: Visit the official WPS website to download and install WPS Office for free on your device.
2. Open Your Data File: Launch WPS Spreadsheet and easily open your existing .xlsx or .csv data files without losing any formatting.
3. Clean and Prepare Data: Use WPS Spreadsheet's built-in table formatting tools to clean your 1,500+ records before migrating them to web databases or lists.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Free and lightweight alternative to Microsoft OfficeFamiliar user interface for a seamless transitionAdvanced data formatting and validation tools for large datasets

Frequently Asked Questions

Why does my SharePoint list only show column headers after importing Excel data?

This typically occurs if the imported data was not formatted as an official Table before import, or if the SharePoint list's default view has filters applied that inadvertently hide all the newly created rows.

Does the size of the Excel file affect SharePoint list imports?

Yes. While 1,500 records is generally manageable, web-based imports can sometimes time out or fail silently when processing large files. Using the 'Export to SharePoint List' feature directly from your desktop spreadsheet software is recommended for better reliability.

What does the 'no items to show in this view of the DataValidation list' error mean?

This error usually indicates that the current list view has active filters or grouping configurations that exclude your imported data. It can also mean that list-level data validation rules rejected the incoming rows during the import process.

Excel & Data Problems