> For the complete documentation index, see [llms.txt](https://www.csvpath.org/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas.md).

# Schemas

Examples of using CsvPath Validation Language schemas to validate CSV and Excel data

{% hint style="warning" %}
**Try these examples yourself.** They are built into FlightPath Data. You can download FlightPath Data free from [Microsoft](https://apps.microsoft.com/detail/9P9PBPKZ4JDF) or [Apple](https://apps.apple.com/us/app/flightpath-data/id6745823097) or [Github](https://github.com/dk107dk/flightpath)[ub](https://github.com/dk107dk/flightpath)
{% endhint %}

<figure><img src="https://2402701329-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6wzqgDHj9mZbFxabiEbc%2Fuploads%2F6xs38w6TNAP9L5MvrIEq%2FScreenshot%202025-11-07%20at%201.43.50%E2%80%AFPM.png?alt=media&amp;token=9afd6716-bfe7-43c0-86c3-11d8f7a74822" alt=""><figcaption></figcaption></figure>

## Making schemas for CSV and Excel

CsvPath Framework supports data validation using schemas and rules. Both approaches have their own strengths.

This example shows how to create a simple schema that functions much like a SQL DDL schema.

The DDL example is in the file person.sql.txt. It has a simplistic 3-table model of a person with address and contact information.

The examples in the file schemas.csvpath show four variations on an analogous CsvPath schema that can be used with a CSV or Excel file.

Run any of the csvpaths by putting your cursor in the csvpath you want to run and typing **control-r** or right-clicking and selecting **Run**.

* [Intersection](/getting-started/the-flightpath-data-examples/schemas/intersection.md)
* [A three entity schema](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema.md)
* [Three entity schema v2](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v2.md)
* [Three entity schema v3](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v3.md)
* [Three entity schema v4](/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v4.md)