Workload Export Capabilities

We need the ability to export workload data to Excel/CSV for any given day (i.e., I need to know how much resource is allocated to each project in our portfolio for a selected date). Has anyone found a way to do this?