> ## Documentation Index
> Fetch the complete documentation index at: https://docs.standardcomputers.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Import and Export Standard Records as JSON, XML, or CSV

> Import records into a Standard table from JSON, XML, or CSV files on disk, and export records from any Standard to common data formats.

Importing, exporting, and converting data has always been a necessary function of client applications. Standard moves this to the backend as it has direct access to the data. These same simple queries can run as the API for your app or Standard code by returning results as JSON, XML, and CSV.

## Importing from Disk

The import query can import records into a Standard provided the file location. This query supports auto-uploading from JSON, XML, and CSV files:

```text theme={null}
[std_name or STD_REF] << "[PATH_TO_DIR]"
```

<Note>
  Standard automatically detects the file format from the file extension. Make sure your file's column headers or JSON keys match the constraint names defined in your Standard.
</Note>

## Exporting to Disk

Export records from any Standard table to a file on disk using the `>>` operator:

```text theme={null}
[std_name or STD_REF] >> "[PATH_TO_DIR]"
```

For example, export all vehicle records to a CSV file:

```text theme={null}
[vehicle] >> "/home/JohnDoe/Downloads/vehicles.csv"
```

<Tip>
  You can combine export queries with filter conditions to export only a subset of records — for example, exporting only Honda vehicles or records modified after a certain date.
</Tip>