Forum Discussion
ajt8888
Oct 20, 2022Copper Contributor
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)
- RobElliottSilver 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)- ajt8888Copper ContributorThanks Mark
That worked much appreciated