> For the complete documentation index, see [llms.txt](https://docs.cohesiveapp.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cohesiveapp.com/reference/workflow-documentation/templates/lists.md).

# Lists

Lists are a powerful option within Cohesive that should be used when you intend to extract an unknown number of rows or datapoints, such as from a table. 

For example, let's assume that we wanted to extract the `Name`, `Date`, and `Description` columns for all of the rows in the Excel file below (in this example we can see it's four rows, but hypothetically let's assume it's an unknown or variable amount of rows)

<figure><img src="https://1659501652-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgXnl6gX6OwfIRspyklk3%2Fuploads%2FCc3LfU19NavF0SqQvjY4%2Fimage.png?alt=media&amp;token=d66b8711-24a3-4085-b634-d7bdcb2eec5d" alt=""><figcaption></figcaption></figure>

To do so, we would set up a `template` in the following format

<figure><img src="https://1659501652-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FgXnl6gX6OwfIRspyklk3%2Fuploads%2F7SyrY5Q270VnCQxdbRUg%2Fimage.png?alt=media&amp;token=bbfa978c-0de6-4a21-a4f4-6e3d63a9824f" alt=""><figcaption></figcaption></figure>

When exporting the above extraction to a CSV, it will result in a `CSV export` that has the `name`, `date`, and `description` columns, with four rows (one for each of the extracted data rows)

{% hint style="info" %}
Even if you aren't sure how many rows exist, you can choose to run mathematical expressions based on each occurrence.&#x20;

For example, let's say that we have four rows of data within a table called `DataTable`, each of which contain a `number` column called`Amount`.&#x20;

If we create a separate `Math Expression` field that has the formula of `SUM(DataTable_Amount),`this would return the sum of all of the `Amount` values (e.g., the sum of the `Amount` for all four rows).&#x20;
{% endhint %}

&#x20;