Connectors

Productivity & Project Management

Microsoft Excel

Spreadsheet workbooks: read, write, and update cells, tables, and worksheets
Microsoft Excel API reference
Signs in with
API token
Runs on
Cloud or On-Prem Worker
Operations
11
Ready-made triggers
0

Connect Microsoft Excel

  1. In Neblex open Connect › Connections and click New Connection.
  2. Search for Microsoft Excel and give the connection a clear name.
  3. Fill in the fields. Secret values are encrypted and never shown again.
  4. Click Test, then Create Connection.
FieldWhat to enter
Access tokenRequiredSecret

Use it in a flow

  1. Open a flow, open the node library and search for Microsoft Excel.
  2. Drag it onto the canvas and choose an Operation and your connection.
  3. Map the operation's fields from earlier steps, or click Map with Matt.
  4. Use Test this step to see what it returns, then save.

To start a flow from Microsoft Excel without a ready-made trigger: a Poll for changes trigger can check one of its list operations on a schedule and pass on only what is new; if Microsoft Excel can send webhooks, a Webhook trigger receives them at its own URL.

Operations

11 operations in 7 groups. Each one is a step you can add to a flow.

Column1
List table columnslistTableColumnsGETList a table's columns.
Range2
Get used rangegetUsedRangeGETRead a worksheet's used range.
Update a rangeupdateRangePATCHWrite values to an addressed worksheet range (e.g. A1:B2).
Row2
Add a table rowaddRowPOSTAppend rows to a table (values JSON 2D array).
List table rowslistTableRowsGETList a table's rows.
Session1
Create a sessioncreateSessionPOSTCreate a workbook session (persist changes).
Table2
Create a tablecreateTablePOSTCreate a table over a range.
List tableslistTablesGETList the workbook's tables.
User1
Get my profilegetMeGETRead the signed-in user (also verifies the connection).
Worksheet2
Add a worksheetaddWorksheetPOSTAdd a worksheet to the workbook.
List worksheetslistWorksheetsGETList a workbook's worksheets.