Your Submissions Can Excel

Excel CSVOne feature requested for a long time from festival producers has been the ability to download the list of festival submissions into an Excel spreadsheet. It was actually in the original outline for the site way back in 2011. Between usability and security settings, it actually turned out to be harder than anticipated, but it’s finally here.

Festival producers* can now download all submission lists (troupes, instructors and/or ensemble submissions) into a .CSV file. For those not super tech literate. This file can be downloaded to your computer and opened by Microsoft Excel. The .CSV format was chosen over the actual Microsoft Excel file format as it is more universal. Users with any spreadsheet program (Open Office, Google Docs etc) can use these file. In addition anyone who is all fancy pants and uses database software instead of regular spreadsheets can import the data as well.

What’s in the sheet? Well, between your festivals information, the troupe’s information, the submission information and the contact person’s information, there could potentially be hundreds of columns and that wouldn’t be useful for anyone. The current spreadsheets contain basic info on each troupe including where they’re from, how to contact them, when they’re available, they’re acceptance status and whether they’ve been contacted (And hey, don’t forget to contact everyone who submits if they’re accepted or not.)

To download the CSV file. Simply go to the submission review page. There will be a button at the top that says “Download CSV”. That’s it. That’s the whole instruction set.

Can this information be changed in the future if needs change? Sure. Might we offer other formats for more tech heavy users (SQL, JSON)? Maybe. We’ll see how it goes and how users needs change. But for now, please check it out and best of luck going through those submissions.

*For now, only the producer (or whoever they assign to be admin for the festival) can download this. It didn’t seem like something all reviewers would need access to. Disagree? My ears are open to any feedback. Drop me a line or leave a comment.



Bill BinderCurrently Bill is an instructor at The Torch Theatre and producer for the Phoenix Improv Festival.
Yes And... Facebook Twitter Google+ tumblr Email