Forum Discussion
Solved
Import excel into existing list (with data already in it)
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 overw...
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
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
BeachBennsyou cannot paste multiple items in grid view if you have disabled item checkboxes. make sure it is enabled.
- 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.
- ^THIS IS THE WAY^ I wasn't able to paste more than one, then I just did this and could paste 550 all at once. Note that if you are doing that many, it takes some time for it to sync up to the cloud after you Exit grid view. Mine took a few minutes.
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
