> 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FSxgy82fIGL9IO8vra6ds%2FK%C3%A9o%20th%E1%BA%A3%20file%20(1).gif?alt=media&amp;token=c1427493-05bd-43f6-a7a1-9b20e6ea9e61" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2Fev0kxmVrXFJONjuI0gUd%2Fimage.png?alt=media&amp;token=a0920c4f-0c4d-4de3-a3b1-455028d3e096" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FMMOjYcyxj9ju5QB8Yq2Y%2Fimage.png?alt=media&amp;token=a6693859-f0f4-4d39-b21d-14ef44437d77" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Double-check the uploaded file

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

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FLAha3mq5H2jfCgAnWaX0%2Fimage.png?alt=media&amp;token=fe61d8c2-6fd5-40a3-bb3c-dd9b3de1cacc" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2Fb7eebHirp9xYewiqrOWK%2Fimage.png?alt=media&amp;token=b4ab750a-5db3-4f08-be3d-661443b10128" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FMnHJx7LrLxypLIqHjURj%2Fimage.png?alt=media&amp;token=af0e8987-f00c-4cff-b32b-43859bf6d2c4" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FI2Mw3AaJSdp2vSuhGWI4%2Fimage.png?alt=media&amp;token=3c6ef5b6-ed16-4875-9fd5-004373434622" alt=""><figcaption></figcaption></figure>

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2Ff7h2zoxjyH2IhUlhJlZL%2Fimage2025-7-8_10-16-11.png?alt=media&amp;token=5aea4ae5-247c-41d9-827a-26ec80c63e0d" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Select file and upload

Select the file > **Upload**.

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FyRsaqHgecUhaITJsF1bk%2Fimage2025-7-8_10-17-58.png?alt=media&amp;token=aefe0ef0-f21f-4b50-a3d5-c6e07488c3f2" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Double-check the uploaded file

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

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FwGkqSxUcRoYtBPHjx12I%2Fimage.png?alt=media&amp;token=53fe43e3-d962-4e1e-837a-a83b00228a65" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FkxhJObMyqcsJr5KDQAPc%2Fimage.png?alt=media&amp;token=eff9f46d-9062-4570-b33a-a8d125bb11b2" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FlvF1zBrPuBovPC0PynYs%2Fimage.png?alt=media&amp;token=d67c6cea-8657-4d5a-b622-adc9a3bd57be" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Select file and upload

Select the file > **Upload**.

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FpMAc2QkuAMhC4Tc9GqqT%2Fimage2025-7-8_10-22-28.png?alt=media&amp;token=d7e2b658-4dda-45f6-967e-58d302005573" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Double-check the uploaded file

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

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FwGkqSxUcRoYtBPHjx12I%2Fimage.png?alt=media&amp;token=53fe43e3-d962-4e1e-837a-a83b00228a65" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2F2tmnM7K9D4dj1xjdv8tQ%2Fimage.png?alt=media&amp;token=d2dc76a8-e48d-4810-a0c9-53ef3c214d63" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FEbBrIRtMqZlZ2Gf7n6f3%2Fimage.png?alt=media&amp;token=53609db3-ed4b-40e0-9e5d-40df8abe44f8" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Complete the dataset creation

Complete the dataset creation process.

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FXyLh8tpdXXbOukDDxJp5%2Fimage.png?alt=media&amp;token=f005ba80-25ef-4c56-8a68-d1bb6a81efe1" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FKBjy6ptu0Q1nGlRdStxQ%2Fimage.png?alt=media&amp;token=05cc34e5-bebd-437d-bd26-e8e0e0567b91" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FOFxClq4ABkpVPp4PNulx%2Fimage.png?alt=media&amp;token=77f4000d-bb23-4240-b749-ea5c907abf9c" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FWIEBhGMoctClQykjzCHy%2Fimage2025-7-8_10-32-37.png?alt=media&amp;token=b17060b6-a1ca-43e1-a6f6-f0eddc7ed0c8" alt=""><figcaption></figcaption></figure>

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FM27cZcsufDfJ48ewVcRP%2Fimage2025-7-8_10-33-37.png?alt=media&amp;token=61d9a79f-95fa-4eaa-943b-047546653741" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Complete the Dataset file information update

Complete the process of updating the Dataset file information.

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FF9zI6RYeu7nrmwIEk0dV%2Fimage2025-7-8_10-37-40.png?alt=media&amp;token=f05e73cd-81f0-41d0-82b3-3b1b5e275c00" alt=""><figcaption></figcaption></figure>
{% endstep %}

{% step %}

#### Synchronize data from source

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

<figure><img src="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2F7Y2QVfXJwDk5gZ70iK7e%2Fimage2025-7-8_10-39-30.png?alt=media&amp;token=4a90efb9-9ccd-4297-9e84-603f2dca18f7" 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="https://207765737-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FpRDG3vvgCOF596sbdkH0%2Fuploads%2FMWFGuDXkibdPIN1KVIaq%2Fimage2025-7-8_10-40-51.png?alt=media&amp;token=5757d7a6-9df1-4fa6-b755-84e5a3649292" alt=""><figcaption></figcaption></figure>
{% endstep %}
{% endstepper %}