# Importing prizes

Category: [Prizes, Instant Wins & Winners](https://basecomp.io/help/prizes-and-winners)
Updated: 2026-10-30

> Import many prizes at once from a CSV file in Prize Catalogue > Import Prizes, creating new prizes or updating existing ones by name or ID.

You can add or update many prizes at once by uploading a CSV file in [Prize Catalogue > Import Prizes](https://basecomp.io/dashboard/go/prizes/import) (or the **Import** button on the Prizes page). The importer maps your spreadsheet's columns to prize fields, then creates new prizes, updates existing ones, or both.

Don't see **Import Prizes** in your sidebar? Add the **Import** app from [Apps](https://basecomp.io/dashboard/go/apps). See [Adding and removing apps](https://basecomp.io/help/getting-started/adding-and-removing-apps).

This is the quickest way to bring a prize list across from another platform or a supplier's spreadsheet. The menu item needs the **Create Competitions** team permission.

### Before you start

Click **Download CSV template** at the top of the import page for a sample file with every column filled in. A few rules:

- Your CSV must have headers in the first row.

- Money is in pounds, not pence: 199.99 , not 19999 .

- Separate multiple values with a semicolon, for example VIP;Experiences in the Categories column.

- Test with a small batch before importing your whole catalogue.

### The columns

Three fields are required: **Prize Name**, **Prize Value** (retail) and **Prize Cost** (what you paid). The optional ones are:

- **Prize ID**: only needed if you want to update existing prizes by ID.

- **Prize Description**.

- **Status**: active (or enabled , on ) makes the prize active. A blank cell also means active. Any other value makes it inactive.

- **Prize Type**: physical , cash , credit or digital . A new prize with no type is created as physical.

- **Cash Alternative Enabled** and **Credit Alternative Enabled**: yes / no (or true / false , 1 / 0 ). Leave blank to follow your store rates.

- **Cash Alternative Value** and **Credit Alternative Value**: a fixed amount in pounds. A value on its own also switches that alternative on for the prize.

- **Categories**: category names, separated by semicolons.

The importer recognises common header names (such as Price, Value, Cost or COGS) and maps them for you.

Pictures are not imported: the template has an Image URLs column, but this version of the importer does not fetch images from it. Add pictures on each prize afterwards, or through the [Media Library](https://basecomp.io/help/website/using-the-media-library).

### Running an import

- Choose your file under **Select CSV file**. The **Field reference guide** lists every field and marks the required ones.

- Under **Import settings**, pick **What do you want to do?**: **Import all prizes**: update prizes that match, create the rest.

- **Only update existing prizes**: rows that do not match an existing prize are skipped.

- **Only create new prizes**: rows that match an existing prize are skipped.

- If you are updating, choose **Match prizes by**: **Prize Name** or **Prize ID**.

- Turn on **Create categories that don't exist yet** if your file names categories you have not created.

- Under **Map CSV columns**, check each column is mapped to the right field, or skipped. The box headed **How your import will work** summarises what will happen.

- Click **Start import**.

The progress panel counts rows **Processed**, **Created**, **Updated** and **Failed**, and lists any **Row errors** so you can fix those rows and import them again. Duplicate rows for the same prize name in one file are merged into one prize.

### What an update keeps

Things the CSV has no column for are left as they are when a prize is updated: its supplier, who ships it, the graded card and winner's choice settings, and whether it is marked out of stock. Fill in the value and cost on every row you import, including updates.

### See also

- [Adding prizes to your catalogue](https://basecomp.io/help/prizes-and-winners/adding-prizes-to-your-catalogue)

- [Prize categories and suppliers](https://basecomp.io/help/prizes-and-winners/prize-categories-and-suppliers)

- [Importing competitions](https://basecomp.io/help/competitions/importing-competitions)

- [Moving to Basecomp from another platform](https://basecomp.io/help/getting-started/moving-to-basecomp-from-another-platform)
