Forum Discussion

Gilbert Okello's avatar
Gilbert Okello
Iron Contributor
Dec 21, 2016

Updating SharePoint List from Excel

John White, jcgonzalezmartin  is there a way to update a sharepoint list from Excel? (other than through 3rd party tools like SoftFluent's Sharepoint list synchronizer? http://www.softfluent.com/prod...
Lists
SharePoint Online
Alan Marshall's avatar
Alan Marshall
Iron Contributor
Jan 07, 2019
I've used Flow to do this before as on selected item in a doc library and scheduled. You can use Get Rows from Excel if you store the file in a doc library or OneDrive and then add a create item in SharePoint. The Excel get rows has a 500 row limit so I used a loop to get batches of 500 and change the start row in the Get Row action based on a variable. You'll need to use a date or flag column in the spreadsheet to track which ones have been done and update it in the loop
  • Cristen's avatar
    Cristen
    Copper Contributor
    Oct 21, 2019

    Alan MarshallDo you have a Flow process for updating existing items in a list from Excel?

  • Ted-28's avatar
    Ted-28
    Copper Contributor
    Apr 04, 2019

    Alan Marshall Is it possible to provide instruction on how to accomplish such tasks, please? I am a beginner user of SharePoint. I tried to recreate the SharePoint list with updated Excel file in document library using MS-Flow but somehow failed. Thanks in advance.

    • bronniecplace's avatar
      bronniecplace
      Copper Contributor
      Nov 29, 2019

      Ted-28 

       

      Assuming you are using Sharepoint Online (SPO) or '19, Here might be the place to start for that task: https://support.office.com/en-us/article/edit-list-items-in-sharepoint-online-dac1a1c3-a80b-4082-ba57-715cf613d0f7

       

      If you are using earlier versions of Sharepoint, the process is quite similar with the exception "Quick View" is called "Edit in Datasheet"

       

      You will likely get a much speedier answer to queries posted here if you first ensure the answer is not easily available within the Microsoft Help/Support/Training pages.  https://support.office.com/en-us/sharepoint

       

       

      • MedhAmrita1525's avatar
        MedhAmrita1525
        Copper Contributor
        Oct 16, 2020

        bronniecplace 

         

        Hi,

         

        I am using SharePoint Online and the steps mentioned above in 2016 are not working for me. Is there a solution available for SharePoint Online?

Resources