SharePoint Document Issues

Fix Excel File Imports into SharePoint Online Lists

Chanuka GeekiyanageChanuka Geekiyanage Nov 22, 2026 868 views

Question details

The user needs to import spreadsheet data into a SharePoint Online list without relying on the legacy Import Spreadsheet app.

Fix Excel File Imports into SharePoint Online Lists
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.
Before you start

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.

Solution 1Recommended

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.

1
Prepare the workbook

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.

2
Start a new list

Open the SharePoint site and select New > List. Choose From Excel in the list creation options.

3
Select the workbook and table

Upload the .xlsx workbook or select an available file, then choose the table containing the data.

4
Review and create

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.

Create a SharePoint List from an Excel Workbook
If From Excel is unavailable: The available options can depend on your permissions and organization settings. Check current Microsoft guidance or ask your SharePoint administrator about the list creation experience in your tenant.
Free Microsoft Office alternative

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.

Edit spreadsheet data and headers before creating a SharePoint listOpen and save Microsoft Excel formats, including XLS and XLSXWork with CSV files in a familiar spreadsheet interfaceMove existing compatible Office files into a lightweight workspace
microsoft office alternative - wps office

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.