SharePoint Document Issues

Fix SharePoint List Missing After Creating from Excel

Olivia Miller Sep 28, 2026 869 views

Question details

The user created a SharePoint list from an Excel table, and while the process reported 100 percent completion, the new list is missing from the SharePoint Site contents.

How to Fix SharePoint List Missing After Creating from Excel

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Creating a new SharePoint list by importing data from an existing Excel table.
Observed behavior: The import progress reaches 100% completion without error, but the resulting list fails to appear in the SharePoint Site contents.

Before you start

Before troubleshooting, ensure you have the necessary permission levels to view and create lists in the target SharePoint site, and verify that you are refreshing the correct Site Contents page.

Solution 1Recommended

Export the Table Directly from Excel to SharePoint

Since importing from the SharePoint interface is experiencing known bugs, exporting the table directly from the Excel application serves as a reliable workaround.

Instead of initiating the list creation from SharePoint, you can push the data from the Excel desktop application directly into a new SharePoint list.

Format Data as Table

Open your Excel file and ensure your data is formatted as a Table by selecting the data range and clicking Insert > Table.

Access Table Design

Click anywhere inside your formatted table to reveal the 'Table Design' tab on the top ribbon.

Export to SharePoint

In the External Table Data group on the ribbon, click 'Export' and select 'Export Table to SharePoint List'.

Enter Site Details

Enter your SharePoint site address and provide a name for the new list, then click 'Next' and 'Finish' to complete the export.

Export the Table Directly from Excel to SharePoint

Known Service Bug: Many users have reported the SharePoint-side import reporting 100% completion but failing to create the list. This is a known product limitation currently being investigated by Microsoft.

Solution 2

Submit Feedback via SharePoint Feedback Portal

Submitting a bug report helps the Microsoft product team track and resolve the product limitation causing this false-positive completion.

Free Microsoft Office alternative

Manage Your Spreadsheets Seamlessly with WPS Office

If you are experiencing bugs and service limitations with Microsoft Office tools, try WPS Office. It provides a lightweight, highly compatible, and free alternative for managing all your complex data tables and spreadsheets without the hassle.

1. Download WPS Office: Download and install WPS Office for free from the official website.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and click 'Open' to browse for your existing Excel files.
3. Edit Seamlessly: Enjoy editing, formatting, and analyzing your data without worrying about compatibility issues.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats to ensure your tables remain intact.Free and lightweight alternative to Microsoft Office.User-friendly interface identical to Excel for a zero-learning-curve migration.Built-in advanced tools for data analysis, filtering, and table management.

microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint say my list import is 100% complete but nothing shows up?

This is a known service bug or product limitation in SharePoint where the user interface reports a false success state while the backend actually fails to generate the list in Site contents.

Does my Excel data need to be formatted as a table before exporting to SharePoint?

Yes, to successfully export data from Excel directly to a SharePoint list, the data range must first be formatted as an official Excel Table (using Ctrl+T or Insert > Table).

Where can I find the SharePoint site URL to export my Excel table?

You can find your SharePoint site URL by opening your SharePoint site home page in a web browser and copying the web address from the top address bar (e.g., https://yourdomain.sharepoint.com/sites/yoursitename).

Will I lose data if the SharePoint list creation fails?

No, your original data remains perfectly safe and intact within your local or cloud-saved Excel workbook. The failure only affects the creation of the copy on SharePoint.

Document & File Issues