> ## Documentation Index
> Fetch the complete documentation index at: https://help.impactu.colav.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Export products to CSV

> Downloads an affiliation's research products as CSV, or the data of an indicator when the plot parameter is used.

This endpoint has two modes:

* **Product export** (without `plot`): downloads a CSV with all the affiliation's products, applying the active filters.
* **Indicator export** (with `plot`): downloads a CSV with the data of the given indicator instead of the product list.

## Path parameters

**affiliation\_type** `string` *required*

Affiliation type: `institution`, `faculty`, `department` or `group`.

**affiliation\_id** `string` *required*

Affiliation identifier.

## Query parameters

**plot** `string`

Name of the indicator to export. With this parameter the indicator's CSV is
downloaded instead of the product list. See the [indicator
catalogue](https://help.impactu.colav.co/en/api-reference/affiliation/plots/overview.md).

### Filters

The same filters as [Search products](https://help.impactu.colav.co/en/api-reference/search/works.md). They also
apply when `plot` is used.

**years** `string`

Year range: minimum and maximum separated by a comma. Example: `2020,2026`.

**product\_types** `string`

Product types. Example: `impactu_Artículo de revista`.

**status** `string`

Open access status. Example: `diamond,gold`.

**topics** `string`

OpenAlex topics (URL). Example: `https://openalex.org/T14483`.

**countries** `string`

Co-authors' countries, by code. Example: `CO`.

**authors\_count** `string`

Number of authors: `5` (exactly), `5-` (5 or more), `-5` (up to 5) or `5-8`
(range).

**authors\_ranking** `string`

Author classification. Example: `Investigador Junior`.

**groups\_ranking** `string`

Group classification. Example: `A1,A`.

**institutions\_type** `string`

Co-authors' institution type (ROR). Example: `education,company`.

## Response

Attached CSV file (`Content-Type: text/csv; charset=utf-8`).

**Without `plot`** — file name `affiliations.csv`, with the following columns:

| Column | Description |
| - | - |
| `id` | Product identifier |
| `title` | Main title |
| `language` | Language |
| `authors` | Authors separated by `\|` |
| `open_access_status` | Open access status |
| `bibtex` | BibTeX entry on one line |
| `openalex_citations_count` | Citations according to OpenAlex |
| `scholar_citations_count` | Citations according to Scholar |
| `subjects` | Subject areas separated by `\|` |
| `primary_topic` | Primary topic: Topic, Subfield, Field and Domain separated by `\|` |
| `year_published` | Publication year |
| `doi` | DOI |
| `publisher` | Publisher |
| `openalex_types` | OpenAlex types separated by `\|` |
| `scienti_types` | Scienti types separated by `\|` |
| `impactu_types` | ImpactU types separated by `\|` |
| `source_name` | Name of the source (journal) |
| `source_apc` | APC information of the source |
| `source_urls` | URLs of the source |
| `institutions` | Authors' institutions separated by `\|` |
| `faculties` | Authors' faculties separated by `\|` |
| `departments` | Authors' departments separated by `\|` |
| `groups` | Research groups separated by `\|` |
| `countries` | Authors' countries separated by `\|` |
| `groups_ranking` | Group classifications with their date, separated by `\|` |
| `ranking` | Product classification |
| `issue` | Journal issue |
| `pages` | Number of pages |
| `start_page` | Start page |
| `end_page` | End page |
| `volume` | Volume |
| `scienti_id` | Scienti identifier |
| `minciencias_id` | Minciencias identifier |

**With `plot`** — file name `<indicator_name>.csv`. Each indicator has its own columns; see the [indicator catalogue](https://help.impactu.colav.co/en/api-reference/affiliation/plots/overview.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.