> For the complete documentation index, see [llms.txt](https://nodanomics.gitbook.io/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://nodanomics.gitbook.io/docs/documentation/nodes/data-type-nodes/dataset.md).

# Dataset

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

The Dataset node is an array of data.&#x20;

You can create a spreadsheet with your project's data and link it to the diagram, using the Dataset node. It's also possible to save and read data from Data nodes into Datasets.

## Creating a spreadsheet

Using your favorite spreadsheet editor, create a table with your project's data.

### Styling

The spreadsheet must be organized as such:

| {Dataset Name} | {Data 1} | {Data 2} |
| :------------: | :------: | :------: |
|                |     0    |     3    |
|                |     1    |     4    |
|                |     2    |     5    |

## Importing spreadsheets&#x20;

To import the spreadsheet into your project, you must use the Spreadsheets library menu.&#x20;

<figure><img src="/files/8C6N8N7Y2he5BiBNmoX6" alt=""><figcaption></figcaption></figure>

{% hint style="warning" %}
The spreadsheet file must be in the XLSX file format.
{% endhint %}

## Interacting with the spreadsheet data

To reference the Dataset in the diagram, you need to use the following notation system: `datasetTag[`<mark style="color:red;">`x`</mark>`][`<mark style="color:green;">`y`</mark>`]`

Here's the above table with the coordinates individually marked:

<table><thead><tr><th width="213" align="center">Dataset Name (X = 0)</th><th width="283" align="center">Data 1 (X = 1)</th><th align="center">Data 2 (X = 2)</th></tr></thead><tbody><tr><td align="center"></td><td align="center">0 (Y = 0)</td><td align="center">3 (Y = 0)</td></tr><tr><td align="center"></td><td align="center">1 (Y = 1)</td><td align="center">4 (Y = 1)</td></tr><tr><td align="center"></td><td align="center">2 (Y = 2)</td><td align="center">5 (Y =2)</td></tr></tbody></table>

To reference the number "5", per example, we would write `datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`2`</mark>`]`

In the same manner, to reference the number "4", we would write `datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`1`</mark>`]`

If we put this into a Formula's "Expression" field `datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`2`</mark>`] * datasetTag[`<mark style="color:red;">`2`</mark>`][`<mark style="color:green;">`1`</mark>`]`, it would be the same as inputting `5 * 4` and that would give `20` as the result.

{% hint style="info" %}
Datasets are very useful to gather together the inputs from your project.&#x20;

In this way, the only thing needed to update new values in your project is the spreadsheet with the updated values.
{% endhint %}

{% hint style="info" %}
You can also use Datasets to output data from the diagram. e.g. Individual Player Data based on Day.
{% endhint %}
