Forum Discussion
Import excel into existing list (with data already in it)
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 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!
I figured it out!! I was struggling with this and really needed to make it work.
It depends on how you click on the cell. If you have the curser flashing in the cell to enter text then it will just paste whatever you copy from Excel as text. However, if you want to copy several rows or items from Excel, you need to click on the cell in grid mode. To do that, if you have the curser flashing, click on an area outside the list.
Step by step:
1. Click on "Add new item"
2. Select the cell you want the rows to go to, or the cell in column A to enter all columns
3. The cell will select and your curser will flash in the first column
4. Click below that row and under the end of the list
5. Your selection will become still the same cell but without the flashing cursor
6. Paste
7. If you had several rows whether just one column or several it will paste all the rows as new rows into your list.
Tested and verified. Works like a charm. See a few screenshots below.
Text entry: (not what you want)
which leads to the following:
No cursor selection should look like so:
And leads to the following:
Notice the "wrong" pasted option at the top and the correct pasting underneath that.
Browser: Chrome
View used: SharePoint Modern View
OS: MacOS 14
