> For the complete documentation index, see [llms.txt](https://docs.datasuite.vn/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.datasuite.vn/english/features/connect-and-prepare-data/dataset/file-import.md).

# File Import

Data Suite supports importing data from the following file types:

#### New File Uploads

Users can upload new files from these sources:

* **Supported File Types**: CSV, Excel, Google Sheet
* **Upload Sources**:
  * From computer
  * From Google Drive
  * From OneDrive
* **Size Limit**: Maximum 30MB per upload

#### Existing Files

You can also use files previously uploaded to the system, provided they are still within the allowed storage period.

## Create Dataset from a New File

### Upload Files from Your Computer

{% stepper %}
{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset creation

Navigate to **Workspace > Data Warehouse > Create Dataset > From new file > Browse.**
{% endstep %}

{% step %}

#### Upload the file via drag and drop or browse

In the **Upload File** popup, you can upload files in one of the following ways:

* **Method 1:** Drag and drop a file from your computer into the popup.

<figure><img src="/files/vmwMYXss6hgrDqWWsTzs" alt=""><figcaption></figcaption></figure>

* **Method 2:** Click **Browse Files** > select file > click **Open**.

<figure><img src="/files/lZC64kwEFfEsCJR7VtLh" alt=""><figcaption></figcaption></figure>

* **Method 3:** Click **My Device** > select file > click **Open**.

<figure><img src="/files/BqJ7ddQBs99iYoBuBA1n" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Double-check the uploaded file

**Double-check** the uploaded file before proceeding.

<figure><img src="/files/ZKEr8Qd7vmcagHOmoTsv" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

### Upload Files from Google Drive

Follow the same steps as above, but in the **Upload File** popup, select **Google Drive**.

{% stepper %}
{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset creation

Navigate to **Workspace > Data Warehouse > Create Dataset > From new file > Browse.**
{% endstep %}

{% step %}

#### Select Google Drive

In the **Upload File** popup, select **Google Drive**.

<figure><img src="/files/lPW6r5k2W5i1DaiJ40tZ" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Log in to Google account

Log in to the Google account that contains the file you want to upload.

<figure><img src="/files/cKYiBdWhWVGRlYueSXl9" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Grant access to FPT Data Suite App

Grant access to the **FPT Data Suite App (Trust DS App)**.

<figure><img src="/files/iJ854MLGMGne68vOeKtV" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/EssbykucA3kc9FhYWhfD" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Select file and upload

Select the file > **Upload**.

<figure><img src="/files/ha6WLngU4n6LxkyeG4Mi" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Double-check the uploaded file

**Double-check** the uploaded file before proceeding.

<figure><img src="/files/zoS4XunmWaDbAYeNP8DG" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

### Upload Files from OneDrive

Follow the same steps as above, but in the **Upload File** popup, select **OneDrive**.

{% stepper %}
{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset creation

Navigate to **Workspace > Data Warehouse > Create Dataset > From new file > Browse.**
{% endstep %}

{% step %}

#### Select OneDrive

In the **Upload File** popup, select **OneDrive**.

<figure><img src="/files/zVzysqLqIyNS4UMa2XBI" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Log in to OneDrive account

Log in to the OneDrive account that contains the file you want to upload.

<figure><img src="/files/NhthxDmX9TM6xH8Bm7F8" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Select file and upload

Select the file > **Upload**.

<figure><img src="/files/4aNUoloKSzlA37RGJk4Z" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Double-check the uploaded file

**Double-check** the uploaded file before proceeding.

<figure><img src="/files/zoS4XunmWaDbAYeNP8DG" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

### Create Dataset from a CSV File

{% stepper %}
{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset creation

Navigate to **Workspace > Data Warehouse > Create Dataset > From new file > Browse.**

<figure><img src="/files/yIp0FOb7IvFBFVDF56Nu" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Select file source

Select one of the three file sources (From computer, Google Drive, or OneDrive).
{% endstep %}

{% step %}

#### Select and upload file

Select your CSV file and upload it.

<figure><img src="/files/0CbSTpY0lfiPizATOwzw" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Complete the dataset creation

Complete the dataset creation process.

<figure><img src="/files/YRJJuCioGVFSYBzmvMuY" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

### Create Dataset from an Excel File or Google Sheets

{% stepper %}
{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset creation

Navigate to **Workspace > Data Warehouse > Create Dataset > From new file > Browse.**
{% endstep %}

{% step %}

#### Select and upload file

Select an Excel file or a Google Sheets file and upload it.
{% endstep %}

{% step %}

#### Configure additional settings

Additional settings:

* Select a **sheet**.
* Select the **data range** (cell range) to import into the Data Warehouse.

<figure><img src="/files/5iPc74KymjTqFIpXR4sq" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

{% hint style="warning" %}
**Note:** By default, the first row of the file (CSV, Excel, or Google Sheets) is used as the header. Dataset field names are based on these headers.
{% endhint %}

## Create Dataset from an Existing File

{% stepper %}
{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset creation from available file

Navigate to **Workspace > Data Warehouse > Create Dataset > From Available File.**

<figure><img src="/files/cPAUQ1JA7JzPWH1AOo6R" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Select file

Select a file from the list of previously uploaded files.
{% endstep %}

{% step %}

#### Complete dataset creation

Follow the instructions to complete dataset creation.
{% endstep %}
{% endstepper %}

## Synchronize Data from File to DWH Table

When you need to modify data (update, add, or delete) in a Dataset that was originally created on the DWH from a file source, you'll need to update and synchronize this data to the DWH.

{% hint style="danger" %}
**Note**: When updating a file, do **not modify its structure**—only update its **content**.

* You can:
  * Update the file **locally** (on your computer), or
  * Update it **directly** on Google Drive or OneDrive (if it was originally uploaded from there).
* **Do not change the file structure** (e.g., column names or number of columns).\
  Any structural modifications—such as adding, removing, or renaming columns—will cause synchronization errors.
  {% endhint %}

### For Files from Computer

{% stepper %}
{% step %}

#### Update the file content locally

Update the file content on your computer.
{% endstep %}

{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Navigate to Dataset's Data Origin

Navigate to: **Workspace > Data Warehouse > \[Dataset] > Data Origin**.
{% endstep %}

{% step %}

#### Upload the updated file

Upload the updated file from your computer, Google Drive, or OneDrive.

<figure><img src="/files/Nf9VhyABXNemvTK3JQYP" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/SK6tmqJb55h7f2sV8ssK" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Complete the Dataset file information update

Complete the process of updating the Dataset file information.

<figure><img src="/files/ocpMOwSVLLK8rxBVbos7" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Synchronize data from source

Go to the **Data** tab > select **Update data from source**.

<figure><img src="/files/yf5UPlPZMZVFRYTa4C56" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}

### For Files from Google Drive or OneDrive

{% stepper %}
{% step %}

#### Update the file **directly on Drive/OneDrive**

Update the file content directly on Google Drive or OneDrive.
{% endstep %}

{% step %}

#### Log in to FPT Data Suite

Log in to the FPT Data Suite system.
{% endstep %}

{% step %}

#### Synchronize data from source

Navigate to: **Workspace > Data Warehouse > \[Dataset]** and click **Update Data from Source**.

<figure><img src="/files/riCL9vTG9LPG79VjkVCc" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}