Forum Discussion
YavapaiR
Oct 17, 2023Copper Contributor
Not able to paste bulk rows into SharePoint list online from Excel
Hi guys, Looks like some changes were made in MSFT end and the way to work with SharePoint lists has changed. I was able to copy up to 100 rows from Excel and paste them into SharePoint li...
YavapaiR
Jan 26, 2024Copper Contributor
Nope, I already tried this and it didn't work.
RobR69
Feb 09, 2024Copper Contributor
Just hit this problem, if it's a relatively small amount of rows, in Edit In Grid View mode, you need to click "+ Add New", then click the bar next to the radio button on the row (which highlights the whole row), then you can paste multiple entries into the list (thanks to my colleague Kevin for that!)
- roby9390Jun 21, 2024Copper Contributor
Could you be clearer in explaining the steps on how you got around the problem?
- YavapaiRJul 30, 2024Copper Contributor
Assuming you know how to start "Edit in in grid view" once you Click that button (Edit in grid view), you go to the end of your list, then what RobR69 is suggesting is to click + icon then in write something in one of the fields, then click the radio icon for that new row and hit CTRL + V, see image below.
This is how I used to do this before, it doesn't work anymore on my list. Hope it helps.
- YavapaiRMar 19, 2024Copper ContributorThis is how I used to upload new batch of rows, not working anymore until today. Continue using a flow to upload new rows. Not sure it's because the amount of rows we currently have, that is over 25k.
- norbabFeb 20, 2024Copper Contributor
RobR69 tell Kevin thank you! This worked a treat has has saved me a substantial amount of time.
- RobR69Feb 20, 2024Copper ContributorI will 😄