SharePoint Document Issues

Fix Excel Spreadsheet Import into SharePoint Online

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

Question details

The user needs to import an Excel spreadsheet as a list in SharePoint Online.

Fix Excel Spreadsheet Import into SharePoint Online
Product
SharePoint Online and Microsoft Excel
Device & OS
not provided
Scenario
Creating a SharePoint list from an Excel spreadsheet using either a legacy or modern browser workflow.
Observed behavior
The spreadsheet import does not complete, including when Internet Explorer, ActiveX controls, and Trusted Sites have been configured.
Before you start

Confirm that you can create lists on the target SharePoint site. Open the spreadsheet and check that its data has clear, unique column headers and consistent values in each column.

Solution 1Recommended

Create a SharePoint list using the modern Excel import

Use the modern list creation workflow instead of the legacy ActiveX-dependent spreadsheet import.

The older spreadsheet import feature relies on ActiveX, which modern browsers do not support. Trusted Sites and ActiveX settings may not make that legacy workflow usable in a current SharePoint environment.

1
Format the data as a table

Open the workbook in Excel, select the data and headers, and choose Insert > Table. Confirm that the table has headers, then save the workbook as an .xlsx file.

2
Start a new list

Open the target SharePoint site and select New > List, then choose From Excel. If the option is unavailable, check whether your organization permits list creation and Excel imports.

3
Select the workbook

Upload the .xlsx file or select an available workbook, then choose the table you want to import.

4
Review and create the list

In the import preview, review the proposed column types and adjust them where needed. Enter a list name, select Create, and check the resulting rows and columns.

Create a SharePoint list using the modern Excel import
Free Microsoft Office alternative

Prepare Spreadsheet Data with WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easy to move existing files into WPS and prepare data for a SharePoint import. WPS does not fix SharePoint's legacy ActiveX feature.

Review spreadsheet headers and data before a SharePoint list importOpen and edit Microsoft Excel .xlsx filesWork with CSV files for supported import workflowsUse a familiar, easy-to-use spreadsheet interface
QA img-9

Frequently Asked Questions

Why does the legacy SharePoint spreadsheet import fail in modern browsers?

The older import feature depends on ActiveX, which modern browsers do not support. Use New > List > From Excel or, if available, From CSV instead.

Does adding SharePoint to Trusted Sites fix the import?

Not necessarily. Trusted Sites settings do not add ActiveX support to modern browsers or guarantee that the legacy import will work in current SharePoint environments.

Why should I format my Excel data as a table?

The modern Excel list import lets you select a table from the workbook. In Excel, select the data and headers, choose Insert > Table, and save the workbook before importing.

What happens to formulas and formatting when I save as CSV?

CSV does not preserve Excel formulas or formatting and contains data from only one sheet. Review the imported list after using New > List > From CSV.

What can I do if the From Excel or From CSV option is missing?

Check that you can create lists on the SharePoint site and ask your Microsoft 365 or SharePoint administrator whether the import option is available in your organization.