---
title: "Export a sheet as CSV"
method: GET
path: "/migrations/{migration_id}/exports/{file}"
tags: ["Export"]
---

# Export a sheet as CSV

`GET /migrations/{migration_id}/exports/{file}`

## Request

- Base URL: `https://app.vern.so/api/v1`
- URL: `https://app.vern.so/api/v1/migrations/{migration_id}/exports/{file}`
- Auth: API key in header `x-api-key`
- TypeScript: <https://skmtc.dev/vern-so/apis/vern-api/docs/migrations/:migration_id/exports/:file/get.ts> (a function with typed inputs; its response is checked against the schema)

Stream one sheet's data as a CSV, addressed by `{template_slug}.csv`. Every row is included. The body is streamed (gzip-compressed when the request advertises it) and an `X-Total-Records` header reports the total count.

## Path parameters

- `file` string, required

## Query parameters

- `fields` string
- `omit_empty` boolean

## Response `200`

The CSV stream.

## Other responses

- `400`: Malformed request.
- `401`: API key missing, malformed, or revoked.
- `404`: The referenced resource isn't in your account.
- `429`: Rate limit hit. Counted per account, not per API key. Creating a migration and starting a `generate` run are limited to 30/hour each; answering a run is limited to 30/hour; reads allow 30/minute and writes 30/minute. `Retry-After` gives the seconds until the window resets, alongside `X-RateLimit-Limit`, `X-RateLimit-Remaining` and `X-RateLimit-Reset`.

## Changes

- **2026-09-27** `1990c15edaad`: 1 warning, 2 info
  - deleted the `query` request parameter `filter`
  - added the new optional `query` request parameter `fields`
  - added the new optional `query` request parameter `omit_empty`
- **2026-06-18** `c5a09eb23a64`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/vern-so/apis/vern-api/changes/migrations/:migration_id/exports/:file/get.md)

---

[API](https://skmtc.dev/vern-so/apis/vern-api.md) - [All operations](https://skmtc.dev/vern-so/apis/vern-api/llms.txt) - [OpenAPI document](https://skmtc.dev/vern-so/apis/vern-api/revisions/6ae61af2db81?raw)