Grandstand offers batch upload for lists. Below are key things to keep in mind as you prepare for uploading.
- You will need to organize your content in an excel file and then save it as an .xlsx or .xls file (not a .csv).
- The columns should include a single type of content (ie Column A is the name of the Performer, Column B is the Bio, Column C is their website link).
- During setup please make sure that the labels for the columns below match the order in the Excel spreadsheet. If not, you can drag and drop the lables to match your spreadsheet.
- Make sure you remove the header row with the titles of the columns from your spreadsheet before uploading.
- Make sure the worksheet in your file is the first sheet.
- Batch import is currently capped at 1,000 list items.
- Download a sample spreadsheet to see how to setup your list.
Reorder the Column Order
Column labels must match the order of the spreadsheet columns. To reorder, just drag and drop the column labels into the order used in your file. If you don't use all of the columns move the unwanted labels to the 'Not Included In Upload File' area.
Following are notes about each type of column you can include in the batch upload:
- Title or Name (Required): This is the main name you want for your list entry. If this is a food vendor you would put their vendor name. If this is a speaker, you would put their name.
- List Group (Required): This name must exactly match the name of the list group you would like it to go into. Limited to one list group per line.
- Description: Detail about the list entry. Should include everything but phone number, web address, and location. If you would like a hard return in your description please use the
<br>tag. - Default Photo URL: This is the webaddress of a photo you might want to use, like one that is on your website already. You must include http:// or https://. The best size for the photos is square, max size of 1200px. If an interior page photo URL is not set then the default photo can be used on the detail page if desired. Please note that Dropbox and Google Drive links will be ignored as they do not link directly to a photo.
- Interior Page Photo URL: If you want to use a different image on the detail page from the one on the main list page, you can include an image address here. You must include http:// or https://. If included it will override the default image on the detail page. Please note that Dropbox and Google Drive links will be ignored as they do not link directly to a photo.
- Web Link 1 & Web Link 2: You must include http:// or https://. If you are wanting to link to an email you must start it with mailto: followed by the email address.
- Web Link Button Title & Web Link 2 Button Title: Default title for the button is "View Website. If you want a custom one, you can include it here.
- Phone Number: Should ideally be in the format XXX-XXX-XXXX
- Street Address: Optional address for the list entry
- Reward/Coupon: Match the name/title of the corresponding reward or coupon exactly (must already be added to the coupons/rewards in the Grandstand Admin)
- Location: Match the name/title of the map location exactly from the map locations in Grandstand Admin.
- Location Name Override: Optional custom label that replaces the map location name
- Category Header (Name or Order): If you are using Separators for your list called Category Headers, you will identify which is associated with the item here. Enter either the header's order number or its exact title. The title must exactly match a Category Header configured for that row's list. Please consult List Settings -> Category Headers for the available titles and order numbers.
- Alternate ID: Ignore this, it is used by Grandstand staff only.
- Tags: This is used to help your app user filter the list. Enter multiple tags separated by commas.
- X/Twitter, TikTok, Facebook, Instagram, YouTube, Spotify, Soundcloud, iTunes/Apple Music, Google Play: Enter the full url including https:// for each of these.
- Venmo, Cash App, and Paypal: Enter just the username tag without the @ or $ symbol for each of these.
Lists, Batch Upload