CONVERTS EXCELS TO DATABASE¶
Ingests one or more sheets from an Excel file and persists the contents as a named database (dataset) within the platform. Supports a generic layout as well as a structured FCA Powertrain format. Use this worker whenever tabular Excel data needs to be promoted to a queryable platform database.
When to use¶
Tagged: database, excel, fca_powertrain, files, ingest, tabular.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Database Name | database_name | text | — | ✓ | Unique name for the target platform database that will be created or overwritten; must be a non-empty string (e.g. ‘my_test_results’). |
| Database Description | database_desc | text | — | Optional human-readable description stored alongside the database to explain its contents or provenance; leave blank if no annotation is needed. | |
| Excel File | excel_file | file | — | ✓ | The .xlsx / .xls file whose sheet(s) will be parsed and loaded; must be a valid Excel workbook uploaded via the file picker. |
| Excel Format | excel_format | select | generic | Parsing schema to apply: ‘generic’ (default) treats every sheet as flat tabular data; ‘fca_powertrain’ applies the FCA Powertrain-specific column mapping and header conventions. |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| Records | records | dataset | Platform dataset containing all rows ingested from the Excel file, typed and structured according to the chosen format, ready for downstream querying or transformation. |
Disciplines¶
- data.dataset.ingest
- data.io.excel
Auto-generated from platform schema. Worker id: excel_to_database. Schema hash: 590e6d125f2d. Hand-curated docs in workerexamples/ override this page when present.