Unanswered

Not able to paste bulk rows into SharePoint list online from Excel

(0) Share

Report

Posted on by YavapaiR

Hi guys,

Some changes were made in MSFT end and looks like 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 lists following this steps:

1- clicking the "Edit in grid view" button,

2- Scrolling to the end of the 100 first rows in the list

3- Click the + icon and select the blank last row

4- Paste the 100 rows from Excel

It was easy-peasy, now, I have a list with over 25k rows, and we update this about once a week, this was the fastest way to do this, and now, even when I take a lot of time scrolling down to the last row to find the '+' icon, it wouldn't let me paste more than 1 row from Excel, it only allows to paste 1 single row at a time.

So, do you guys know if this is a glitch or is this new way things will work for SharePoint lists online?

Thank you for your insights!

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

ANB 7,250 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @YavapaiR , I believe you should post this query on SharePoint Forum. https://techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint
OR Maybe you can create support ticket with Microsoft.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍

Thanks,
ANB

Was this reply helpful? Yes No
YavapaiR 43 on at

Like (0)

Report
Copy link

Link copied!

@ANB ,

Thanks for the insight, I put this here since the SP list is the data source for an application built in Power Apps, but I'll post it on the link provided as well.

Best regards,

Was this reply helpful? Yes No
ANB 7,250 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @YavapaiR , The reason I mention the SharePoint forum because the operation that you are performing is on SharePoint with a feature called Edit in grid view.

Thanks,
ANB

Was this reply helpful? Yes No