Copy and paste from Excel to SharePoint One list not working

%3CLINGO-SUB%20id%3D%22lingo-sub-103359%22%20slang%3D%22en-US%22%3ECopy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103359%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20this%20week%20we%20are%20not%20able%20to%20copy%20and%20paste%20from%20Excel%20sheet%20to%20SharePoint%20Online%20List%2C%20my%20customer%20was%20used%20to%20copy%20and%20paste%20many%20lines%20of%20Excel%20to%20a%20List%20in%20one%20step%20but%20now%20it's%20not%20working%20anymore%2C%20we%20tried%20on%20many%20computers%20and%20different%20navigators%20same%20issue.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomeone%20have%20the%20same%20problem%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-103359%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112027%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112027%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20!%20It's%20working%20with%20IE%20but%20strange%20i'm%20sure%20it%20did%20work%20with%20others%20web%20browsers%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-112021%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-112021%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BI%20don't%20get%20any%20error%20messages%2C%20the%20paste%20just%20don't%20work%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103463%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103463%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20the%20view%20in%20your%20list%20or%20the%20order%20of%20the%20columns%20in%20your%20spreadsheet%20changed%3F%20Could%20it%20be%20that%20the%20data%20simply%20doesn't%20fit%20any%20more%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20get%20any%20error%20messages%20or%20does%20the%20data%20simply%20not%20appear%20on%20paste%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103452%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103452%22%20slang%3D%22en-US%22%3EBart%20is%20correct%2C%20copy%20and%20paste%20from%20Excel%20into%20a%20list%20has%20traditionally%20only%20working%20in%20IE%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-103384%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-103384%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Sylvain%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20IE%3F%20According%20to%20my%20experience%20this%20only%20works%20in%20IE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1055611%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1055611%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F13423%22%20target%3D%22_blank%22%3E%40Sylvain%20Jacquemard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20similar%20problem%20and%20its%20due%20to%20many%20inforamtion%20pasted%20in%20previous%20operation%20of%20copy%20paste%20were%20not%20validated%20as%20per%20rules%20set%20in%20Sharepoint%20List.%20I%20have%20refreshed%20the%20page%20by%20going%20in%20view%20mode%20and%20then%20coming%20back%20to%20edit%20mode%20and%20it%20started%20working%20for%20me.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2124018%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20and%20paste%20from%20Excel%20to%20SharePoint%20One%20list%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2124018%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F13423%22%20target%3D%22_blank%22%3E%40Sylvain%20Jacquemard%3C%2FA%3E%26nbsp%3BI%20have%20the%20same%20problem.%20I%20have%20a%20SharePoint%20list%20on%20a%20Mac%20using%20the%20Edge%2C%20Chrome%20or%20Safari%20browsers%20and%20have%20been%20able%20to%20copy%20and%20paste%20multiple%20columns%20from%20Excel%20to%20that%20list%20(using%20Grid%20View%20of%20course)%20every%20week%20for%20many%20months.%20Until%20Now.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20going%20to%20use%20IE!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 ?

7 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!