Back to overview

Data Import & Export

Help & Basics Published on 28.10.2025

The application provides powerful tools to import data from external sources or to export your existing data for further processing.

Importing Data

You can import data from a CSV file directly into one of your tables.

CSV File Requirements

  • Format: The file must be in CSV (Comma-Separated Values) format. Common file extensions are .csv or .txt.
  • Character Encoding: UTF-8 is strongly recommended to avoid issues with special characters. ANSI is also supported.
  • Delimiter: The most common delimiters (semicolon, comma, tab) are supported.
  • Header Row: The first row of the file must contain the column headers.

The Import Process

  1. Select File (Step 1): In the table view, click the "Import" button. Upload your CSV file.
  2. Map Columns (Step 2):
    • The system will show you a preview of the first few rows and the detected columns from your file.
    • For each column in your file, you must select the corresponding target field in your table.
    • Important: All required fields in your table must be mapped to a column in the CSV file.
    • If a column from the CSV file should not be imported, select "Ignore this column".
  3. Start Import: After mapping, start the import. The system will process the file and give you a summary of the number of newly created and updated records.

Tip: If your CSV file contains a column named id, the system will try to update existing records with that ID instead of creating new ones.

Exporting Data

You can export the data currently displayed (and filtered) in the table view.

Export Options

  • Filename: Specify a name for your export file.
  • Data Format:
    • Formatted: The data is exported as it is displayed in the table (e.g., date formats, currency symbols). Ideal for reports.
    • Raw Data: The data is exported as it is stored in the database. Ideal for processing in other systems.
  • CSV Options: Choose the character set and delimiter that best suits your target application (e.g., Excel).
  • Other Formats: Besides CSV, you can also export your data as JSON, XML, or a series of SQL INSERT statements.