In ESG Reporting, you can export the questionnaire of a reporting entity to an Excel file and fill out the answers in MS Excel. The Excel file contains the current answers of the reporting entity and the rules for filling out the file. The export is available in every status of the reporting entity and the report, but not for canceled reports or for the aggregated report. To save the answers from the completed Excel file in ESG Reporting, import the file again (see Importing the Questionnaire from MS Excel).

To export the questionnaire of a reporting entity to MS Excel in ESG Reporting:

1

Navigate to the ESG Reports workspace, open the report, and click the reporting entity in the Data collection step.

The questionnaire of the reporting entity is displayed.

2

Click Export questionnaire to Excel in the header of the questionnaire.

Shows the questionnaire of the reporting entity 'Entity A' in ESG Reporting with the 'ESRS 2.0' and 'Emissions Module' tabs. Highlighted in red is the 'Export questionnaire to Excel' button in the header of the questionnaire.
Button to export the questionnaire to MS Excel

ESG Reporting creates the Excel file and downloads it to your local device. The file name consists of the report name, the reporting entity, the period, and the date and time of the export.

Notes on the export from ESG Reporting:

  • The labels, choices, and instructions in the Excel file are in your user language.

  • ESG Reporting exports a read-only Excel file in the following cases:

    • The reporting entity no longer has the status In progress.
    • You can export the questionnaire but are not allowed to import it, e.g. as an ESG Administrator who is not assigned to the reporting entity. In this case, you could not import your answers anyway.

    In a read-only Excel file, all cells are locked, and the cover sheet states that the file cannot be imported. You can use a read-only Excel file as a non-editable copy of the answers, e.g. for auditors.

The Excel file exported from ESG Reporting contains the following sheets:

  • Cover: The report, the reporting entity, the period, the guideline, the date and time of the export, and the user who exported the file, followed by instructions on how to fill out the file. The reporting entity is a drop-down list (see Reusing an Excel File for Another Reporting Entity).
  • One sheet per category, e.g. General Disclosures, Environmental, Social, and Governance: The topics, subtopics, and disclosure requirements of the questionnaire as headings, followed by the questions.

In the category sheets, each question is displayed in one row with the following information:

  • The number and the text of the question
  • The guideline text and the additional guidance in two read-only columns. Long texts are shortened in the cell; the full text is available in the cell note.
  • The status of the question: Open, Completed, or Reviewed
  • The current answer in ESG Reporting, if any. Empty answer cells display a grey hint on the expected input, e.g. Text or Amount (EUR, 4 decimals).

The Excel file contains only the questions that are visible for the reporting entity in ESG Reporting. Tables are displayed as grids with their columns and rows; dynamic tables additionally contain empty rows for new entries.

Shows the category sheet for 'E1 Climate change' in an Excel file exported from ESG Reporting, opened in MS Excel. The disclosure requirements 'E1-1' and 'E1-2' are displayed with their questions, the guideline texts, and the status of each question. Question 'E1-1. 11a.' has the status 'Completed' and a pre-filled, greyed-out answer. The empty answer cells of the other questions display the hints 'Amount (EUR, 4 decimals)' and 'Text'. Below question 'E1-2. 14.', a dynamic table with the columns 'Material climate-related' and 'Physical/Transition Risk' contains one filled row, empty rows with the hints 'Text' and 'Select', and the end line 'Insert rows above this line. A row inserted directly below the header row is locked.'
Category sheet of an Excel file exported from ESG Reporting

When you fill out the Excel file exported from ESG Reporting, note the following rules. They are also listed on the Cover sheet of the Excel file.

  • You can type only in the white cells with a border: the answer cells and the reporting entity on the Cover sheet. Question texts and guidance are read-only.
  • Grey answer cells are locked. They belong to questions that are already Completed or Reviewed, to calculated values, and to GHG tables, which are maintained in the Emissions Module. The import ignores them.
  • An empty cell means no change. A cell that still displays its grey hint also counts as empty. The import never clears an answer or deletes a table row; to do so, use the questionnaire in ESG Reporting.
  • For multiple-choice questions, enter the values separated by semicolons (;). Use only the allowed values listed next to the question or, in a table, in the note on the column header or cell.
  • To add rows to a dynamic table, insert them above the end line of the table, or above its total rows if it has any. A row inserted directly below the header row of a table is locked and cannot be filled. Rows added below a table are not imported.

The import checks every value with the same rules as the questionnaire in ESG Reporting. In addition, the following applies to the values in the Excel file:

  • Enter values, not formulas. Cells that contain a formula are rejected.
  • Enter dates as Excel dates or in the format dd.mm.yyyy.
  • Text answers can contain up to 25,000 characters, text in table cells up to 1,500 characters.
  • Numbers and amounts are rounded to the number of decimal places defined for the question.

An invalid value is rejected on its own; the import still saves all other answers in the Excel file.

This content was generated using AI and reviewed by Lucanet subject matter experts before publication.