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

# Exporting data

> Download the rows in a table as a CSV file. Filters and visible columns control exactly what gets exported.

The CSV exporter downloads the rows in a table as a CSV file. The export uses **the filters you've applied** and **the columns currently visible** in the Data Viewer — so you can scope the file to exactly the slice of data you want before generating it.

## Step-by-step

<Steps>
  <Step title="Filter the rows you want">
    Open the table on the **Data** tab and apply filters until the grid shows only the rows you want to export. The export will include exactly those rows.

    <img src="https://mintcdn.com/archie-e998dbf6/LbS-QJnKq49swD_q/features/backend/data-model/data-viewer-export-filter-records.png?fit=max&auto=format&n=LbS-QJnKq49swD_q&q=85&s=c3b7998e62f9906c0dc11afcc5d27911" alt="Filter records for export" width="1576" height="746" data-path="features/backend/data-model/data-viewer-export-filter-records.png" />
  </Step>

  <Step title="Choose which columns to include">
    Click the **View** dropdown in the toolbar and toggle off any fields you don't want in the file. Only the columns currently visible in the grid are included in the export.

    <img src="https://mintcdn.com/archie-e998dbf6/LbS-QJnKq49swD_q/features/backend/data-model/data-viewer-export-select-columns.png?fit=max&auto=format&n=LbS-QJnKq49swD_q&q=85&s=42c1ba86b45a27ad6339ff251869c4f4" alt="Select columns for export" width="1576" height="746" data-path="features/backend/data-model/data-viewer-export-select-columns.png" />
  </Step>

  <Step title="Click the Export CSV icon">
    The icon sits in the toolbar. The browser downloads the CSV file to your machine.

    <img src="https://mintcdn.com/archie-e998dbf6/LbS-QJnKq49swD_q/features/backend/data-model/data-viewer-export-data.png?fit=max&auto=format&n=LbS-QJnKq49swD_q&q=85&s=322697967075c23720b86197804f8bb2" alt="Export data options" width="1576" height="807" data-path="features/backend/data-model/data-viewer-export-data.png" />
  </Step>
</Steps>

## What the file contains

* **Header row** — the field names of the included columns.
* **One row per record** — matching the current filtered view.
* **Date and timestamp formatting** — ISO 8601 (`2025-03-14T10:30:00Z` for timestamps with time zone).
* **Relationship fields** — the primary key of the related row, not the related row's full content.
* **JSONB fields** — the JSON value as a quoted string.

If you need a different shape — for example, joining in fields from a related table — define a [view](/features/backend/data-model/views) that returns the columns you want, then export the view.

## Permissions

Exports respect the per-role read permissions configured in [Role-Based Access](/features/backend/app-services/role-based-access). A user can only export rows and fields they're allowed to read.

## FAQ

<AccordionGroup>
  <Accordion title="How do I export only some columns?">
    Toggle off the columns you don't want from the **View** dropdown. The export uses the visible-column set as its column list.
  </Accordion>

  <Accordion title="How do I export only some rows?">
    Apply filters in the toolbar before clicking Export. The export includes exactly the rows currently in the grid.
  </Accordion>

  <Accordion title="Can I export rows along with their related records?">
    Define a [view](/features/backend/data-model/views) whose `SELECT` joins the related tables, then export the view. The CSV exporter operates on a single table or view at a time.
  </Accordion>

  <Accordion title="Are there any size limits?">
    Very large exports may take a while to generate. For multi-million-row exports, consider scripting the dump through a custom function or the SQL Playground.
  </Accordion>

  <Accordion title="Are audit columns included?">
    Only if they're visible in the grid. Toggle `id`, `created_at`, `created_by`, `updated_at`, or `updated_by` on from the **View** dropdown if you want them in the file.
  </Accordion>
</AccordionGroup>