---
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.

## Creating the Data Export in xP&A

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

1. In the model you want to export the data from, click the **Settings** button the settings icon and navigate to the **Export and download** section.

2. Click **+** to create a new export and configure the steps in the **New export** dialog as follows.

3. Configure the **Export definition:**

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

    ![Shows the 'Export definition' section of the 'New Export' dialog in xP&A](https://support.lucanet.com/assets/docs-images/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/_images/en/new-export-for-cfp.png)
    Configuring the export definition

4. Configure the **Target**:

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

    ![Shows the 'Target' section of the 'New Export' dialog in xP&A](https://support.lucanet.com/assets/docs-images/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/_images/en/target-of-export-for-cfp.png)
    Configuring the export target

5. 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.

    ![Shows the 'Content' section of the 'New Export' dialog in xP&A](https://support.lucanet.com/assets/docs-images/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/_images/en/content-of-export-for-cfp.png)
    Configuring the export content

6. Click **Create export**.

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

    ![Shows an export in the 'Export and download' section.](https://support.lucanet.com/assets/docs-images/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/_images/en/download-export.png)
    New 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**.

7. Repeat the above steps for each model whose output data you want to import into Consolidation & Financial Planning.