# Studio Excel file

The sheets and columns of the Excel file that holds a Studio project, for reading it, editing it in Excel and uploading it again.

***

A Studio project is one Excel file. Studio reads it when you upload it, and writes it when you choose **Download** under **Project actions**.

Most changes are easier in Studio itself. If you do edit the file, keep a copy first: [undo](/studio/keyboard-shortcuts) cannot go back past an upload.

## Sheets

| Sheet           | Holds                                                                  |
| --------------- | ---------------------------------------------------------------------- |
| `Configuration` | The project’s [settings](/studio/configuration). Change them in Studio |
| `products`      | One row for each product in the project                                |
| `scenario …`    | One sheet for each fixture: where every product sits                   |

Leave any other sheet as it is.

## The products sheet

| Column            | Holds                                                        |
| ----------------- | ------------------------------------------------------------ |
| `id`              | The product’s ID. No two products can share one              |
| `name`            | The product’s name                                           |
| `price`           | The price in pence or cents: `250` for 2.50                  |
| `width`, `height` | The product’s size, in millimetres                           |
| `gtin`            | The product’s barcode number                                 |
| `image_url`       | The web address of the product’s image                       |
| `tags.…`          | A [tag](/studio/tags-and-segmentation), such as `tags.brand` |

## A fixture’s sheet

Each row is one product’s place on the fixture.

| Column                         | Holds                                          |
| ------------------------------ | ---------------------------------------------- |
| `product_id`                   | The product, by its `id` in the products sheet |
| `bay`, `shelf`                 | The numbers of its bay and its shelf           |
| `position`                     | Its order along the shelf                      |
| `facings_wide`, `facings_high` | How many facings sit side by side, and stacked |

The numbers set an order, and can start at 0 or 1. Keep bay numbers to 50 or less, and shelf numbers to 20 or less. **Bay Order** and **Shelf Order**, in [Settings](/studio/configuration), decide which way they run.