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

# Import and export

> Excel import and export for deliverables.

Import and export are available on **deliverables only**.

## Export

```http theme={null}
GET /deliverable/export
GET /deliverable/export?isArchived:eq=false&timezone=America/New_York
```

Returns a `.xlsx` file (max 10,000 rows). Accepts the same filters as `GET /deliverable`.

## Import

```http theme={null}
POST /deliverable/import
Content-Type: multipart/form-data

file=<xlsx file>           # required
timezone=America/New_York  # optional
```

Only `.xlsx`, max 10 MB. Row-level and file-structure problems (missing required columns, a circular parent reference, an unresolved parent identifier, etc.) are returned as `200` with details in the body — they do **not** fail the HTTP request:

```json theme={null}
{ "imported": 3, "errors": [], "warnings": [] }
```

```json theme={null}
{
  "imported": 0,
  "errors": [
    {
      "row": 2,
      "column": "Parent ID",
      "value": "PRJ-9",
      "kind": "resolution",
      "message": "Parent \"PRJ-9\" was not found in the database and is not present in this import file"
    }
  ],
  "warnings": []
}
```

`row: 0` means the error applies to the whole file rather than a specific row (e.g. a missing required column). A genuinely unreadable file (corrupt `.xlsx`, or a workbook with no sheets) is the one case that does **not** come back as `200` — it throws and surfaces as a `500`.

<Warning>
  Import endpoints are rate-limited to 100 requests/min.
</Warning>