---
title: "Get the company's group structure as Excel"
description: "The group structure as an Excel file: every member in tree order with level, registration number, country, ownership share, immediate parent and the source behind it, rows grouped under their parent, and a sheet with the companies the registry put outside the group in the last 12 months. country and share select members as for the PDF."
url: https://docs.tic.io/api-lens/companies/get-the-companys-group-structure-as-excel
lastmod: 2026-10-31T08:55:08.000Z
---

# Get the company's group structure as Excel

The group structure as an Excel file: every member in tree order with level, registration number, country, ownership share, immediate parent and the source behind it, rows grouped under their parent, and a sheet with the companies the registry put outside the group in the last 12 months. country and share select members as for the PDF.

```http
GET https://lens-api.tic.io/companies/{id}/group/xlsx
```

The group structure as an Excel file: every member in tree order with level, registration number, country, ownership share, immediate parent and the source behind it, rows grouped under their parent, and a sheet with the companies the registry put outside the group in the last 12 months. `country` and `share` select members as for the PDF.

**Requires:** Enterprise+ tier

**Authentication:** API key in the `x-api-key` header.

## Parameters

| Name | In | Type | Required | Description |
| --- | --- | --- | --- | --- |
| `id` | path | integer | yes | Internal company ID |
| `asOf` | query | string | no | The group as it was on this date (yyyy-MM-dd). Default today. |
| `country` | query | string | no | Only these members: `SE` (Swedish), `foreign`, or a country's ISO code (e.g. `NO`). Default all. |
| `share` | query | string | no | Only members whose immediate parent holds this share: `full` (100%), `partial` (under 100%) or `unknown`. Default all. |
| `lang` | query | string | no | File language, `sv` or `en`. Defaults to the caller's locale. |

## Responses

### 200

Excel file

```json
"<binary>"
```

### 400

Unknown country or share value

### 404

Company not found or not accessible

The data of [Group structure](/api-lens/companies/get-the-companys-group-structure) as an Excel file (`.xlsx`), as the view exports it in TIC LENS. One row per member in tree order: its level, its name indented by its depth, organisation number, country, ownership share (a number), the immediate parent by name and organisation number, the source behind the parent and the source's date. The rows are grouped under their parent, so a subtree can be folded, and the header row has filters. A second sheet lists the companies no longer in the group according to the registry.

`country` keeps only the Swedish members (`SE`), the foreign ones (`foreign`) or one country's (its ISO code, e.g. `NO`). `share` keeps only the members whose immediate parent holds 100% (`full`), less than 100% (`partial`) or an unknown share (`unknown`). The members above a selected one stay in the file, in grey, so every row keeps its place in the tree. The same parameters work for the [PDF report](/api-lens/companies/get-the-companys-group-structure-as-pdf).

`asOf` (`yyyy-MM-dd`) gives the group as it was on that date, and `lang` (`sv` or `en`) the language of the file, as for the PDF report. The file is named `TIC koncerntrad <organisation number>.xlsx` (`TIC corporate group ...` in English).