# Bulk export & import variant options
Do you have a lot of valuable color samples and you need to convert them into color swatches or image swatches? The bulk export/import variant option will help you do that faster. 😇
## Prerequisites \*
You need to sync data before performing the export/import variant process.
In **dashboard** admin GLO Color Swatch -> click **update data**
Update data
***
## Guide step to step
### 1. Config option variant
* Go to **Dashboad** admin GLOBO Color Swatch
* Find variant type color / image custom
Config button
* Click **config** button
### 2. Export csv
* In page option config, Click export CSV list data value of option
Export CSV
### 3. **Use excel / text editor to open file csv export**
* Use Excel or Text editor to open file csv export. We suggest use **Excel** to Change data
* Data export example in excel tool
Data in excel tool
**Explanation column:**
* Value: name of value option variant,
* Select type: import data type
* Custom: new value data (color, link image)
> You can change only column "Select type" and "Custom"
### 4. Change data **file**
* **Do not edit column "Value"**
* For the value you want to leave blank, use **"one color"** for **"select type"** column and use text "**transparent"** for **"Custom"** column
{% hint style="info" %}
Column "Select type", use only one of the types:\
\&#xNAN;**"One color"**\
\&#xNAN;**"Two color"** \
**"Upload file"**\
**"Image url"**
{% endhint %}
* If you use **"One color"** in "**Select type**", you must enter the color code in the custom column. \
We accept **hex codes**, because hex codes of colors have the most accuracy.
E.g: for one color
Type one color
* If you use **"Two color"** in "**Select type**", you must enter the color code in the custom column and **next to the column custom you need to add the 2nd color code.**
E.g: for two color
Type two color
* If you use **"Upload file" or "Image url"** in "**Select type**", you must enter the url link image.
E.g: for upload image
Type upload image
E.g: for image url
Type image url
### 5. Save data and import data
* Go back to admin GLOBO Color Swatch -> Option Config page
* Click **Import** button
Import button
* The modal import will open, you can **drag** the changed csv file or click the **add file** button
Modal import
* Click to **overwrite** all items if you need to replace the old value
* **Click import** and wait app read file import
* When import done, you can see all data import in column **preview**
Preview data import
* You can check it again and click **save button**
Save data
{% hint style="info" %}
**💡 Tips:** If you have a lot of raw values, you can edit them all at once, then import each page, this trick will be very fast.
{% endhint %}
{% hint style="info" %} This function supports update data entry for existing options, is not the function of adding new variants.
{% endhint %}
