Fix Excel Spreadsheet Import into SharePoint Online
Question details
The user needs to import an Excel spreadsheet as a list in 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.
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.
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.
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.
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.
Upload the .xlsx file or select an available workbook, then choose the table you want to import.
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.

Convert the spreadsheet to CSV and import it as a list
Try a CSV file when the modern Excel import does not work and a CSV import option is available.
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.

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.




