# Import extension language/dialect batch file formats

{% hint style="info" %}

### Google sheets for batch upload file creation and editing

Google sheets can be used to quickly generate `.tsv` files from a worksheet tab, via its `File > Download > Tab separated values (current sheet)` menu function. Google sheets also offers useful file sharing and commenting options, so can be an efficient approach to defining, reviewing, and refining extension translation terms prior to importing into the Authoring Platform.
{% endhint %}

Here are some example `.tsv` translations (New Zealand) batch upload files:

## Description Additions

| Concept ID | GB/US FSN Term (For reference only)              | Translated Term                    | Language Code | Case significance | Type    | Language reference set | Acceptability | Language reference set | Acceptability | Language reference set | Acceptability |
| ---------- | ------------------------------------------------ | ---------------------------------- | ------------- | ----------------- | ------- | ---------------------- | ------------- | ---------------------- | ------------- | ---------------------- | ------------- |
| 706690007  | Web-based application software (physical object) | Me tono rorohiko-a-paetukutuku     | mi            | cI                | SYNONYM | Maori                  | PREFERRED     |                        |               |                        |               |
| 706689003  | Application programme software (physical object) | He raupaparorohiko raupaparorohiko | mi            | cI                | SYNONYM | Maori                  | PREFERRED     |                        |               |                        |               |
| 442376007  | Test with result pending (observable entity)     | Whakamatau me te hua ka tatari     | mi            | cI                | SYNONYM | Maori                  | PREFERRED     |                        |               |                        |               |

Reference file: [NZ-translations-template - Description Additions.tsv](https://github.com/SNOMED-Documents/snomed-authoring-userguide/blob/main/resources/work-in-an-extension/nz-translations-template-description-additions.tsv)

## Description Changes

| Description ID | Term (For reference only)                                | Case significance | Type    | Language reference set | Acceptability | Language reference set | Acceptability | Language reference set | Acceptability |
| -------------- | -------------------------------------------------------- | ----------------- | ------- | ---------------------- | ------------- | ---------------------- | ------------- | ---------------------- | ------------- |
| 70056012       | Insertion of catheter into heart chamber                 | cI                | SYNONYM | NZ English             | ACCEPTABLE    | US English             | ACCEPTABLE    | GB English             | ACCEPTABLE    |
| 3658267015     | Inflammatory disorder due to increased blood urate level | ci                | SYNONYM | NZ English             | PREFERRED     | US English             | ACCEPTABLE    | GB English             | ACCEPTABLE    |
| 150085018      | Gout                                                     | CS                | SYNONYM | NZ English             | ACCEPTABLE    | US English             | PREFERRED     | GB English             | PREFERRED     |

Reference file: [NZ translations-template - Description Changes.tsv](https://github.com/SNOMED-Documents/snomed-authoring-userguide/blob/main/resources/work-in-an-extension/nz-translations-template-description-changes.tsv)

## Description Inactivations

| Description ID | Term (For reference only)                        | Inactivation Reason | Association Target ID1 | Association Target ID2 | Association Target ID3 | Association Target ID4 |
| -------------- | ------------------------------------------------ | ------------------- | ---------------------- | ---------------------- | ---------------------- | ---------------------- |
| 51691000210118 | GDM-Gestational diabetes mellitus screening      | Erroneous           |                        |                        |                        |                        |
| 51631000210119 | Screening for diabetes mellitus during pregnancy | Outdated            |                        |                        |                        |                        |

Reference file: [NZ translations-template - Description Inactivations.tsv](https://github.com/SNOMED-Documents/snomed-authoring-userguide/blob/main/resources/work-in-an-extension/nz-translations-template-description-inactivations.tsv)

<a href="https://docs.google.com/forms/d/e/1FAIpQLScTmbZIf0UEQwYDkY27EEWBkaiYkHSbR0_9DmFrMLXoQLyL7Q/viewform?usp=pp_url&#x26;entry.1767247133=AP+UG&#x26;entry.670899847=Import%20extension%20language/dialect%20batch%20file%20formats" class="button primary">Provide Feedback</a>


---

# 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.snomed.org/snomed-ct-user-guides/authoring-user-guide/how-to/work-in-an-extension/import-extension-language-or-dialect-terms-via-a-batch-upload/import-extension-language-dialect-batch-file-formats.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.