Import a spreadsheet
Bring shows, releases, or contacts in from a CSV or Excel file, check the columns and rows, and import only new records.
Use a computer. Import lives in the header of Shows, Releases, and Contacts.
Use a
.csv,.xlsx, or.xlsfile. The first row must hold the column headers.Keep it to 5,000 data rows or fewer. Split a bigger file.
From Google Sheets, download the sheet as Excel or CSV first.
Importing needs a role that can edit. Contacts can be imported only by members with access to all artists.
The Column mapping table lists each column of your file with an Import as choice. Common headers such as Fee, Guarantee, Status, Show name, or Show date are matched for you. Check every match, change any that are wrong, and choose Skip column for columns you do not need.
Required columns:
Shows: event name, and a date or Date TBD. Also the artist, unless you choose one artist for all rows.
Releases: title. Also the artist, unless you choose one artist for all rows.
Contacts: name.
Suggest columns with AI is optional. It sends the column headers and a small sample of rows to an AI service and fills in suggested matches. If suggestions are unavailable, your mapping stays as it was and you can continue by hand.
For shows and releases, choose how rows get their artist:
Per row: each row uses the artist in the column you mapped to Artist.
One artist: every row goes to the artist you choose. Any artist column is ignored.
With Create missing artists on, artists that are not on your roster yet are created during the import, within your plan's artist limit. Members limited to specific artists can import only for those artists and cannot create new ones.
If show dates have no year, such as 1/24, choose the year under the booking year control. The app suggests a year from the tab or file name.
The Preview shows the first rows as they will be imported. For shows and releases, each row has a status: New, Already exists, or the reason it cannot be imported. A banner groups problems and offers fixes, such as using one year for dates without a year, Switch to Per row, or Create missing artists.
If you change the mapping, artist choice, or year, the rows are checked again before you can import.
Shows and releases that already exist are always skipped, including repeats within the same file and declined or cancelled shows that your Shows filters hide.
A show matches when the artist, date, and event name are the same. A TBD show matches on artist and event name.
A release matches when the artist and title are the same.
Contacts are not checked for duplicates.
The import button tells you what will happen, for example Import 12 new shows. Choose it to import. The result says how many records were added, how many were already in your roster, and how many need fixes. After a successful show or release import, the list opens with the new records.
Imported releases do not get the default release plan. Add the deadlines you need on each release. See Plan deadlines for a release.