Easy Tech TutsHow to Connect Microsoft Excel to n8n Easily 2026
By Impran M N
Automating spreadsheet updates with n8n means connecting through Microsoft's Azure platform, since Excel Online authentication runs on OAuth2. This guide covers registering your app, linking credentials in n8n, and mapping data into worksheet rows.
01Add the Microsoft Excel node
Place the node onto your workflow canvas where you want to interact with your spreadsheet.
02Create a credential profile
Set up a new n8n credential and copy the OAuth redirect URL it generates.
03Register your app in Azure
Go to the Microsoft Azure portal to register an application and generate your client credentials.
04Paste your keys into n8n
Copy your client ID and secret back into n8n to complete the authentication.
05Map your worksheet operation
Choose to append, update, or read rows, then connect your incoming data to the correct columns and test it.
Frequently asked questions
Do I need an Azure account to connect Excel to n8n?
Yes, connecting Excel Online requires registering an application through the Microsoft Azure portal.
Can n8n append new rows to an existing spreadsheet?
Yes, the Microsoft Excel node supports appending rows along with other operations like reading and updating.
Does this work with local Excel files instead of Excel Online?
This integration is built around the cloud-based Excel Online API rather than local desktop files.
What credentials does the Excel node need?
It needs an OAuth2 connection set up through your Azure app registration, including a client ID and secret.
Watch the full walkthrough
The same steps, demonstrated on screen from start to finish.
