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?

[Technician]

1. Open Outlook
2. Click File menu
3. Click Import and Export
4. Click Export to a file
5. Click Comma Separated Values (Windows)

You may be required to install the possible translator here. Just follow the directions on the screen.

6. Select folder to export from: Calendar
7. Browse, name, and save the file some place easy to find it. (Desktop)
8. Click Next

Outlook will prompt you to specify the start and end date of the period which should be exported

9. On the follow actions will be performed screen click the Finish button.

[sharke]

Hi Admin,

Thanks for the reply but I think you misunderstood the question. I already know how to export individual calendars to a CSV file - what I'm looking to do is export all of my calendars to a single CSV file in one step. Like I said, you can multi-select calendars when you export to .pst but not when you're exporting to other file types (which seems a little bizarre).