Inserting Tables From ESG Reports

Last updated on 2024-11-11

Overview

In order to use data collected with Lucanet ESG Reporting in Disclosure Management reports, a separate option is provided in the Excel ribbon. This allows tables from previously imported ESG reports to be inserted in an Excel file easily and conveniently.

In order to use ESG data in Disclosure Management documents, the columns of the Excel file must be configured and the output area for display in MS Word must be defined accordingly.

Optionally and if necessary, the values can be adjusted in the rounding view .

This article contains the following sections:

Inserting an ESG Table

To insert an ESG table from an imported ESG Report into MS Excel:

  1. Click Insert ESG table in the Excel ribbon.
    The 'Insert ESG table' command in the Excel ribbon
  2. The Insert ESG table dialog is displayed in MS Excel:
    The 'Insert ESG table' dialog
  3. From the drop-down list that appears, select the table from ESG Reporting that you want to insert into the Excel file.
  4. Click Insert.
     
  • The questions of the ESG reports that were imported for the opened document are available for selection.
  • For each question in an ESG report, a separate Excel file must be created.
  • As soon as you click Insert, all data that may have been present in the Excel file will be overwritten.
  • The Table Type indicates whether it is a static or a dynamic table from ESG Reporting.
  • This function is used to insert values from ESG tables. To insert text-only responses from a questionnaire into a report in Disclosure Management, the Insert ESG text value function is available in the Word ribbon . For more information on inserting text values from ESG reports, see Inserting Text Values From ESG Reports.
Defining Columns

To be able to use the values inserted from an ESG report in Disclosure Management, you must then define the columns of the Excel table, i.e. the name column, the value column(s), the programming column(s) and optionally footnote columns. To do this, proceed as described in the section Creating and Editing Columns. 

The columns of an Excel file into which data from an ESG table has been inserted are structured as follows:

Defining Outareas

In order to display the values that have been inserted from an ESG report in a Word file, you must define the cell ranges as an Outarea. Proceed as described in Defining Outareas.