Fix a spreadsheet import
Find out why the import button is disabled, why rows were skipped, or why nothing was imported.
Use a CSV or Excel file. Save the file as
.csv,.xlsx, or.xls. From Google Sheets, download it in one of these formats.More than 5000 data rows. Split the file, or filter rows in Excel first.
Make sure the first row holds the column headers.
| Issue | Fix |
|---|---|
| Date needs a year | Pick the booking year, or choose the banner fix that uses the detected year for all dates. |
| Artist not in roster | Turn on Create missing artists, correct the artist names, or add the artist to your roster first. |
| Artist doesn't match | The file has an artist column while One artist is chosen. Choose Switch to Per row, or keep One artist and ignore that column. |
| Missing artist | Map the artist column, or switch to One artist. |
| Missing event name or Missing release title | Fill in the cell in your file, or map the right column. |
| No permission for artist | You can import only for the artists you have access to. |
Shows and releases that already exist are skipped on purpose. A show is a duplicate when the artist, date, and event name match an existing show, including declined or cancelled shows that your Shows filters hide. A release is a duplicate when the artist and title match. Rows repeated within the same file are skipped too.
For contacts, rows without a name are skipped.
If the result says no shows were imported, check the event name, date, and artist columns in the preview. If it says every row already matches your roster, the records are already there; search for one to confirm.
Create missing artists cannot go past your plan's artist limit. If the import reports that the artist limit is reached, remove an artist you no longer manage or ask the owner to change the plan, then import again. See Plans, trial, and billing.
Choose Report a problem in the sidebar. Describe the import type, the button text, and the issue labels you see. Do not attach files with private data you are not allowed to share. See Get help and report a problem.