# Excel-First Design

Detailed best practices for Excel-first design in building Hedera Guardian schemas focus on using structured Excel templates to define all necessary fields, data types, validation rules, and conditional logic clearly before importing into Guardian. This method improves collaboration, clarity, and iterative feedback especially for complex sustainability methodologies.

### Key Best Practices for Excel-First Design

* **Start with a Standard Header**\
  Use the first rows of the Excel sheet to define the schema identity and type, e.g.,

  * Row 1: Schema Name (e.g., "Project Description (Auto)")
  * Row 2: Schema Description
  * Row 3: Schema Type (e.g., "Verifiable Credentials")
  * Row 4: Column headings for schema field attributes (Required, Field Type, Parameter, Visibility, Question, Multi-Answer, Default).

  <figure><img src="/files/WirvzFdQQ40MA5HFQVKC" alt=""><figcaption></figcaption></figure>
* **Define Each Field with Clear Attributes**\
  For every schema field, specify:

  * Required (Yes/No)
  * Field Type (String, Number, Date, Enum, Boolean, Image, Auto-Calculate, Help Text, etc.)
  * Parameter or reference to enums/calculations if applicable
  * Visibility setting (TRUE/FALSE/Hidden) to control when fields appear
  * User-facing question (label text)
  * Allow multiple answers? (Yes/No)
  * Default or example value for user guidance.

  <figure><img src="/files/OENBWNmjUT1aewMmLB9S" alt=""><figcaption></figcaption></figure>
* **Use Enums for Controlled Vocabularies**\
  Create separate enum tabs for all enumerated types used in the schema (units of measure, certifications, status types). This standardizes inputs and enables conditional field visibility through enum selections.

<figure><img src="/files/1xyyz9dnC64ie5ttrpRl" alt=""><figcaption></figcaption></figure>

* **Implement Conditional Logic via Visibility Columns**\
  Use TRUE to keep fields always visible; use FALSE to make fields conditionally visible based on enum selections or workflow stage; use "Hidden" for system-only or metadata fields. This reduces user burden and aligns forms dynamically with project selections.

<figure><img src="/files/pXGSWCdXDp9watqIQENO" alt=""><figcaption></figcaption></figure>

* **Incorporate Advanced Field Types**\
  Include Auto-Calculate fields for computed values, Image/File Upload fields for supporting documents, and Help Text fields to provide contextual guidance inline.

<figure><img src="/files/0Ch59NWT6l4n27kSIobM" alt=""><figcaption></figcaption></figure>

* **Validation and Data Integrity**\
  Mark critical fields as required to enforce data capture. Choose proper data types for automatic Guardian validation (numbers, dates, boolean, urls). Use patterns or formulas as needed for more complex rules.
* **Field Key Management Post-Import**\
  After importing, rename default field keys in Guardian UI to meaningful, calculation-friendly names. This dramatically improves maintainability of formula/code logic referencing schema fields.
* **Collaborate Closely with Domain Experts**\
  Excel-first enables domain experts (e.g., carbon scientists) to review, comment, and iterate schema designs before committing to implementation.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guardian.hedera.com/guardian-dev/guardian/standard-registry/schemas/best-practices-to-implement-schema/excel-first-design.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.