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

# Export a sheet as CSV

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



## OpenAPI

````yaml /api-reference/openapi.json get /migrations/{migration_id}/exports/{file}
openapi: 3.1.0
info:
  title: Vern Migration API
  version: 1.0.0
  description: >-
    Run Vern as a headless migration engine. Create a migration, upload a
    customer's files, run the managed agent to generate a preview, then execute
    and export clean data. See the Migration API guides for concepts and
    walkthroughs.
servers:
  - url: https://app.vern.so/api/v1
security:
  - apiKey: []
tags:
  - name: Catalog
    description: Discover the sources and templates you set up in the Vern UI.
  - name: Migrations
    description: Create a migration workspace and upload a customer's files.
  - name: Runs
    description: 'Drive the managed agent: generate, refine, execute, answer, and observe.'
  - name: Export
    description: Download a migration's validated data as CSV.
paths:
  /migrations/{migration_id}/exports/{file}:
    parameters:
      - $ref: '#/components/parameters/MigrationId'
    get:
      tags:
        - Export
      summary: Export a sheet as CSV
      description: >-
        Stream one sheet's validated data as a CSV, addressed by
        `{template_slug}.csv`. The body is streamed (gzip-compressed when the
        request advertises it) and an `X-Total-Records` header reports the
        matching count.
      operationId: exportCsv
      parameters:
        - name: file
          in: path
          required: true
          description: The template slug with a .csv suffix, e.g. contacts.csv.
          schema:
            type: string
          example: contacts.csv
        - name: filter
          in: query
          required: false
          description: Which rows to include.
          schema:
            type: string
            enum:
              - valid
              - all
              - invalid
            default: valid
      responses:
        '200':
          description: The CSV stream.
          content:
            text/csv:
              schema:
                type: string
                format: binary
        '400':
          $ref: '#/components/responses/BadRequest'
        '401':
          $ref: '#/components/responses/Unauthorized'
        '404':
          $ref: '#/components/responses/NotFound'
        '429':
          $ref: '#/components/responses/RateLimited'
components:
  parameters:
    MigrationId:
      name: migration_id
      in: path
      required: true
      description: The migration ID returned by Create a migration.
      schema:
        type: string
        format: uuid
      example: c0a8012e-4f1b-4d3a-9b2c-7e6f5a4b3c2d
  responses:
    BadRequest:
      description: Malformed request.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    Unauthorized:
      description: API key missing, malformed, or revoked.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    NotFound:
      description: The referenced resource isn't in your account.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
    RateLimited:
      description: Rate limit hit — back off and retry.
      content:
        application/json:
          schema:
            $ref: '#/components/schemas/Error'
          example:
            error: Too many requests
  schemas:
    Error:
      type: object
      properties:
        error:
          type: string
          description: A human-readable error message.
      required:
        - error
  securitySchemes:
    apiKey:
      type: apiKey
      in: header
      name: x-api-key
      description: Your Vern API key. Create one at Settings → API keys.

````