STEP 1
Connect Databricks and Microsoft Excel
Save credentials in WEXTL once. We store them encrypted and reuse the authorization across every workflow [3]. No coding or API skills required.
Databricks and Microsoft Excel Integration
Build developer tools workflows between Databricks and Microsoft Excel on a visual canvas — set up data fields sync between apps once and let data flow when events come automatically. Integration will work without code and your team will see the workflow inside WEXTL® builder.
3-day trialCancel anytimeUp to 10 minutes quick set up
- GDPR
- Data Encryption
- 2FA
- Local Data Region
Learn about Databricks and Microsoft Excel
Detailed info you need to know about Databricks and Microsoft Excel integrations in WEXTL. Explore which modules apps support and how you connect them.
Databricks
Run Databricks jobs, clusters, SQL, files, Unity Catalog, and model serving from a workspace. [5]
Microsoft Excel
Read and write workbook data in Microsoft Excel. [6]
How to connect Databricks to Microsoft Excel
Set up your Databricks and Microsoft Excel integration in 3 simple steps [2] — no coding required. Up to 10 minutes setup.
STEP 2
Build a workflow
Paste selected Databricks and Microsoft Excel nodes onto the canvas [4], or describe what you want and WEXTL wires the flow together with AI Builder.
STEP 3
Map your data
Choose which fields need to sync between Databricks and Microsoft Excel. Use filters or leverage a JS custom code step in between — everything is on the canvas.
How does the integration between Databricks and Microsoft Excel work in WEXTL?
WEXTL exposes actions and triggers for Databricks and Microsoft Excel that help you connect apps and automate repetitive tasks [1]. A trigger is an event that happens, an action — a step that performs when the event has occurred.
Databricks triggersMicrosoft Excel actions
Databricks modules
- Watch Job RunsTriggers when a Databricks job run starts.
- Cancel All RunsCancels all runs of a job.
- Cancel RunCancels a job run.
- Cancel SQL StatementCancels a SQL statement.
- Change Cluster OwnerChanges the owner of a cluster.
- Create CatalogCreates a catalog.
- Create ClusterCreates a new cluster.
- Create Conversation MessageSends a message in a Genie conversation.
- Create DirectoryCreates a volume directory.
- Create FunctionCreates a function.
- Create JobCreates a new job.
- Create RepoCreates a new repo.
- Create SchemaCreates a schema.
- Create Secret ScopeCreates a secret scope.
- Create Serving EndpointCreates a serving endpoint.
- Create SQL WarehouseCreates a SQL warehouse.
- Create Vector Search IndexCreates a vector search index.
- Create VolumeCreates a volume.
- Create Workspace DirectoryCreates a workspace directory.
- Delete CatalogDeletes a catalog.
- Delete Cluster PermanentlyPermanently deletes a cluster.
- Delete DirectoryDeletes an empty volume directory.
- Delete FileDeletes a file from a Unity Catalog volume.
- Delete FunctionDeletes a function.
- Delete JobDeletes a job.
- Delete RepoDeletes a repo.
- Delete RunDeletes a job run.
- Delete SchemaDeletes a schema.
- Delete SecretDeletes a secret.
- Delete Secret ACLDeletes a secret ACL.
- Delete Secret ScopeDeletes a secret scope.
- Delete Serving EndpointDeletes a serving endpoint.
- Delete SQL WarehouseDeletes a SQL warehouse.
- Delete VolumeDeletes a volume.
- Delete Workspace ObjectDeletes a workspace object.
- Download FileDownloads a file from a Unity Catalog volume.
- Edit ClusterEdits an existing cluster.
- Edit SQL WarehouseEdits a SQL warehouse.
- Execute Message SQL QueryExecutes the SQL query on a Genie message attachment.
- Execute SQL StatementExecutes a SQL statement on a warehouse.
- Export RunExports a job run.
- Export Workspace ObjectExports a workspace object.
- Get CatalogReturns a catalog.
- Get ClusterReturns a single cluster.
- Get Conversation MessageReturns a Genie conversation message.
- Get File MetadataReturns metadata for a volume file.
- Get FunctionReturns a function.
- Get Genie SpaceReturns a Genie space.
- Get JobReturns a single job.
- Get Job RunReturns a single job run.
Microsoft Excel modules
- Add a Table ColumnAdds a new column to the table.
- Add a Table RowAdds rows to the end of the table.
- Apply a Table SortPerform a sort operation.
- Clear a Table SortClears the sorting that is currently on the table.
- Close a Workbook SessionClose an existing workbook session.
- Create a TableCreates a new table.
- Create a Workbook SessionCreate a new workbook session.
- Create a WorksheetAdd a new worksheet to the workbook.
- Create a Worksheet TableCreate a new table in a worksheet.
- Delete a TableDeletes the table.
- Delete a Table ColumnDeletes the column from the table.
- Delete a Table RowDeletes a row from the table.
- Delete a WorksheetDeletes the worksheet from the workbook.
- List Table ColumnsRetrieve a list of table column objects.
- List Table RowsRetrieve a list of table row objects.
- List TablesRetrieve a list of table objects.
- List WorksheetRetrieve a list of worksheet objects.
- List Worksheet NamesRetrieve a list of named item associated with the worksheet.
- List Worksheet TablesRetrieve a list of tables in a worksheets.
- Make an API CallPerform an arbitrary authorized API request.
- Re-Apply a Table SortRe-applies the current sorting parameters to the table.
- Refresh a Workbook SessionRefresh an existing workbook session.
- Retrieve a Header Row RangeGets the range object associated with the header row of the column.
- Retrieve a TableRetrieve a single table object.
- Retrieve a Table ColumnRequest a single table column object.
- Retrieve a Table Column Body RangeGets the range object associated with the data body of the column.
- Retrieve a Table Column ItemGets a column based on its position in the collection.
- Retrieve a Table Column RangeGets the range object associated with the entire column.
- Retrieve a Table RowRequest a single row of a table.
- Retrieve a Table Row ItemGets a row based on its position in the collection.
- Retrieve a Table Row RangeReturns the range object associated with the entire row.
- Retrieve a Table SortRetrieve a of table sort object.
- Retrieve a Total Row RangeGets the range object associated with the totals row of the column.
- Retrieve a WorksheetRetrieve a single worksheet.
- Retrieve a Worksheet CellGets the range object containing the single cell based on row and column numbers.
- Retrieve a Worksheet RangeGets the range object specified by the address or name.
- Update a TableUpdate the properties of table object.
- Update a Table ColumnUpdate the properties of table column object.
- Update a Table RowUpdate the properties of a table row object.
- Update a WorksheetUpdate the properties of worksheet object.
Explore alternative integrations
There are other apps [9] supported by WEXTL that can be paired with Databricks and Microsoft Excel integrations. Pick any from the list below if the current combination isn't the one you need.
Frequently asked questions
Common questions about connecting Databricks and Microsoft Excel.
Connect your Databricks and Microsoft Excel accounts once, pick a trigger in one app and an action in the other, then map the fields so data flows automatically between them. [3]
Example: when Databricks's "Watch Job Runs" fires, WEXTL can "Add a Table Column" in Microsoft Excel. Databricks has 1 trigger (including Watch Job Runs); Microsoft Excel has 40 actions (including Add a Table Column, Add a Table Row, and Apply a Table Sort). Add filters and transforms between steps when you need them. [1]
Yes — the integration works in both directions. Use each app's triggers to start a workflow and the other app's actions to update it. [2]
No. Databricks-to-Microsoft Excel automations are built visually on the canvas. You can optionally add custom JavaScript with Functions when you need advanced logic. [4]
Yes. Trigger-based automations start the moment Databricks (or Microsoft Excel) fires a new event — webhook-backed apps run within seconds, and polling-only apps re-check on a schedule you control. [7]
A first automation typically takes 5–10 minutes: connect each app's credential once, drop a trigger + action onto the canvas, map the fields, and turn the workflow on.
You can build your Databricks + Microsoft Excel automation on a 3-day trial with every feature unlocked. Cancel anytime. For your protection, a small deposit is charged to your card when your trial starts. It counts toward your first payment and is non-refundable. [8]
References
List of sources used to gather information about the Databricks and Microsoft Excel integration.
- Databricks and Microsoft Excel integration source code, module specs and credentials implementation.
- Our Databricks and Microsoft Excel integration documentation, structured input and output parameters, scopes, and authentication methods.
- Official vendor API documentation for Databricks and Microsoft Excel — used to verify field meanings, authentication flows, and anything our own specs don't fully capture.
- WEXTL® visual workflow builder, anonymized data from our technical support team.
- Databricks integration information
- Microsoft Excel integration information
- WEXTL® Scheduling
- WEXTL® Pricing and Trial
- WEXTL® Apps Library