Forum Discussion
Not able to paste bulk rows into SharePoint list online from Excel
Hi YavapaiR
I don't have any details about if there is an issue currently but I believe you can save some time on the "even when I take a lot of time scrolling down to the last row to find the '+' icon" step by creating an empty view to insert the data.
Steps:
- Create a new view. Ex: "Bulk Insert"
- Select "Edit in grid view" and save the view
- Go to list settings > edit the new view
- Add a filter like "ID = 0" (a condition that will never be true)
Now you have a view that you can quickly select to add data in quick edit mode. Everytime you switch to the view, it will be empty and ready to use.
- MyChauAug 13, 2024Copper Contributorthis worked. thank you
- DellaLitamMay 09, 2024Copper Contributor
- weronicasMar 06, 2024Copper Contributor
Thanks - it really helped! From 2.5 hours to 2 minutes
- YavapaiROct 18, 2023Copper Contributor
Thanks for the suggested approach, good one! However, it doesn't solve the fact that we can't paste more than one row at a time from Excel to the SP list, whereas we were able to paste 100 at a time, I would like to know if this is happening only on my end or if it's something rolled out by MSFT ¯\_(ツ)_/¯
- wmGomezjrNov 21, 2023Copper Contributor
If you use the classic experience you are able to past multiple rows.
- YavapaiRJan 26, 2024Copper ContributorNope, I already tried this and it didn't work.
- andymxOct 23, 2023Copper ContributorI 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.
- YavapaiROct 27, 2023Copper ContributorI 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.