> For the complete documentation index, see [llms.txt](https://jue-yuan-ti-cai-gousorganization.gitbook.io/bulk-image-butler/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://jue-yuan-ti-cai-gousorganization.gitbook.io/bulk-image-butler/quick-start-guide-for-bulk-image-butler-excel-mode.md).

# Quick Start Guide for Bulk Image Butler - Excel Mode

### Welcome!

We're thrilled you've installed Bulk Image Butler. Here's a quick guide to help you get started!

#### Overview

Bulk Image Butler has two modes. Now, let's learn about the `Excel Mode`. In this mode, you export product images to an Excel file, make edits, and then import the Excel file back to sync with your store.

#### Steps in Excel Mode:

1. Export the Excel file.
2. Edit the Excel file: add new images, update existing images, or delete images.
3. Import the Excel file.

Let's get started!

#### Export the Excel file

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2F8FsHS7dEjXpqyRz3IhOz%2F%E5%AF%BC%E5%87%BA%20Excel_%E6%96%B0.gif?alt=media&amp;token=f37d7aa5-88d3-4963-a0ba-13b3d4a27d13" alt=""><figcaption></figcaption></figure>

1. Go to `Bulk Image Butler` > `Product Images`.
2. Click `More`, then `Export Excel`.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FSqba67AwWyxqIpYCp5Js%2Fimage.png?alt=media&amp;token=a5a74b4f-7038-4f60-a064-a2865522dbd6" alt=""><figcaption></figcaption></figure>
3. In the confirmation box, select the default options and click `Confirm`.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FYqi9MfoH2G0pqQEhEPLV%2Fimage.png?alt=media&amp;token=94c702f6-f744-4cb7-8552-f1576b1ac761" alt=""><figcaption></figcaption></figure>
4. Wait for the export to complete, then click `Download` to get the Excel file.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FCq7xgoRVAbcjNxpv8KpZ%2Fimage.png?alt=media&amp;token=695daec1-94e7-4c6e-9667-d1f67ad6b106" alt=""><figcaption></figcaption></figure>

#### Edit the Excel File

Open the exported Excel file.

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FqS6jVZ9zKDWmfWWxjUp2%2Fimage.png?alt=media&amp;token=5d828769-caf4-430c-a0b8-3cd32d6b2e97" alt=""><figcaption></figcaption></figure>

**Understanding Each Column**

| Title          | Description                                                                                                 |
| -------------- | ----------------------------------------------------------------------------------------------------------- |
| Product Title  | The product's title, indicating which product this data belongs to. Do not modify this column.              |
| Image Url      | The current image URL for display purposes. Do not modify this column.                                      |
| Image AltText  | The image's AltText. Edit this to update the alt text in your store.                                        |
| Image Position | The image's position. Edit this to reorder images. Leave blank for new images to be placed last.            |
| Variants       | The variants the image belongs to. Separate multiple variants with commas. Each variant can have one image. |
| Action         | The action to perform: `A` (Add), `D` (Delete), `U` (Update). This is the most important column.            |
| New Image Path | The path to the new image. Supports URLs or relative paths for images in a zip file.                        |
| Product ID     | The product's ID. Do not modify this column. Ensure it's correct when adding new images.                    |
| Image ID       | The image's ID. Do not modify this column. Used for deleting or updating images.                            |

**Adding Images**

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FxZTGqeaYByvRvCqBUPAA%2F%E6%96%B0%E5%A2%9E%E5%9B%BE%E7%89%87_%E6%96%B0.gif?alt=media&amp;token=fa7d2bcd-b23c-428a-821d-243ff5a2b6c0" alt=""><figcaption></figcaption></figure>

1. Add two new rows under `Straw Large Capacity Bag` and fill in the `Product Title` and `Product ID` correctly.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FNoLOgYNfCyFdxyhgnCWR%2Fimage.png?alt=media&amp;token=d97f3463-87da-42cf-af6e-5db761e53d6e" alt=""><figcaption></figcaption></figure>
2. Add image details:
   * URL: `https://cdn.pixabay.com/photo/2024/01/11/12/46/pitbull-8501582_640.jpg`
   * Local image: `german-shorthaired-pointer-8655457_1280.webp` (inside a zip file).

     <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FcXtzdc2uYJNBAb5BOkbP%2Fimage.png?alt=media&amp;token=c968a0cf-7aee-4316-945c-184334738d60" alt=""><figcaption></figcaption></figure>

Fill in the `Action` column with `A` for Add and provide the image path in `New Image Path`.

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FOT2O3huyjRJSKQT4vuge%2Fimage.png?alt=media&amp;token=13641171-f0bf-45aa-ada2-3454bf2f1d08" alt=""><figcaption><p>Change complete</p></figcaption></figure>

**Updating Images**

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FQRmDteFjK4Jk7BjxFr3A%2F%E7%BC%96%E8%BE%91%E4%BA%A7%E5%93%81%E4%BF%A1%E6%81%AF.gif?alt=media&amp;token=420a4f07-7f1f-4c67-acb6-b9aa0510e9ac" alt=""><figcaption></figcaption></figure>

1. For `frog sku`, update `Image AltText`, `Position`, and `Variants`.
2. Make sure to fill in the `Action` column with `U` for Update.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2Fr1p2BzMnxq59gUT3gCMQ%2Fimage.png?alt=media&amp;token=555d1359-3d05-40dc-91dd-39cf3f755289" alt=""><figcaption><p>Change complete</p></figcaption></figure>

**Deleting Images**

1. For the image you want to delete, fill in the `Action` column with `D` for Delete.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FDxkIvrIEkll5FgrR2bK2%2Fimage.png?alt=media&amp;token=a888c638-6e35-4f32-bc4c-ea5247424247" alt=""><figcaption></figcaption></figure>

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2Fl84VCEEzdjvghdHKt4nY%2Fimage.png?alt=media&amp;token=8e9e146f-7dad-4a35-8a2e-69518fbfb881" alt=""><figcaption><p>All Change complete</p></figcaption></figure>

#### Import Excel

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2F3mUOL4LGzKZkvb9Scrhw%2F%E5%AF%BC%E5%85%A5%20Excel.gif?alt=media&amp;token=80d82001-4533-4b49-8f2e-c260961dc38e" alt=""><figcaption></figcaption></figure>

1. Go to `Bulk Image Butler` > `Product Images`.
2. Click `More`, then `Import Excel`.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FLwxr5tAPnC6rKRoMVpPO%2Fimage.png?alt=media&amp;token=8744ed35-d638-4d45-938a-870354f9d035" alt=""><figcaption></figcaption></figure>
3. In the pop-up window, upload the Excel file and the image zip file. Click `Confirm`.

   <figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FEs1Ec8BCZTnnZaE07bAP%2Fimage.png?alt=media&amp;token=7bfdd0d0-01e5-4b42-ba43-d3bb8a9b0651" alt=""><figcaption></figcaption></figure>

The system will validate each row in the Excel file and then redirect to the task details page. You can review and remove changes if needed. Click `Start Task` to execute the task.

<figure><img src="https://2181722770-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FTyOK0hWsjCpRtoqE4Zxz%2Fuploads%2FE7y5WO5SPS7M93p3bpMY%2Fimage.png?alt=media&amp;token=4b62847c-8a91-4f60-a292-318208447e82" alt=""><figcaption></figcaption></figure>

#### Conclusion

That's it! You've completed the Excel Mode tutorial. Thank you for reading. Feel free to explore other documentation. If you have any questions, please contact us.