❗️Bulk data imports are currently handled directly by the Prospero team. Only data that has been properly formatted can be imported. Please reach out to us at support@prosperoapp.com with your request or questions about formatting. We are working on bringing this functionality into the app.

Supported Formats

Bulk import currently supports one file format:

CSV (comma-separated values)

CSVs are easy to generate with most spreadsheet programs:

Google Sheets - File > Download > Comma Separated Values (.csv)
Excel - File > Save As > Save as type > CSV (Comma delimited)
Numbers - File > Export To > CSV…

Supported Data Types

People
Events

Other data types (like Projects, Locations, and Items) must currently be manually entered in-app. If you need support for another data type, let us know at support@prosperoapp.com.

Schemas

Your data must conform to Prospero’s schema to be properly processed. Schemas for supported data types are described below, along with an example CSV that you can open in your preferred spreadsheet program.

✅ Required fields must be present in a row for that row to be imported. Optional fields may be left blank.

People

The People schema contains the following fields:

	Required fields
legal_first_name	✅
legal_last_name	✅
stage_name
nickname
title
email
phone
notes

Note that not all People fields are supported. The following fields can only be edited in-app:

Pronouns
Headshot

We suggest updating these fields in-app after importing your data.

People Import Example CSV

Events

⏰ Timezone - When submitting your bulk import request, please specify the timezone you would like your Events imported in.

The Event schema contains the following fields:

	Required fields	Usage
title	✅
start_date	✅	`year-month-day` i.e., 2025-06-14
start_time	⚠️	`hour:minute` i.e., 7:30 or 14:00 NOTE: If `start_time` and `end_time` are blank, this will be an all-day Event. `start_time` and `end_time` must be either both populated or both blank.
end_date	⚠️	`year-month-day` i.e., 2025-06-14 NOTE: If `end_date` is blank, the `end_date` will be the `start_date`
end_time	⚠️	`hour:minute` i.e., 7:30 or 14:00 NOTE: If `end_time` and `start_time` are blank, this will be an all-day event. `end_time` and `start_time` must be either both populated or both blank.
status	✅	One of: -Tentative -Confirmed -Canceled
flag		Leave this field blank to keep `flag` off. Use the number 1 to add a flag to this Event
draft		Leave this field blank to keep `draft` off. Use the number 1 to mark this Event as a draft
projects		Project names separated by semicolons i.e., Footloose;The Tempest
role_groups		Role Group names separated by semicolons i.e., Creative Team;Cast NOTE: Including a Role Group name will automatically add all Roles in that Role Group to the Event, as well as the People associated with those Roles
roles		Role names separated by semicolons i.e., Director;Music Director NOTE: Including a Role name will automatically add the Person associated with that Role to the Event, if there is an associated Person
locations		Location names separated by semicolons i.e., Studio A;Mainstage
groups		Group names separated by semicolons i.e., Admin;Cast NOTE: Including a Group name will automatically add all People in that Group to the Event
people		Person emails separated by semicolons i.e., seymour@prosperotheatre.com;ellie@prosperotheatre.com
collections		Collection names separated by semicolons i.e., Rehearsal Set;Footloose Props NOTE: Including a Collection name will automatically add all Items in that Collection to the Event
items		name:quantity separated by semicolons (quantity is optional) i.e., Rehearsal Blocks:4;Band Uniform NOTE: If quantity is not included, all Items in that set will be added to the Event
consumables		name:quantity separated by semicolons (quantity is required) i.e., Coffee:5;Sandwiches:5
tags		Tag names separated by semicolons i.e., Press;Rehearsal
details

❗️If a matching Project, Role Group, Role, Location, Group, Person, Collection, Item, Consumable, or Tag is not present in your account, it will be rejected. Double-check spelling to ensure a smooth import.

Events Import Example CSV