Copy and paste from Excel to SharePoint One list not working

Brass Contributor

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

Hello Sylvain,

 

Have you tried IE? According to my experience this only works in IE.

 

Bart

Bart is correct, copy and paste from Excel into a list has traditionally only working in IE

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

Thank you ! It's working with IE but strange i'm sure it did work with others web browsers

@Sylvain Jacquemard 

 

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. 

@Sylvain Jacquemard 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?

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

I definitely hear what you are saying. It took me several failed attempts with the Modern version  and deep breaths before I gave Classic a try.

 

I was able to paste from Excel to a SharePoint Online list in Classic view.  And once in Classic, it took a moment to figure out I had to click on the pencil icon to get the copied content to paste correctly in the list.

 

At this point just grateful it can be done. I have a decade of content to paste from an Access table!