MS Excel file (.xls, .xlsx) (#1000)

Getting Started

Global Functions

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

User Interface of Lucanet Consolidation & Financial Planning

General Functions

Basic Configuration

Dashboards

Reporting & Analyzing

Import and Journals

Journals

Importing Data into Reporting Entities

All Steps at a Glance

Defining a Data Source

MS Excel file (.xls, .xlsx) (#1000)

Provision via script (#2075)

Lucanet.Financial Warehouse (#2068)

Creating Assignment Tables

Creating and Executing the Data Import

Assigning Data

Finalizing a Data Import

Updating Data Imports

Importing data into Lucanet.Financial Warehouse

Creating and Executing Scripts

Configuring Period Locks

Planning

Consolidation

Dimensions

Excel-Integration

Workspace Configuration

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

After creating an MS Excel File (.xls, .xlsx) (#1000) data source, the settings for importing data from Excel files are configured in the detail view of the data source.

The following general properties of the data source can be configured in the upper area of the detail view:

Option	Description
Name	Name of the data source
Drill down to posting level	Script for drill-down to posting level Drill-down for Direct Access to MS Excel (Demo) (#5000) (optional)

Specify the type of Excel files you wish to import on the Configuration tab. A description with the structure and the keywords to be used is displayed for each type of Excel file.

Tree view and detail view of a data source. The type 'Excel file contains keywords (simple)' has been chosen in the detail view. — Selection of the type of Excel file to be imported

The Excel file to be imported must be structured according to the description displayed.

The following types of Excel files are available:

Element	Description
Excel file contains keywords (simple)	For this type, the structure of the Excel file must follow a specific pattern so that the Lucanet Excel parser can process the data. All format details are fixed and cannot be changed. As soon as you choose this type: - A detailed description of the structure of the Excel file is displayed. - You can download an example file from the description.
Excel file contains keywords (advanced)	For this type, the structure of the Excel file must follow a specific pattern so that the Lucanet Excel parser can process the data. More keywords can be used than for the simple form. As soon as you choose this type: - A detailed description of the structure of the Excel file is displayed. - You can download an example file from the description.
Reporting package files	This type is used to read in Excel reporting packages. Reporting packages are complex Excel files. An example file for the reporting package can be provided upon request by Lucanet.Consulting. As soon as you choose this type, a detailed description of the structure of the Excel file is displayed.
Freely-definable layout of the Excel file	This type is used to read in data from Excel files with any layout. As soon as you choose this type, a detailed description of the structure of the Excel file is displayed.

Depending on the selected type, further tabs are displayed for configuration specifications. You can find the descriptions of the options on the additional tabs also in the description of the respective Excel type.