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
I've read through this whole thread and followed all the advice on multiple attempts to get data new data in the list. In 2024 this feature of being able to paste multiple new entries seems to have been removed.
My data is in the correct format - as the formatted table that the original was imported from.
Paste data using the method outlined just pasted every column and row into one field on the SP page. Has MS removed the ability to update a field. It no longer works.
Username635 I just used this technique earlier today with several rows of text columns (including one multiple lines of text column), and it worked fine. It is tricky selecting the first empty cell after enabling edit in grid view, without getting the active cursor element there (which will result in the paste filling just that single cell with all of the data, as you're seeing). Since the recent changes to bring the Lists App visual improvements over to SPO lists, that seems less predictable than it used to be, where you could click on a very subtle, tiny square in the lower left corner, to the left of the select row icon. Actually, it looks like the select icon is gone entirely for the Add new item row, but there is a similar tiny square in the lower _right_ corner instead that appears to work reliably.
My emphasis in green circles:
 
