> ## Documentation Index
> Fetch the complete documentation index at: https://docs.luxima.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Import a spreadsheet

> Add products from an Excel or CSV file.

## Prepare your file

* **File types:** Excel (.xlsx, .xls), CSV or OpenDocument (.ods).
* **One row per size or colour.** Each row is one variant.
* **A header row.** The first row holds the column names.
* **At least a product name, SKU or GTIN column.** LUXIMA needs one of these to find your products.
* **A style column, if you have one.** Rows with the same style become one product with several variants.

> [!TIP]
>
> For a file to copy from, open **Integrations** and click **Download example CSV**.

### Columns LUXIMA understands

| Column | Notes |
| - | - |
| GTIN / barcode | |
| Product name | |
| SKU / product code | |
| HS code | |
| Category | |
| Department | |
| Brand name | |
| Season | |
| Weight (g) | In grams. |
| Country of origin | |
| Colour | |
| Size | |
| Composition | The fibre composition. |
| Image URL | A public link to the product photo. |

Your column names do not have to match these exactly. LUXIMA recognises common names, and you can match the rest by hand.

## Import it

**1. Start the import**

On the **Passports** page, click **Import**, then **Upload CSV / Excel**. The import workflow opens with **Excel / CSV** already ticked.

Add other sources if you want them, then click **Start workflow**.

**2. Field sources**

If this is your only source, click **Save and continue**.

**3. Upload the file**

Choose your file and click **Read spreadsheet**. You can choose several files at once; LUXIMA merges them by GTIN and SKU.

**4. Check the columns**

LUXIMA tells you how many rows it read. Click **Show recognised columns** to see how it matched your columns.

Columns it could not match are listed under **Columns Luxima didn't recognise**. For each one, pick the LUXIMA field it belongs to, or leave it as **Not used**. Then click **Read again with these columns**.

**5. Choose the products**

The table lists the products LUXIMA found. Tick the ones you want and click **Add to workflow**.

Use the **Select…** menu to tick a whole page, everything, or everything except flagged products.

**6. Review and import**

Click **Continue** to go to the last step. See [Review and import](https://docs.luxima.io/import-export/review-and-import.md).

## What the table tells you

| Status | Meaning |
| - | - |
| **New** | Not in your catalogue yet. |
| **In Luxima** | Already in your catalogue. The import fills in or updates its data. |
| **Added** | Added to this workflow. |

The filter chips above the table narrow it to **New**, **Already in Luxima**, **Has differences** or **Check grouping**.

## How rows become products

LUXIMA groups rows into products, so that five rows for sizes XS to XL become one product with five variants.

You choose how in **Import settings**, under **Group items into one product by**:

* **Read from the SKUs (recommended)**
* **Only what the source says**
* **SKU without its last part (the size)**
* **First part of the SKU only (the style or model)**

Click **Save grouping rule** after changing it.

### Check grouping

When LUXIMA is not sure about a group, the product gets a **Check grouping** badge and cannot be ticked until you confirm it. Open the row and choose:

* **Grouping looks right**
* **Rename this product**
* **Split into a new product**
* **Move to…** another product
* **Merge with another product…**

## Messages you might see

| Message | What to do |
| - | - |
| "No product rows were found. Check that the file has a header row with a product name, SKU or GTIN column." | Make sure the first row holds column names and that one of those three columns exists. |
| "The spreadsheet could not be read" | Save the file again as .xlsx or .csv and try once more. |
| "CSV / Excel upload isn't included in your plan." | Change your plan in **Settings**, then **Billing & plan**. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.