Fix Excel File Imports into SharePoint Online Lists
Question details
The user needs to import spreadsheet data into a SharePoint Online list without relying on the legacy Import Spreadsheet app.

- Product
- SharePoint Online
- Device & OS
- not provided
- Scenario
- Creating a SharePoint list from an XLS, CSV, or other spreadsheet file.
- Observed behavior
- The legacy import app requests ActiveX support in modern browsers or reports that a compatible SharePoint Foundation spreadsheet application is missing in Internet Explorer.
Confirm that you have permission to create or edit lists on the SharePoint site. For the Excel import option, arrange the data in a table with a header row and save the workbook as an .xlsx file.
Create a SharePoint List from an Excel Workbook
Use the modern list creation experience instead of the legacy Import Spreadsheet app.
The legacy app depends on older browser and Office components and may not work reliably in current SharePoint Online environments. The modern From Excel option avoids that legacy import path.
Open the file in Excel, select the data including its headers, and choose Insert > Table. If the source is an XLS or CSV file, use File > Save As to save it as an .xlsx workbook.
Open the SharePoint site and select New > List. Choose From Excel in the list creation options.
Upload the .xlsx workbook or select an available file, then choose the table containing the data.
Check the proposed column names and types, enter a list name, and select Create. Open the new list and verify that the data imported as expected.

Paste Spreadsheet Data into a List in Grid View
Use this alternative when you can create or edit a list but cannot use the Excel import option.
Prepare Spreadsheet Data with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Use it to open and prepare compatible workbooks before importing them into SharePoint; it does not repair the legacy SharePoint import app.

Frequently Asked Questions
Why does the legacy SharePoint import app ask for ActiveX?
The legacy Import Spreadsheet app depends on older browser and Office components. Modern browsers do not support that legacy path reliably, so use New > List > From Excel where available.
Can I import a CSV file directly into a SharePoint list?
For the From Excel workflow, open the CSV in a spreadsheet application and save it as an .xlsx workbook. Format the data as a table with headers, then select the workbook under New > List > From Excel.
Why does SharePoint not find a table in my workbook?
The data may be a plain range rather than an Excel table. In Excel, select the range and choose Insert > Table, confirm the header row, and save the workbook before trying From Excel again.
Can I add spreadsheet rows to an existing list?
Yes. Open the list, select Edit in grid view, and paste copied spreadsheet cells into matching columns. Check the results because some column types may require specific values or separate entry.




