---
title: "Creating a Data Export in xP&A for CFP"
description: "Before data from xP&A can be transferred to Consolidation & Financial Planning, an export containing the desired data needs to be created in xP&A for each model."
source_url: https://support.lucanet.com/en/documentation/xp-a---extended-planning-and-analysis/integrating-data/guideline-data-exchange-xPA-CFP/importing-data-from-xpa-to-cfp/creating-data-export-in-xPA-for-CFP
language: en
last_updated: 2026-05-28
---
# Creating a Data Export in xP&A for Transfer to CFP

## Overview

Before data from xP&A can be transferred to Consolidation & Financial Planning, an export containing the desired data needs to be created in xP&A for each model.

## Instruction

To create and configure an export of the data you want to transfer to CFP in xP&A **per model,** proceed as follows:

{% stepper %}
{% stepper-step %}
In the model you want to export the data from, click the **Settings** button and navigate to the **Export and download** section.
{% /stepper-step %}
{% stepper-step %}
Click **+** to create a new export and configure the steps in the **New export** dialog as follows.
{% /stepper-step %}
{% stepper-step %}
Configure the **Export defintion:**

- Give the export a clear **name** that matches the model (e.g. "Sales forecast").
- Choose the export type **Raw**.

Configuring the export definition
{% /stepper-step %}
{% stepper-step %}
Configure the **Target**:

- Under **Export target**, keep the **Download** preselection
- Under **Export output**, choose **Parquet.**

Configuring the export target
{% /stepper-step %}
{% stepper-step %}
Configure the **Content**:

- Choose what data you want to export: **All values**, a specific **View**, or a named **Version**.

If you work with specific planning versions (e.g. "Forecast 1+11"), choose **Version** and select the relevant one. This is required when you need to map different versions to different data levels in CFP.
- Under **Additionally exported columns,** select at least the columns **Variable ID** and **Scenario**. You can optionally activate **Cell location** if you want to drill down from CFP to the data in xP&A.

Configuring the export content
{% /stepper-step %}
{% stepper-step %}
Click **Create export**.

The export is created and displayed in the **Export and download** section:

Shows an export in the 'Export and download' section.

The export can now be accessed by Consolidation & Financial Planning using the script **Lucanet xP&A #3700-xP&A.SQL.FOS**.
{% /stepper-step %}
{% stepper-step %}
Repeat the above steps for each model whoose output data you want to import into Consolidation & Financial Planning.
{% /stepper-step %}
{% /stepper %}