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