Data import

Table of contents

• Overview
• Supported formats
• Steps to import data
• Configuration details

Overview

You can import data into CloudBeaver from various file formats. Start the import process from the Data Editor.

Supported formats

CloudBeaver supports the following formats for data import:

• CSV
• XML
• XLSX

Note: The Community Edition supports only CSV files.

Steps to import data

To import data to the CloudBeaver, follow these steps:

1. Select the table where you want to import data and click Import in the bottom toolbar.

   

   Important: Make sure the table has a Primary Key or a Unique Key, as the import is only available for such tables.

2. Pick the format you need from the list of available options.

   

3. Upload the file from your local storage, then click Import.

   

   Note: The import runs in the background, so you can keep working without interruptions.

4. Check for a confirmation message indicating the import was successful.

Configuration details

When importing data:

• Use CSV files with comma delimiters.

• Make sure the table structure (columns) in your file matches the target table. Mismatched columns will cause errors.

• Ensure primary key values are unique to avoid duplicate entries and maintain data integrity.