SharePoint List to Excel Register

Append every new SharePoint list item to an Excel register, so finance can pivot and chart requests without opening SharePoint.

Sign in with your Edesy account; the setup wizard opens on this template.

Category

Operations & Productivity

Type

App automation

Steps

1

Apps

SharePoint, Microsoft Excel

Level

Beginner, about 9 min to set up

How the workflow runs

Pick the SharePoint site and list (for example a contract or purchase request list) and the Excel workbook to write to. Each new item adds a row with its title, owner, status, amount and a link back to the item. If you only want approved items in the register, filter on Status before writing.

App trigger · SharePointSharePoint: new list itemApp action · Microsoft ExcelExcel: add register row

Steps in order

  1. 1

    SharePoint: new list item

    Starts the workflow · SharePoint

  2. 2

    Excel: add register row

    App action · Microsoft Excel

Apps it connects

  • SharePoint
  • Microsoft Excel

SharePoint List to Excel Register: questions

You sign in to Edesy Flow with your Edesy account and the template wizard opens: map each role to a person, pick the app connections it needs, and Flow creates the forms and the workflow for you to edit.

Yes. The workflow opens in the visual builder, where you can add, remove or reorder steps, change who approves, edit the e-mails and add branches.

Related templates