Exporting multiple calendars to CSV file

[sharke]

I have a large number of calendars which are sub-items of my main calendar. Every week I have to export each calendar by appointment name and location to a CSV file for processing. The problem is that there seems to be no obvious way to export them all at once.



If I'm exporting them to a .pst file, the dialog gives me the option to "include all subfolders." However this option is missing when exporting to other file types. Which means that I have to export each calendar manually - a real chore, especially as the export tool doesn't even have a date selector to select a range, I have to enter the start and end dates manually.

I've tried a couple of add-ons which allow one to export multiple calendars to CSV, unfortunately they either didn't allow for a date range to be specified, or they didn't allow the mapping of fields and exported everything. My processing requires that I only have the name and location, nothing more.

Does anyone know of an add-on which can do this, or alternatively a convenient workaround to achieve what I'm looking for?