Bulk importing sponsorships from CSV

Bulk import lets you create many sponsorships at once by uploading a CSV. It is the fastest way to set up a complex event (10+ tiers) or migrate from a spreadsheet you already maintain.

• You need an org_manager role to bulk import

• The parent event must already exist

• Download the CSV template before building your file — column names must match exactly

1. Open the parent event from Sidebar > Events

2. Click Bulk import in the Sponsorships section

3. Click Download template and open it in your spreadsheet tool

4. Fill in one row per sponsorship — required columns: name, price, inventory, availability

5. Optional columns: description, exposure_tier, display_order, benefits (semicolon-separated)

6. Save as CSV

7. Drag the file onto the upload area

8. Review the preview — Chamberly highlights any errors before importing

9. Click Import

10. Sponsorships are created with availability set to whatever you specified (default not_yet_available)

• Always start with the template — column order and names matter

• Set availability to not_yet_available in the import so you can review before publishing

• Use semicolons (not commas) to separate multiple benefits in the benefits column

• Import a small batch (3-5 rows) first to check formatting, then run the full file

What if my CSV has errors?
The preview shows row-by-row validation. Fix errors in your spreadsheet and re-upload.

Can I update existing sponsorships via bulk import?
Bulk import only creates new sponsorships. To update, use bulk export, edit, then re-import as new.

Are featured images supported in CSV?
Not yet — upload images individually after import.

How many rows can I import at once?
Up to 500 sponsorships per import.

• Bulk exporting sponsorships

• Creating a sponsorship

• Editing prices and quantities