---
title: How to Import Simple Products with Attributes Faster
description: Import WooCommerce simple products with attributes faster, one Excel row per product, without creating variations.
url: "https://wpfactory.com/docs/import-simple-products/"
updated: "2026-10-05"
category: How to
---

# How to Import Simple Products with Attributes Faster

## Import simple products with attributes from one Excel row

You can add simple products that carry attributes, without creating variations, using a single Excel row per product with [WooCommerce Products Import & Export with Excel](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/). Put each attribute's values comma separated in one cell, and Products Import & Export with Excel creates one simple product with those attribute values selectable on the product page.

### Prepare the Excel file

Use one row per product. Give each attribute its own column, and enter the attribute's values comma separated in that cell. For example:

| Title | SKU | Weight | Regular price | Size | Color |
| --- | --- | --- | --- | --- | --- |
| product | 123 | 2 | 9 | M,L,XL,XXL | BLUE,RED,GREEN,YELLOW |

A ready-made template is linked at the top of the **Import/Update Products** screen as **Simple Products with Attributes Sample**.

### Tick the right checkbox

On the mapping screen you must tick the checkbox **Create only Simple Product with Attributes, if any ONLY, Not Variations**. This tells Products Import & Export with Excel to add the attributes to a simple product rather than build variations.

![The Create only Simple Product with Attributes, Not Variations checkbox](https://wpfactory.com/wp-content/uploads/Checkbox-attributes-simple-product-article9.3.png)

Your Excel file should not include variable products in the same run, since you are importing simple products only.

### 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 simple, variable, external, and subscription products from Excel, and can update them later just as easily. [See everything it can do](https://wpfactory.com/item/woocommerce-products-import-export-with-excel/).

Related articles

- [How to Import Variable Products When Only Some Attributes Change the Data](https://wpfactory.com/docs/how-to-import-variable-product-with-attributes-when-not-all-attribute-values-change-data/)
- [How to Import WooCommerce Products with a Comma in an Attribute Term Value](https://wpfactory.com/docs/how-to-import-woocommerce-products-in-bulk-with-comma-in-attribute-term-value/)
- [How to Import Category Terms, Attributes, and Brands with Excel](https://wpfactory.com/docs/import-product-terms-attributes-brands-with-excel/)
- [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/)