Forum Discussion

YavapaiR's avatar
YavapaiR
Copper Contributor
Oct 17, 2023

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 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,

Lists
SharePoint Online
Usage
  • luis-ribeiro's avatar
    luis-ribeiro
    Brass Contributor
    Oct 17, 2023

    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.

     



     

Resources