Skip to main content

Export: Excel

Converts a data contract into an ODCS Excel template — a user-friendly spreadsheet for authoring, sharing, and managing data contracts.

datacontract export excel orders.odcs.yaml --output orders.xlsx

Running this against the example orders contract produces an orders.xlsx workbook with the ODCS template sheets — fundamentals, servers, the orders and line_items schemas, quality, and service levels — pre-filled from the contract.

The Excel format enables:

  • User-friendly authoring in Excel's familiar interface.
  • Easy sharing as standard Excel files.
  • Collaboration with non-technical stakeholders.
  • Round-trip conversion back to YAML via import excel.

Templates​

The official ODCS Excel templates ship with the CLI, so the export works offline. For the template structure, see the ODCS Excel Template repository.

Use --template to export into your own workbook instead — a local path or a URL:

datacontract export excel orders.odcs.yaml --template ./my-odcs-template.xlsx --output orders.xlsx

You can customize the template as you like. Start from a copy of the official template and adapt it (branding, extra sheets, additional columns). Note that if you drop or rename sheet names or column headers, the export will drop the associated information from the contract.

All options: datacontract export excel.