XGSL (eXtensible Grid Sheet Language)

Spreadsheets as Code. Define complex spreadsheets declaratively, version them with Git, and export to Excel, Google Sheets, or LibreOffice.

// Example: Sales Report
@compose(Product, Sales)
table SalesReport {
  @label("Product") @style(bold)
  name: Product.name

  @label("Revenue") @style(currency)
  revenue: Formula(Sales.units * Product.price)
}

Features ✨

• Declarative Syntax – Define tables, formulas, and styles in code.
• Export Everywhere – Compile to .xlsx, Google Sheets, or .ods.
• Version Control – Human-readable diffs (unlike binary .xlsx files).
• IDE Support – Autocomplete, diagnostics, and hover docs via LSP.
• Template Reuse – Inherit and compose spreadsheets with @import.

Quick Start 🚀

Install the CLI

cargo install xgsl

Compile a Spreadsheet

xgsl compile report.xgsl --target excel

Format Your Code

xgsl fmt report.xgsl

Language Highlights

Formulas with Virtual Variables

// Relative references (like Excel’s A1 notation, but readable)
growth: Formula((.up.revenue - this.revenue) / .up.revenue)

Cross-Entity References

// Pull data from other tables
inventory: Formula(Inventory[this.product_id].stock)

Dependency Management

// Import templates from GitHub
@import("github:company/report-templates@v1.2")
table Q4Report extends QuarterlyTemplate { ... }

Roadmap 🗺️

Feature	Status
Excel Exporter	🔜 Planned
Google Sheets Exporter	🔜 Planned
Language Server (LSP)	🔜 Planned
Dependency Resolver	🔜 Planned

Contributing 🤝

We welcome contributions! See:

• RFC 0001 – Design overview.

Why XGSL?

Problem	XGSL Solution
Manual edits break logic	Spreadsheets defined as code
Unreadable Git diffs	Clean, versionable syntax
No template reuse	@import and inheritance

---

📌 Star this repo to stay updated!
💬 Questions? Open a GitHub Discussion.