# Import and export resources

## Overview

This guide provides a step-by-step process for exporting and importing metadata using CSV files in Secoda. This allows for bulk editing and updating of metadata to ensure consistency and prevent duplication across your data resources.

{% hint style="info" %}
If your goal is to introduce net new resources from an integration without connecting the integration in the app, you should utilize the [Custom Integrations](https://docs.secoda.co/integrations/custom-integrations-and-marketplace/custom-integration) feature. If you are looking to edit existing resources, such as glossary terms, documents, etc., the following instructions will guide you through the process.
{% endhint %}

## Video resource

{% embed url="<https://www.loom.com/share/8290f98c95ba465c803421d0772f8972>" %}

## E**xporting resources from Secoda** <a href="#h_3a4bfd6458" id="h_3a4bfd6458"></a>

To export resources from Secoda:

1. **Navigate to settings:** Go to [Settings](https://app.secoda.co/settings/import) → Import & Export data.
2. **Select resource type:** Choose the type of resource you wish to export.
3. **Download the export:** Once the Artifact is prepared as a Bulk export of your resources, click the "Download Artifact" button.

<figure><img src="https://secoda-public-media-assets.s3.amazonaws.com/e38e12e7-e3c1-42d7-a369-f18dedbe3376.png" alt=""><figcaption></figcaption></figure>

Below is an example of the results from exporting your data:

<figure><img src="https://secoda-public-media-assets.s3.amazonaws.com/image%20(5)%20(1).png" alt=""><figcaption></figcaption></figure>

## Preparing a CSV for import

Before importing new or updated metadata into Secoda:

1. **Edit your CSV:** After exporting, you can edit your descriptions and other properties in CSV format or Google Sheets.
2. **Set up your CSV:** Use the exported data as a base, the provided template in the UI, or create your own CSV adhering to the required structure:

**Required columns:**

* **id:** Leave this blank for new resources.
* **title:** The name of the resource.
* **entity\_type:** Possible values include table, column, dashboard, chart, job, glossary, document, collection, question, or event.

**Optional columns:**

* **description:** A brief description of the resource.
* **definition:** Markdown-friendly documentation of the resource.
* **pii:** Governance tag (TRUE or FALSE).
* **verified:** Verified status (TRUE or FALSE).
* **published:** Published status (TRUE or FALSE).
* **collections:** List of associated collection names, e.g., \['Marketing', 'Engineering'].
* **owners:** List of associated owner emails that should correspond to existing users in Secoda, e.g., \['<brittany@secoda.co>'].
* **tags:** List of associated tag names, e.g., \['production'].
* **tables:** List of tables that need to be updated, e.g., \[Team 1; Team2;]

## Importing updated metadata into Secoda

1. **Access import settings:** Log into Secoda, navigate to Settings > Import & Export.
2. **Upload CSV file:** Click "Select File" under the Import section, choose your prepared CSV file, and click "Upload". Monitor the import process through the displayed logs.

<figure><img src="https://secoda-public-media-assets.s3.amazonaws.com/662eddc9-a584-42d8-8f26-6f382e136c7f.png" alt=""><figcaption></figcaption></figure>

## Verifying an import

After importing, it's crucial to verify that all properties have been correctly updated:

1. **Check data resource:** Visit a data resource within Secoda to confirm that the properties reflect the recent imports.
2. **Resolve issues:** If there are discrepancies or if you encounter issues, please contact <support@secoda.co>.

By following these steps, you can efficiently manage the metadata of your resources in Secoda, ensuring data integrity and streamlined operations across your organization.

{% hint style="info" %}
Not using Secoda to manage your data documentation yet? Sign up for free [here](http://app.secoda.co/) 👈
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.secoda.co/resource-and-metadata-management/import-and-export-data.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.