> For the complete documentation index, see [llms.txt](https://giantgrey.gitbook.io/databrain/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://giantgrey.gitbook.io/databrain/add-ons/dialogue/import.md).

# Import

Dialogue add-on supports import from Google Sheet or from a CSV file.\
In the dialogue graphs, dialogue data tab you'll find the import section:

<div align="left"><figure><img src="/files/ha277Yd0486oISFTmKRk" alt=""><figcaption></figcaption></figure></div>

## File Setup

To make sure the system converts the spreadsheet correctly you'll need to format your spreadsheet like following image:

<figure><img src="/files/kioCBKL81AgalQBERkH2" alt=""><figcaption></figcaption></figure>

The first row <mark style="color:blue;">FIELD\_NAMES</mark> defines the field names.

* **First column**: Name of the dialogue sequence, you can define multiple sequences in one spreadsheet.
* **Type**: Enter "<mark style="color:orange;">Text</mark>" if it's a dialogue text or "<mark style="color:orange;">Choice</mark>" if it's a possible choice.
* **Actor**: Name of the actor DataObject.
* **Emotion**: Actors emotion
* **Playables**: Name of the GameObject which has a playable director component. Can be comma separated for multiple names.
* **Audio**: Create an audio column for each available language and name it accordingly. For example: **Audio-English**. You can either enter the AudioClip name or if you want to use Gibberish voice, enter: "Gibberish:&#x32;**"** -> The number indicates the gibberish length.
* **Language**: Create a column for each text language and enter the text.

## Google Sheet Import

1. Enable link sharing in the Google Sheet file and copy the share link.
2. Enter the share link in the Google Import settings.

<div align="left"><figure><img src="/files/7HnFbyKE82o3kwdjzZZh" alt=""><figcaption></figcaption></figure></div>

3. Click on "Add Worksheet".
4. Select the worksheet in your browser and copy the last number from from the URL. (The number after: "**gid=**")
5. Click on Import Dialogue.

## CSV Import

1. Select the file you want to import and click on Import CSV.