Download the EMIT tool (Energy Model Input Translator by RMI) and create custom model components in Excel for both eQUEST and EnergyPlus.
This tool has a number of features. One common use: create custom hourly schedules for an entire year.