Manage Excel Online data with Azure Logic Apps
With Azure Logic Apps and the Excel Online for Business connector or Excel Online for OneDrive connector, you can create automated tasks and workflows based on your data in Excel Online for Business or OneDrive. This connector provides actions that help you work with your data and manage spreadsheets, for example:
- Create new worksheets and tables.
- Get and manage worksheets, tables, and rows.
- Add single rows and key columns.
You can then use the outputs from these actions with actions for other services. For example, if you use an action that creates worksheets each week, you can use another action that sends confirmation email by using the Office 365 Outlook connector.
If you're new to logic apps, review What is Azure Logic Apps?
An Azure subscription. If you don't have an Azure subscription, sign up for a free Azure account.
An Office 365 account for your work account or personal Microsoft account
Your Excel data can exist as a comma-separated value (CSV) file in a storage folder, for example, in OneDrive. You can also use the same CSV file with the flat-file connector.
Basic knowledge about how to create logic apps
The logic app where you want to access your Excel Online data. This connector provides only actions, so to start your logic app, select a separate trigger, for example, the Recurrence trigger.
Add Excel action
In the Azure portal, open your logic app in the Logic App Designer, if not already open.
Under the trigger, choose New step.
In the search box, enter "excel" as your filter. Under the actions list, select the action you want.
The Logic App Designer can't load tables that have 100 or more columns. If possible, reduce the number of columns in the selected table so that the designer can load the table.
If prompted, sign in to your Office 365 account.
Your credentials authorize your logic app to create a connection to Excel Online and access your data.
Continue providing the necessary details for the selected action and building your logic app's workflow.
For technical details, such as triggers, actions, and limits, as described by the connector's OpenAPI (formerly Swagger) files, see these connector reference pages:
- Learn about other Logic Apps connectors