Forum Discussion
Copy pasting column of data from excel into existing sharepoint list
Hi, Newby non-tech here. I have an existing Sharepoint list, created for me by an IT company via .csv upload of an excel sheet. I just noticed I missed an entire column of data in the excel ...
Zerameth further to the answer provided b y Muhammad Ahsan Ranjha , it's actually called Grid View not Edit view. So once you've copied your column of data from Excel, at the top of your list click the Edit in Grid View link:
Then click in the first item in the column you want to paste the data into and paste it. It doesn't always work first time and you might need to go to a different column and then back to the column. Once it's been pasted in click the Exit Grid View link.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Thanks so much, Rob_Elliott.
I had tried doing this in Grid View, but hadn't got the process quite right - now it's working.
Thanks for the heads up that it might not work first time though!
Cheers
Zerameth
