Microsoft Excel 365 and Microsoft SQL integration
How to connect Microsoft Excel 365 and Microsoft SQL
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Build your own Microsoft Excel 365 and Microsoft SQL integration
Create custom Microsoft Excel 365 and Microsoft SQL workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Microsoft Excel 365 supported actions
Append
Add rows to the end of the table
Convert to Range
Convert a table to a range
Create
Add a table based on range
Delete
Delete a table
Get Columns
Retrieve a list of table columns
Get Rows
Retrieve a list of table rows
Lookup
Look for rows that match a given value in a column
Add Sheet
Add a new sheet to the workbook
Delete
Delete workbook
Get Many
Get workbooks
Append
Append data to sheet
Append or Update
Append a new row or update the current one if it already exists (upsert)
Clear
Clear sheet
Delete
Delete sheet
Get Many
Get a list of sheets
Get Rows
Retrieve a list of sheet rows
Update
Update rows of a sheet or sheet range
Microsoft SQL supported actions
Execute Query
Execute an SQL query
Insert
Insert rows in database
Update
Update rows in database
Delete
Delete rows in database
Microsoft Excel 365 and Microsoft SQL integration details
Microsoft Excel 365
Microsoft Excel is the most famous spreadsheet tool in the world. It is developed by Microsoft as part of their Office Suite. It is widely used by individuals, professionals, developers, and companies for many uses in statistics, accounting, data analysis, etc.
Microsoft Excel 365 node docs + examples
Microsoft Excel 365 credential docs
See Microsoft Excel 365 integrations
Related categories
Other integrations with Microsoft Excel 365
Other integrations with Microsoft SQL
Microsoft Excel 365 and Microsoft SQL integration tutorials
FAQ
Can Microsoft Excel 365 connect with Microsoft SQL?
Can I use Microsoft Excel 365’s API with n8n?
Can I use Microsoft SQL’s API with n8n?
Is n8n secure for integrating Microsoft Excel 365 and Microsoft SQL?
How to get started with Microsoft Excel 365 and Microsoft SQL integration in n8n.io?
Looking to integrate Microsoft Excel 365 and Microsoft SQL in your company?
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Microsoft Excel 365 with Microsoft SQL
Build complex workflows, really fast
