> ## 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 Excel

> Downloads an affiliation's research products in Excel format (.xlsx).

## Path parameters

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

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

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

Affiliation identifier.

## Query parameters

### Filters

The same filters as [Search products](https://help.impactu.colav.co/en/api-reference/search/works.md).

**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`.

> [!NOTE]
>
> Unlike the [CSV endpoint](https://help.impactu.colav.co/en/api-reference/affiliation/get-research-products-csv.md),
> this endpoint does not accept the `plot` parameter. To export an indicator's
> data, use the CSV.

## Response

Attached Excel file:

* `Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet`
* File name: `affiliations.xlsx`

File name `affiliations.xlsx`, 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 |


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