Forum Discussion

Zerameth's avatar
Zerameth
Copper Contributor
Feb 10, 2024

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 ...
SharePoint Online
Rob_Elliott's avatar
Rob_Elliott
Bronze Contributor
Feb 11, 2024

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)

  • Zerameth's avatar
    Zerameth
    Copper Contributor
    Feb 11, 2024

    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

Resources