# Schemas

{% 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&#x26;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](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas/intersection)
* [A three entity schema](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas/three-entity-schema)
* [Three entity schema v2](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v2)
* [Three entity schema v3](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v3)
* [Three entity schema v4](https://www.csvpath.org/getting-started/the-flightpath-data-examples/schemas/three-entity-schema-v4)