Office Compatibility Issues

Fix Excel Paste into SharePoint Modern List Quick Edit in IE11

Algirdas JasaitisAlgirdas Jasaitis Nov 20, 2026 868 views

Question details

The user needs to paste multiple rows from Excel into a SharePoint Online list.

Fix Excel Paste into SharePoint Modern List Quick Edit in IE11
Product
SharePoint Online and Microsoft Excel
Device & OS
not provided
Scenario
The user copies multiple Excel rows and pastes them into a modern SharePoint list using Quick Edit in Internet Explorer 11.
Observed behavior
The paste may fail in IE11's modern list experience, although it can work in classic view or a modern browser.
Before you start

Check that the Excel columns match the target SharePoint list columns and that you have permission to edit the list. Internet Explorer 11 is no longer supported for SharePoint Online, so use a supported browser where possible.

Solution 1Recommended

Paste into the modern list using a supported browser

Use Microsoft Edge or another supported modern browser to avoid the IE11 compatibility issue.

1
Open the list in a modern browser

Open Microsoft Edge or another supported browser and navigate to the SharePoint Online list.

2
Check for browser updates

In Edge, select Settings and more > Help and feedback > About Microsoft Edge to check for updates.

3
Copy the Excel data

In Excel, select the cells containing the rows you want to transfer, then press Ctrl+C. Exclude column headers if they are not needed in the list.

4
Paste into the list

In SharePoint, select Edit in grid view, previously called Quick Edit. Select the first target cell and press Ctrl+V, then check the pasted rows for validation errors.

Paste into the modern list using a supported browser
Check column requirements: SharePoint may reject values that do not match a column's data type or required fields. Correct any highlighted errors before leaving grid view.
Free Microsoft Office alternative

Prepare spreadsheet data with WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to review and copy data, making migration from Microsoft Office straightforward. It does not fix SharePoint's IE11 compatibility issue.

Review and copy spreadsheet rows before pasting them into a SharePoint listOpen and edit Microsoft Excel formats, including XLS and XLSXUse a familiar spreadsheet interface for an easier transition from ExcelWork with a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why won't Excel rows paste into my modern SharePoint list in IE11?

IE11 has a compatibility issue with Quick Edit in the modern list experience and is no longer supported for SharePoint Online. Open the list in a supported modern browser and try Edit in grid view.

Where is Quick Edit in a modern SharePoint list?

Open the list and select Edit in grid view on the command bar. This is the newer name for Quick Edit.

What if the paste fails in a modern browser too?

Check that you can edit the list and that the copied values match the target columns, including required fields and data types. Correct any validation errors shown in grid view.

Can I switch a SharePoint list back to classic view?

If available, select Return to classic SharePoint on the list page. A list owner can also check Settings > List settings > Advanced settings for the list experience option; availability depends on organizational settings.