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 li...
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.

 



 

  • MyChau's avatar
    MyChau
    Copper Contributor
    Aug 13, 2024
    this worked. thank you
  • DellaLitam's avatar
    DellaLitam
    Copper Contributor
    May 09, 2024

    luis-ribeiro 

     

    This worked perfectly! Thank you!  I was going nuts with the bugginess 

  • weronicas's avatar
    weronicas
    Copper Contributor
    Mar 06, 2024

    Thanks - it really helped! From 2.5 hours to 2 minutes

  • YavapaiR's avatar
    YavapaiR
    Copper Contributor
    Oct 18, 2023

    luis-ribeiro ,

     

    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 ¯\_(ツ)_/¯

    • wmGomezjr's avatar
      wmGomezjr
      Copper Contributor
      Nov 21, 2023

      YavapaiR 

      If you use the classic experience you are able to past multiple rows.

      • YavapaiR's avatar
        YavapaiR
        Copper Contributor
        Jan 26, 2024
        Nope, I already tried this and it didn't work.
    • andymx's avatar
      andymx
      Copper Contributor
      Oct 23, 2023
      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.
      • YavapaiR's avatar
        YavapaiR
        Copper Contributor
        Oct 27, 2023
        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.

Resources