SOLVED

Import excel into existing list (with data already in it)

%3CLINGO-SUB%20id%3D%22lingo-sub-2234719%22%20slang%3D%22en-US%22%3EImport%20excel%20into%20existing%20list%20(with%20data%20already%20in%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2234719%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20import%20data%20from%20an%20excel%20sheet%20into%20a%20SharePoint%20list%20that%20already%20contains%20data%20in%20it%3F%26nbsp%3B%20Basically%20I%20just%20want%20to%20add%20to%20the%20list%20that's%20already%20in%20SharePoint%20without%20overwriting%20the%20existing%20lines%20or%20having%20to%20create%20a%20new%20list%20each%20time.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2234719%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2234751%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20excel%20into%20existing%20list%20(with%20data%20already%20in%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2234751%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1008255%22%20target%3D%22_blank%22%3E%40RRMX01%3C%2FA%3E%26nbsp%3B%20if%20you%20go%20to%20%3CSTRONG%3EEdit%20in%20grid%20view%3C%2FSTRONG%3E%20on%20your%20list%20you%20can%20paste%20in%20data%20from%20an%20excel%20spreadsheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2235039%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20excel%20into%20existing%20list%20(with%20data%20already%20in%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2235039%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20need%20to%20import%20a%20lot%20of%20items%20then%20you%20may%20wish%20to%20import%20in%20chunks%20of%20100%20and%20wait%20for%20the%20changes%20to%20be%20synched%20before%20importing%20the%20next%20set.%20i.e.%20avoid%20inconsistent%20data.%20Paul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2550802%22%20slang%3D%22en-US%22%3ERe%3A%20Import%20excel%20into%20existing%20list%20(with%20data%20already%20in%20it)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550802%22%20slang%3D%22en-US%22%3EIn%20the%20edit%20in%20grid%20view%20screen%20just%20do%20a%20single%20click%20on%20the%20first%20column%20-%20don't%20click%20into%20it%20-%20and%20you%20should%20be%20ab%20le%20to%20paste%20in%20records%2C%20I%20do%20it%20regularly.%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

Is it possible to import data from an excel sheet into a SharePoint list that already contains data in it?  Basically I just want to add to the list that's already in SharePoint without overwriting the existing lines or having to create a new list each time.

 

Thanks!

8 Replies
best response confirmed by RRMX01 (Occasional Contributor)
Solution

@RRMX01  if you go to Edit in grid view on your list you can paste in data from an excel spreadsheet.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Thank you! Didn't realise you could do that.

If you need to import a lot of items then you may wish to import in chunks of 100 and wait for the changes to be synched before importing the next set. i.e. avoid inconsistent data. Paul

@Paul_HK_de_Jong I'm using Sharepoint online (office 365), when i edit my list in grid view i can paste 1 record at a time successfully but can't paste multiple records, any ideas?  I don't have a quick edit icon only the edit in grid view icon.  Thanks in advance

In the edit in grid view screen just do a single click on the first column - don't click into it - and you should be ab le to paste in records, I do it regularly.
In addition to the comments posted, make sure that the columns in Excel match exactly the columns in the SharePoint list's view. For example, if you columns Title, Salary and Status in SharePoint, then you should have the same, matching data in Excel. The column heading names do NOT need to match, but the data and order must match. Also, if your view has additional columns visible such as Modified By, hide those. Otherwise, you'll get an error when trying to paste.

@RobElliott  Pasting one at a time works, i can't paste any more than that. I'm testing with 2 records, the first one inserts then there's a blank row with no info from the second source row.

 

thanks

I create a flow in Power Automate for such things. That way I can reshape or check data if needed and reuse that flow later in time.