Get the company's group structure as Excel

The data of 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.

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).