VueMinder Calendar Help - Export Calendar to Excel

Introduction
- Getting started
- Features
- Tips
- Keyboard shortcuts
- Configuration wizard
- Register VueMinder Calendar Pro
- About VueMinder Calendar Pro
Adding calendars from other sources
Configuring settings and options
Working with menus and toolbars
Viewing calendar data
Viewing and configuring reminders
Working with calendar data
Working with contact data
Exporting and publishing calendar data

Download

Overview

You can export a selected calendar, or all calendars, to Microsoft Excel. The exported data can be saved as an Excel workbook, or any other file type that Excel is capable of saving to, such as XML, HTML, or plain text. This feature requires Excel 2003 or later.
The export calendar window.

Selecting a Calendar To Export

Events belonging to the selected calendar will be exported. If you'd like to export events belonging to all calendars, select the "All calendars" option from the list. Or, to export only those calendars that have checkmarks in the Calendar List, select the "Visible calendars" option.

Selecting the calendar to export.

Date Range

Only events falling within the specified range of dates will be exported.

Select a range of dates to export.

You can specify an automatic date range by selecting an option from the list. You can also choose a custom date range by entering your own start and end dates. Dates can be typed using the keyboard or selected using the drop-down button.

You can select a different automatic date range type.

Exporting Event Appearances

You can choose to format the output to match the event appearance settings by checked the "Export event appearances" box. Each row will be formatted as closely as possible to the format specified in VueMinder Calendar. Note, this will not include secondary background colors or gradient patterns, since these settings are not supported by Excel 2003. If the "Export event appearances" box is unchecked, no colors will be exported.

Exporting

After you've selected a calendar to export and a date range, click the Export button. The export results will update after all the applicable events have been exported. If you have many events, this could take several seconds.

The export results will update as the export is processed.

After all events have been exported to Excel, the exported workbook will display in Excel. Note, the exported workbook has not been saved yet. If you'd like to save the exported workbook, you can save it from within Excel, as you normally would for other spreadsheets.

After exporting, you can save the results to an Excel workbook.

You can also save the results to a different file type, such as XML or HTML, by selecting the desired file type from the list. The list of file types may vary depending on your version of Excel. The example below shows the file type options when using Excel 2010.

You can select a different file type to save the results to.