---
title: "Exporting the Questionnaire to MS Excel"
source_url: https://support.lucanet.com/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/questionnaire-excel-export-import/exporting-questionnaire-to-excel
language: en
last_updated: 2026-11-17
---
# Exporting the Questionnaire to MS Excel in Lucanet ESG Reporting

## Overview

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](https://support.lucanet.com/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/questionnaire-excel-export-import/importing-questionnaire-from-excel.md)).

## Exporting the Questionnaire to MS Excel in ESG Reporting

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.](https://support.lucanet.com/assets/docs-images/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/questionnaire-excel-export-import/exporting-questionnaire-to-excel/_images/en/export-questionnaire-to-excel.png)
    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.

> **Note:** **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.

## Structure of the Exported Excel File from ESG Reporting

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](https://support.lucanet.com/en/documentation/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/questionnaire-excel-export-import/importing-questionnaire-from-excel.md#reusing-an-excel-file-for-another-reporting-entity-in-esg-reporting)).
- **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.'](https://support.lucanet.com/assets/docs-images/esg-reporting/collect-data-esgrep/esg-data-collection-esgrep/questionnaire-excel-export-import/exporting-questionnaire-to-excel/_images/en/exported-excel-file.png)
Category sheet of an Excel file exported from ESG Reporting

## Filling Out the Excel File for the ESG Reporting Questionnaire

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.
