# Merge with Existing Data

### Step 1. Start Upload

<figure><img src="https://3915316711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F4Zi4DUBWVyn4O8rOlReW%2Fuploads%2FXl6tyYMxShktDLEoTO6C%2Fimage.png?alt=media&#x26;token=790422cc-2aae-44d2-a589-c92b655b49d1" alt=""><figcaption></figcaption></figure>

* Click the **+Molecule/Data** button and select **Upload file**.
* In the upload window, select **Merge with existing data** on the left.
* Choose the file you want to upload.

**Supported file formats:** SDF, TSV, CSV

* Only one file can be uploaded at a time.

Check the file name and number of files in the upload area, then click **Next**.

⚠️ **Note**

* Files larger than 50 MB cannot be uploaded.
* Files containing more than 2,000 molecules cannot be uploaded.
* Different file formats cannot be uploaded at the same time.

***

### Step 2. Review File Information

<figure><img src="https://3915316711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F4Zi4DUBWVyn4O8rOlReW%2Fuploads%2FLX3LyrxMLclNx8gbhj3F%2Fimage.png?alt=media&#x26;token=19403d28-b68a-4bd4-bbb3-004a491005aa" alt=""><figcaption></figcaption></figure>

* A preview of the uploaded data will be displayed.
* **Select Merge Key Column**
  * Merge Key: Select either molecule name or molecule structure.
  * Key Column: By default, Name / SMILES columns are recognized automatically. If not recognized, select them manually.
* **Match with User Fields**
  * Select which fields to update during merge and define how to update them.
  * If needed, check the option **Add unmatched data as new molecules**.

***

### Step 3. Review Upload Result

<figure><img src="https://3915316711-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F4Zi4DUBWVyn4O8rOlReW%2Fuploads%2FadPhiDusjjdPsCmKQViT%2Fimage.png?alt=media&#x26;token=5dc4b4d9-beca-4c35-a986-384ecd559215" alt=""><figcaption></figcaption></figure>

* The expected upload results are displayed, including:
  * Total molecules in the file
  * Molecules to be added
  * Molecules to be updated
  * Molecules not added
* To run calculations immediately after upload, check the calculation option.
* Click **Update** to proceed with the upload.

#### Preview Upload Result

⚠️ **Failed Molecules**\
If some molecules could not be added, a **Molecule Addition Failed** message will appear.\
You can download a separate file containing the failed molecules.
