NEW! 👋 Articles Added Daily

Common Batch Upload Problems

Batch Event Upload & Batch List Upload Issues from Excel
Written by Jeff Abele
Updated 9 months ago

Grandstand is one of the only app platforms that allows true batch uploading for nearly all the content in your app. We have two types of batch uploading, event and lists. Here are some common problems users run into when doing batch uploads with excel files:

  1. Date field is not a date field - Please confirm all date fields are marked as valid date fields in Excel or Google Sheets.
  2. Time fields are not setup as 24 hour time - Please confirm your times are listed as 22:00 instead of 10:00 pm for example.
  3. Excel columns don't match your order - If you aren't using a column we recommend removing it from your excel file and dragging that column title in Grandstand Admin from Included in Upload File to Not Included in Upload File. A blank column can cause errors in your upload and result in a false positive upload.
  4. Your Excel file has one or more frozen rows, including a header row. Simply click on the frozen rows, go to the VIEW tab in Excel and hit Unfreeze Panes. Any file with frozen rows will not be able to be uploaded.
Did this answer your question?