Search Online Help

VueMinder Calendar Help - Import Calendar From Excel

Current as of Version 7.1.0

Overview

VueMinder Calendar can import events from a Microsoft Excel workbook, provided the workbook data is compatible with VueMinder Calendar's requirements. The file should be formatted with a header row followed by event rows (one event per row). This feature requires Excel 2003 or later.

The following header column labels are required. These can be in any order:

• Title - Event title
• Start - Event starting date/time
• End - Event ending date/time, required only if Duration is not specified
• Duration - Event duration, required only if End is not specified

• Location - Event location
• Calendar - Event calendar name. If this column is not present, events will be imported into the currently selected calendar in the Calendar List.
• Description - Event description
• Categories - Event category. Separate multiple categories with semicolons.
• Priority - Event priority. The priority name should match the desired priority name, without the numeric prefix, that is shown in the Priorities tab of the Calendar Items List. Example: Medium.

Other unrecognized column names will be imported into the event description.

Settings

If there are duplicate events already present in VueMinder Calendar, you can choose to overwrite these when importing from Excel, rather than creating duplicate copies. Event duplicates are detected based on the event title, owning calendar, and the date and time that the event begins. You can also chose to apply the destination calendar's default event settings to any new events that are imported. Note, to prevent the possibility of a large number of reminders from being displayed after importing, events that occur in the past will not have their reminders enabled, even if the default calendar settings specify a reminder.

Importing

After you've selected an Excel workbook to import, click the Import button. If the workbook does not contain a "Calendar" column, the imported events will be assigned to the active calendar. Otherwise, the imported events will be assigned to calendars matching the calendar names specified in the Excel workbook. Any calendars that don't exist will be created automatically. The import results will be updated after all events from the workbook have been imported. If there are many events in the workbook, this could take several seconds. After the import completes, the Calendar View and Event List will update to show the newly imported or updated events.

Have a Question?

Name:*
Email:*
Subject:*
Message:*
Verification No.:*