- Custom n8n node
- Data & Spreadsheets
- AI-agent tool
Excel
Read, write and manage Excel workbooks in-flow without losing formatting.
How it works in practice
A finance template, filled in without touching its look
How we apply it
Our robots keep their business rules, account mappings and configuration in Excel workbooks the accountants own, so a rule can change without a developer, and every run report is filled in the same way.
This node works on Excel files (.xlsx, .xlsm, .xltx, .xltm) that travel through the workflow as binary data. Range operations read a sheet or range into one item per row, write input items from a given cell into an existing or brand-new workbook, and append rows, optionally copied from another range or workbook. Sheet operations add, rename, duplicate, delete, list, protect and unprotect worksheets.
Spreadsheet handling in stock n8n tends to rebuild or flatten the file. This node edits the workbook in place, so images, tables and comments in a customer's template survive, and Duplicate Sheet has a raw-copy mode that clones the sheet XML. Match Cell Format turns text into real dates where the target cell is date-formatted. Nothing external is needed: the dependencies are bundled into the package.
It is our most reused node, in 57 production workflows. Typical jobs are filling a finance or customer template from workflow data, reading an uploaded price list or order sheet row by row, and generating a monthly workbook with one sheet per branch, usually with SharePoint or an SMB share on either side.
Limits: it edits files, it does not drive Excel. Nothing is recalculated for you, macros are not executed, and it cannot reach a workbook open in Excel Online.
For your technical team: it installs from npm as
What it means for you
No copy-paste into spreadsheets
Familiar Excel files stay the working format, nothing new to learn
Templates keep their look every single month
More nodes we built
- Banking & FinanceBulgarian BanksEvery bank's statement, read the same wayNo more retyping of statement linesAI-agent tool
- Government & RegistriesBulgarian Registry AgencyA new customer, checked against the official registerNobody copies register data by hand from a browser tabAI-agent tool
- Documents & AIDocument AIA mixed scan, sorted into readable invoicesNobody splits or types invoices by handAI-agent tool
- ERP & AccountingMicroinvestPayments and invoices posted straight into the booksNobody re-keys entries one by oneAI-agent tool
- SecurityPassboltSigning in to a portal without a password in sightPasswords live in one place, not scattered across automationsAI-agent tool
- Documents & AIPDFOne big scan, cut into one file per documentNo manual splitting in a PDF viewerAI-agent tool
- Web AutomationPlaywright browserStatements collected from portals with no integrationNo more clicking through portals by handAI-agent tool
- Web AutomationRobot Framework runnerAn old Windows program, operated by a robotThe old software stays, with no forced replacementAI-agent tool
- Files & StorageSeaweedFS storageDocuments kept safely in storage you ownNo lock-in to a cloud vendorAI-agent tool
- Microsoft 365SharePointDocuments filed in SharePoint, where people lookNo manual filing or renamingAI-agent tool
- Files & StorageSMB network shareFiles exchanged with old systems through a shared folderOlder systems keep working as they areAI-agent tool
Want Excel in your n8n?
Tell us what the workflow has to do and what it connects to. We will say whether this node covers it as it stands, what we would add, and when a different approach is the better one.
