---
title: "Exporting and Importing ETL Profiles"
slug: "exporting-and-importing-etl-profiles"
updated: 2026-02-10T16:28:40Z
published: 2026-02-10T16:28:40Z
canonical: "docs.interprose.com/exporting-and-importing-etl-profiles"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.interprose.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Exporting and Importing ETL Profiles

This document explains how to export and import ETL Import Profile configurations in ACE to reproduce consistent ETL behavior. ETL profiles support reusable field mapping and custom columns aligned with the ACE ETL process.

## ETL Profiles

In ACE, Extract, Transform, Load (ETL) profiles store the processes enabling efficient and repeatable data imports from external sources such as CSV, TSV, PSV, and Excel files.

By exporting and importing ETL profiles, organizations can ensure consistent data processing when working with files that share the same format or when migrating configurations between environments.

## Exporting an ETL Import Profile

Exporting an ETL profile allows you to save the profile configuration for reuse or migration.

#### Steps to Export

1. Navigate to Accounts → ETL Import → Profiles.
2. Select the ETL Import Profile you want to export.
3. Locate and select the Export option.
4. Save the exported profile file to your local system.

The exported file contains the ETL profile configuration, including field mapping and custom columns, and can be imported to recreate an identical profile.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/ETL Export Config.png?sv=2026-02-06&spr=https&st=2026-10-31T13%3A37%3A32Z&se=2026-10-31T14%3A37%3A32Z&sr=c&sp=r&sig=07MnqQ6c7aphX5klqsBsPwGs%2F9o2wb2BhRla2d2g3Qc%3D)

Image Displays Export Button in Export Config Section

## Importing an ETL Import Profile

Imported ETL profiles can be used to quickly create a new ETL profile that follows the same file structure and layout requirements.

#### Steps to Import

1. Navigate to Accounts → ETL Import → Profiles.
2. Select New to create a new ETL Import Profile.
3. Locate the Import Config Section.
  1. Choose File and select the previously exported ETL profile file.
  2. Click Import.
4. The new ETL profile should be renamed and saved before changing and testing the configuration.
5. Review and update the ETL profile as appropriate for the file that will be imported.
6. Save the ETL Import Profile.

After saving, the imported profile can be used for manual imports or scheduled ETL jobs, ensuring consistent data transformation and loading.

![](https://cdn.document360.io/6c7303ca-5ffc-4149-8868-8ea498eee635/Images/Documentation/ETL Import Config.png?sv=2026-02-06&spr=https&st=2026-10-31T13%3A37%3A32Z&se=2026-10-31T14%3A37%3A32Z&sr=c&sp=r&sig=07MnqQ6c7aphX5klqsBsPwGs%2F9o2wb2BhRla2d2g3Qc%3D)

Image Displays Import Config Section

## Validation and Testing

After importing an ETL profile, it is important to:

- Test the profile with a sample file to confirm data loads as expected.
- Verify required fields based on the ACE Import Layout documentation related to the Load Method.
- Confirm configuration options are configured and behaving as expected.