> For the complete documentation index, see [llms.txt](https://developer.collibra.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://developer.collibra.com/api/guides/import-api/importing-csv-and-excel-files/formatting-json-template-files.md).

# Formatting JSON template files

The JSON template is one of the required parameters needed to translate data in CSV or Excel files. The template contains the [API import commands](/api/guides/import-api/import-commands.md) and placeholders that indicate the number of the columns containing the relevant data of the type `${n}`, where `n` is the number of the column.

{% hint style="info" %}
The first column is 1.
{% endhint %}

## Community example

```json
[{
  "resourceType": "Community",
  "identifier": {
    "id": "${n}"
  },
  "parent": {
    "id": "9f01ccd6-3329-49ef-af9a-3e1c9826f731"
  }
}]
```

## Domain example

```json
[{
  "resourceType": "Domain",
  "identifier": {
    "id": "${n}"
  },
  "name": "${n}",
  "description": "${n}",
  "community": {
    "name": "${n}"
  },
  "type": {
    ​"name": "${n}"
  }
}]
```

## Asset example

```json
[{
  "resourceType": "Asset",
  "identifier": {
    "name": "${n}",
    "domain": {
      "name": "${n}",
      "community": {
        "name": "${n}"
      },
    },
  },
  "attributes": {
    "00000000-0000-0000-0000-000000003115": [
      "value": "${n}"
    ]
  }
}]
```