Forum Discussion
RRMX01
Mar 25, 2021Copper Contributor
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...
- Mar 25, 2021
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
RobElliott
Jul 14, 2021Silver Contributor
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.
Dean Zimmermann
Mar 03, 2023Copper Contributor
^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.