Forum Discussion
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...
I am having this same problem. Was able to paste many rows just last week, now I am unable to bulk paste. MS team constantly removing basic features like copy and paste is actually embarrassing and I hope they have a quick fix for this.
I ended up creating a flow that will upload the rows for me, with the limitation of getting error when I try to upload 100+ rows.
- I found that I could do this but it was fiddly. The first paste would put everything into the first column cell delimited with spaces. So I deleted and moved the cursor to the next column cell and then back to the first and was able to paste all rows.
