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

# Import and Export Data Assets

> Bulk import or export database services, databases, schemas, and tables as CSV files. Validate and edit inline before finalizing changes in Collate.

# Import and Export Data Assets

Collate lets you bulk import or export data assets as CSV files instead of editing them one at a time in the UI. Update metadata for many assets in a single operation, or pull an asset's current metadata into a spreadsheet to review or hand off.

## What You Can Do

* **Bulk import**: Create or update **Database Services**, **Databases**, **Database Schemas**, and **Tables** in a single CSV upload, from the UI or the API.
* **Bulk export**: Download the current metadata for any of those asset types as a CSV, from the UI or the API.
* **Round-trip editing**: Export an asset as a CSV, edit it in a spreadsheet, then import it back to apply the changes in bulk.
* **Validate before you commit**: The import flow previews every row with a **Passed**/**Failed** count, and lets you fix errors inline before finalizing.

## How It Works

Both import and export follow the same pattern for every asset type:

1. Open the asset (or its parent service) and select **Import** or **Export** from its **⋮** menu (Database Services use **Settings** instead).
2. For import, upload a CSV, or export an existing asset first to use as a starting template.
3. Review the preview and fix any failed rows, then confirm to apply the changes.

See [Import Data Assets](/ai-2-0/how-to-guides/data-discovery/import) for the exact CSV fields each asset type expects, and both guides for API endpoints if you'd rather script it.

<CardGroup cols={2}>
  <Card title="Import Data Assets" href="/ai-2-0/how-to-guides/data-discovery/import">
    Create or update Database Services, Databases, Database Schemas, and Tables by uploading a CSV.
  </Card>

  <Card title="Export Data Assets" href="/ai-2-0/how-to-guides/data-discovery/export">
    Download the current metadata for Database Services, Databases, Database Schemas, and Tables as a CSV.
  </Card>
</CardGroup>