Forum Discussion

ajt8888's avatar
ajt8888
Copper Contributor
Oct 20, 2022
Solved

Adding data to a Sharepoint list

I have a list on Sharepoint Online it has over 2000 rows already and I want to copy another 500 from a spreadsheet into the list like i used to do in Sharepoint 2007. I have gone to edit in grid view and pasted the new data but all that happens is that the whole lot just goes into one single cell. So am I correct in assuming that MS have discontinued this and I will have to build a new list from scratch. I'm beginning to think Google is a far better option

  • ajt8888 I do it regularly, it hasn't been discontinued and will work, it just takes a bit of trial-and-error. Ctrl+z to delete the current attempt, then click in the cell to the right then back again into the far left cell and ctrl+v again. It usually takes 2-3 goes for me before it's successful.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

  • RobElliott's avatar
    RobElliott
    Silver Contributor

    ajt8888 I do it regularly, it hasn't been discontinued and will work, it just takes a bit of trial-and-error. Ctrl+z to delete the current attempt, then click in the cell to the right then back again into the far left cell and ctrl+v again. It usually takes 2-3 goes for me before it's successful.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • ajt8888's avatar
      ajt8888
      Copper Contributor
      Thanks Mark
      That worked much appreciated

Resources