# Real-life CSV data

`CSV` ([comma-separated values](https://en.wikipedia.org/wiki/Comma-separated_values)) files are one of the simplest ways to exchange data between applications. This makes it a great format for data coming from a real-life flight-recorder or for anyone without a technical background who wants to display some telemetry in Tacview.

Most flight recording and management tools are usually already able to export their data in `CSV` file format. Just keep in mind that because of its simplicity, you may not be able to export all possible kind of data.

Tacview natively supports more and more flight recording devices like the [Garmin G1000](https://en.wikipedia.org/wiki/Garmin_G1000). If you would like Tacview to support additional devices or data, feel free to [contact us](mailto:support@tacview.net). Include a sample of the data and as many details as possible about the device you used to generate it.

Here is an [example of a `CSV` file](https://www.tacview.net/download/Tacview-CSV-Samples.zip) from real-life. Please see below for a detailed list of the fields officially supported by Tacview. Open the file in Tacview using the `File` → `Open` command and merge additional files using the `File`→`Merge` command.

Support of `CSV` files is a feature of [Tacview Standard](https://tacview.net/features/comparison/).

### Aircraft Name, Pilot Name, and Color

You can specify the following [metadata](https://en.wikipedia.org/wiki/Metadata) in each `CSV` file name:

* The first part is the NATO name of the corresponding aircraft. This information will be used by Tacview to choose the best 3d model.
* The second – optional – part is the name of the pilot (in parenthesis)
* The third – optional – part is the color of the aircraft \[in brackets]

Here in an example of two typical `CSV` files you could open together:

* `Mirage 2000C (Fahrenheit) [Green].csv`
* `F-14A (Maverick & Goose) [Blue].csv`
* `A-4E (Viper) [Red].csv`

Even if other units may be recognized and supported by Tacview, your data should be always be stored in the metric system, and angles expressed in degrees. Here is the list of data (columns headers) supported:

* `Time`: Time expressed in either Coordinated Universal UTC YYYY-MM-DDThh:mm:ssZ time format, or the offset in seconds since the beginning of the flight
* `Longitude`: Longitude in degrees (negative for west, positive for east)
* `Latitude`: Latitude in degrees (negative for south, positive for north)
* `Altitude`: ASL (Above Sea Level) altitude in meters
* `Roll (deg)`: Roll in degrees (clockwise orientation: positive when rolling to the right, negative to the left)
* `Pitch (deg)`: Pitch in degrees (positive when the aircraft is pointing to the sky, negative when pointing to the ground)
* `Yaw (deg)`: Orientation in degrees relative to the [true north](https://en.wikipedia.org/wiki/True_north)

Tacview intelligently detects the separators used in your `CSV` files. However, for best results it is suggested to stick to the following convention:

* Coma `,` to separate data
* Point `.` for decimal numbers mark
* Double quotes `"` surrounding strings containing comas

Here is an example of a properly formatted file:

```csv
Time,Longitude,Latitude,Altitude,Roll (deg),Pitch (deg),Yaw (deg)
0.00,-116.6847222,32.72722222,34,-0.11536,-0.14832,295.76
4.00,-116.6847222,32.72722222,34,0.36255,-0.26917,295.25
8.00,-116.685,32.72722222,35,0.42297,-0.2417,297.27
```

Here is the list of `CSV` fields officially supported by Tacview. They can be stored in any order and most of them are optional. Only time and position are mandatory. Aside time, any record can be left blank when its value is equal to the previous record value.

| Field       | Value                                                                                                                                                                                                                                                                  |
| ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `Time`      | <p>UTC time for the current record. Fraction of second are supported.<br><code>2011-06-02T05:00:47.13Z</code></p>                                                                                                                                                      |
| `Timestamp` | <p><a href="https://en.wikipedia.org/wiki/Unix_time">Unix time</a> stamp for the current record. Relative to 1970-01-01T00:00:00Z expressed in seconds and fraction of second. This is an alternate way to specify each time record.<br><code>1306990847.13</code></p> |
| `Longitude` | <p>Object longitude in degrees (positive toward the east).<br><code>41.625130740936</code></p>                                                                                                                                                                         |
| `Latitude`  | <p>Object latitude in degrees (positive toward the north).<br><code>41.591041652197</code></p>                                                                                                                                                                         |
| `Altitude`  | <p>Object altitude in meters <a href="https://en.wikipedia.org/wiki/Metres_above_sea_level">MSL</a> (above sea level, also known as ASL in some countries).<br><code>2000.14</code></p>                                                                                |
| `Roll`      | <p>Roll in degrees (Positive when tilting the aircraft to turn to the right).<br><code>-4.2</code></p>                                                                                                                                                                 |
| `Pitch`     | <p>Pitch in degrees (positive when climbing).<br><code>7.10001</code></p>                                                                                                                                                                                              |
| `Yaw`       | <p>Yaw (heading) in degrees relative to the true north.<br><code>312.2</code></p>                                                                                                                                                                                      |
| `AOA`       | <p>Angle of attack<br><code>4.6</code></p>                                                                                                                                                                                                                             |
| `TAS`       | <p>True airspeed (m/s)<br><code>157.7</code></p>                                                                                                                                                                                                                       |
| `CAS`       | <p>Calibrated airspeed (m/s)<br><code>139.1</code></p>                                                                                                                                                                                                                 |
| `IAS`       | <p>Indicated airspeed (m/s)<br><code>137.3</code></p>                                                                                                                                                                                                                  |
| `Mach`      | <p>Mach number<br><code>0.5</code></p>                                                                                                                                                                                                                                 |

### Terrain Textures and Terrain Elevation

To add terrain textures and terrain elevation files, see the [customization - terrain documentation](/tacview/customization/terrain.md)


---

# 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://raia-software-inc.gitbook.io/tacview/real-life-data/real-life-csv-data.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.
