---
title: How to Import Product Gallery Images in WooCommerce Products with Excel
description: Import WooCommerce product gallery images from Excel by listing the images in one column and mapping it.
url: "https://wpfactory.com/docs/how-to-import-product-gallery-images-in-woocommerce-products-with-excel/"
updated: "2026-10-05"
category: How to
---

# How to Import Product Gallery Images in WooCommerce Products with Excel

You can import a WooCommerce product gallery from Excel with [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/) by placing the gallery image references in one Excel column and mapping that column to the Product Image Gallery field. Products Import & Export with Excel reads either image URLs or the names of images already in your Media Library.

### Before you start

- WooCommerce, active.
- [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/), active.
- An Excel (.xlsx) file with your products and a gallery column.

### Step by step

1. Open **WPFactory > Product Import/Export** and stay on the **Import/Update Products** tab. Download one of the sample files linked at the top of the screen if you want a template.
2. In your Excel file, add a column for the product gallery. In each product row, enter the gallery images as comma separated values: either the URL where each image lives, or the name of an image you have already uploaded to the WordPress Media Library.
3. Save the Excel file.
4. Back on the **Import/Update Products** tab, upload your file.

![WooCommerce product import upload screen in Products Import and Export with Excel](https://wpfactory.com/wp-content/uploads/woocommerce-product-import-excel.png)

### Map the gallery column

On the mapping screen, map your gallery column to the Product Image Gallery field. In the **EXCEL COLUMNS** section, drag the button that carries your gallery column onto the **PRODUCT IMAGE GALLERY** field in the **PRODUCT FIELDS** section. You can also tick **Auto Match Columns**, which maps columns automatically when the Excel headers match the product field names.

![Mapping the product image gallery column in Products Import and Export with Excel](https://wpfactory.com/wp-content/uploads/import-product-gallery-images-woocommerce.png)

### Run and verify

1. Press **Upload** to start the import. Products Import & Export with Excel reads the file and attaches the gallery images to each product.
2. Open a few products in the WooCommerce admin to confirm the gallery images imported correctly.

### Get the most from Products Import & Export with Excel

[WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/) imports and updates simple and variable products, images, galleries, categories, and attributes from a single Excel file. [See everything it can do](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/).

Related articles

- [How to Import Affiliate and External Products with Excel](https://wpfactory.com/docs/import-affiliate-external-products-with-excel/)
- [How to Bulk Import WooCommerce Product Translations with Excel for WPML](https://wpfactory.com/docs/how-to-bulk-import-woocommerce-product-translations-with-excel-for-wpml/)
- [How to Import a Variable Product in WooCommerce from One Excel Row](https://wpfactory.com/docs/how-to-import-variable-product-in-woocommerce-with-1-excel-row/)
- [How to Import WooCommerce Products and Assign Category Terms with Excel](https://wpfactory.com/docs/taxonomy-structure-how-to-import-woocommerce-products-and-caterogory-terms-with-excel/)
- [How to Schedule a WooCommerce Product Import from Excel with a Cron Job](https://wpfactory.com/docs/how-to-schedule-excel-woocommerce-product-import-via-cron-job/)