Fix Excel Paste into SharePoint Modern List Quick Edit in IE11
Question details
The user needs to paste multiple rows from Excel into a SharePoint Online list.

- 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.
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.
Paste into the modern list using a supported browser
Use Microsoft Edge or another supported modern browser to avoid the IE11 compatibility issue.
Open Microsoft Edge or another supported browser and navigate to the SharePoint Online list.
In Edge, select Settings and more > Help and feedback > About Microsoft Edge to check for updates.
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.
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.

Try the classic list experience when IE11 is required
Use classic view as a workaround if your organization requires IE11 and the classic experience is available.
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.

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.




