# Structured references

Spreadsheet allows you to convert any data in the sheet to an Excel Table. Select a dataset, or add a dataset using an Array formula such as `=IMPORTDATA`

<figure><img src="https://67932947-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHWsslZpYESUXxPccoyig%2Fuploads%2Fgit-blob-922f619d347f9f5979e6c1e851ab661eb4ba49fd%2Fimage.png?alt=media" alt=""><figcaption><p>Convert dataset to Structured table</p></figcaption></figure>

You can now add formulas in your table referencing to the column names

<figure><img src="https://67932947-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHWsslZpYESUXxPccoyig%2Fuploads%2Fgit-blob-4e748d61c6c6aa59e6cb57ebf648f423af65dcc2%2Fimage.png?alt=media" alt=""><figcaption><p>Formulas referencing column names</p></figcaption></figure>

## Calculated Columns

Dynamic columns can be added just like Excel. Users can edit the table, add multiple columns and extend the table range to give the column additional features such as filtering, sorting etc

<figure><img src="https://67932947-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FHWsslZpYESUXxPccoyig%2Fuploads%2Fgit-blob-a3adf1bde22c31528740aa5ceca45919ab6aea54%2Fimage.png?alt=media" alt=""><figcaption></figcaption></figure>

## Joining tables

You can join tables and create dynamic columns from multiple datasources. Structured formulas refer tables using `Table name` . For example, in the above table, you can add formulas like `=Table 2[@Region]`