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
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 so the issue isn't the browser - it is likely bc you have it formatted as a table - you just need to copy your table data to new blank sheet and paste as values - fix the dates that you have to show as dates and then copy 50-90 at a time into the SP List using edit in grid view and VOILA!!!
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:
RobElliott I just ran into this myself. I just connected to the SharePoint list in MS Access and did a simple append query to the SharePoint list. I'm sure there's a more elegant way, but it's a solution that didn't require any coding (the append query is generated in the MS Access query builder).
- "if you go to Edit in grid view on your list you can paste in data from an excel spreadsheet." in a Mac, it works but using Edge it doesn't work with Safari.
RobElliott is there an import, for lots of data, rather than copy/paste?
RobElliottWhat steps did you take to acheive this? I am clicking into a cell in edit grid view then ctrl + v pasting, it just pastes all content into one cell (rather than across columns) in both Firefox and Edge.
- Just try it several times, it will eventaully work. But you night need to exit grid view and then go back into it. It's a bit hit & miss.
- Yes seems to be! Thanks - I ended up importing from a table/Excel file in the end.
RobElliott sorry for old bump - this works in Internet Explorer (and Edge has an IE mode now), but as other commenters indicate, I cannot reproduce multi-line copy/pasting in a chromium browser.
- Try as I may, I can't get this to work. I copy the Excel rows into my clipboard. I go my SharePoint list; select Edit in grid view; navigate to the bottom; choose Add Item; click in the first column and try to paste. Instead of adding fields across the row, it deposits the entire contents into the first cell. I've also tried pasting without clicking in the first cell but nothing happens. I've tried various browsers, but nothing seems to work. Any advise as to what I'm doing wrong?
nestorph3010 Are you in Internet Explorer? I couldn't get it to work in Edge, but was able to paste a few hundred lines by opening it in Internet Explorer. Good luck!
- Thank you! Didn't realise you could do that.
