Forum Discussion
Copy and paste from Excel to SharePoint One list not working
Hi everyone,
Since this week we are not able to copy and paste from Excel sheet to SharePoint Online List, my customer was used to copy and paste many lines of Excel to a List in one step but now it's not working anymore, we tried on many computers and different navigators same issue.
Someone have the same problem ?
12 Replies
Also looking for help on this issue. IE officially no longer works, and apparently there are no solutions for some key functionality like this and opening in Windows Explorer?
Hi there! Just last week my team discovered that you can add the Internet Explorer mode onto Edge and when you work in this mode cut and paste works.
To add the IE Mode, go to Settings in Edge and in the search put in Internet Explorer mode. Scroll down and you will see the Internet Explorer mode option and you can slide it on. Once on, you should see an icon that looks like a little page with an “e” on it on your Edge Browser on the left upper corner once you close the browser and reopen it. Hope that works for you as it did for me!Cut and Paste should mean exactly that! It is absolutely RIDICULOUS and UNACCEPTABLE that one of the most fundamental, primary functions like Cut and Paste doesn't work? Most of the time it won't copy, many times it pastes so previous value that was used hours ago, or it just sits there and does nothing. WHY ON EARTH WOULD THIS BE REMOVED? Someone must think this is funny, it's not, it's infuriating. Why keep making the products you offer less and less functional? We're asking simple questions and the answers we're getting back are like you're completely oblivious. Here's my Feedback: Fix Cut and Paste and stop playing games, we have work to do. Look how long this thread has been going on and it hasn't given you enough reason to fix it yet? Who's making these decisions, maybe it's time you hire people that don't dumb-down their products or make the harder to use everyday
Techroadie I have the same problem. I have a SharePoint list on a Mac using the Edge, Chrome or Safari browsers and have been able to copy and paste multiple columns from Excel to that list (using Grid View of course) every week for many months. Until Now.
I am not going to use IE!
- Hello! With IE is going away has anyone found a way to copy and paste from Excel to Sharepoint in Edge or Chrome?
Has the view in your list or the order of the columns in your spreadsheet changed? Could it be that the data simply doesn't fit any more?
Do you get any error messages or does the data simply not appear on paste?
I don't get any error messages, the paste just don't work
Hello Sylvain,
Have you tried IE? According to my experience this only works in IE.
Bart
Thank you ! It's working with IE but strange i'm sure it did work with others web browsers
I got similar problem and its due to many inforamtion pasted in previous operation of copy paste were not validated as per rules set in Sharepoint List. I have refreshed the page by going in view mode and then coming back to edit mode and it started working for me.
- Bart is correct, copy and paste from Excel into a list has traditionally only working in IE
