Some calendar programs, such as MS Exchange and Google, only allow their calendar events to be exported as .ics files. In order to import those events into CalendarWiz, you must first import the .ics file into your local Outlook calendar and then export from your local Outlook calendar into a .csv file. The .csv file can be imported into CalendarWiz. See below for detailed instructions:
To Import the .ics file into Outlook:
1. Open Outlook and click on "Calendar"
2. Go to "File" then select "Import and Export”
3. Select "Import an iCalendar or vCalendar file (.vcs)”
4. Browse to find .ics file for import and select file.
Depending on the version of Outlook you are using, the file may automatically import into your local Outlook calendar or it might ask if you want to open this as a new calendar. If asked, you may click “Open As New” if you want to export only these events into CalendarWiz.
Prepare File For Import into CalendarWiz.
- Open Outlook and go to calendar view.
- From the File menu, choose "Import and Export...".
- Choose "Export to a file" and click Next.
- Choose "Comma Separated Values (Windows)" and click Next.
- Choose the calendar folder and click Next.
- Browse to location for saving file and click Next.
- When you see "Export appointments from folder: Calendar", click Finish
- Your file will be saved to the location on your computer.
Before uploading, prepare your import file on your computer. Your import file must contain column headings in the first row similar to Microsoft Outlook Calendar export format. Remaining rows must contain valid event data.
Required Column Headings:
- Subject Event title with maximum of 255 chars
- Start date in mm/dd/yyyy format
- Start time in hh:mm format with am or pm
- End date in mm/dd/yyyy format
- End time in hh:mm format with am or pm
Optional Column Headings:
- All Day Event Contains TRUE for all day event, FALSE for timed event
- Meeting Organizer Contains text information on meeting organizer
- Categories* Calendar category text with maximum of 150 chars (see note on categories)
- Description text with maximum of 5000 chars
- Location text with maximum of 1000 chars
*Note: Categories are used to group events into separate calendar views. Categories in your import file that match exactly with existing calendar categories will place events in those matching categories. Categories that are not already in your calendar will be imported as new categories. The total number of existing plus new categories cannot exceed the total number of categories allowed for your calendar subscription. Trial calendars are limited to three categories. Contact support@calendarwiz.com for more categories.
Locate Import File For Upload
Click on the Browse button to display the file locator window. Use this window to locate and open the import file on your computer. The path to the file will then be shown in the space below.
Upload Import File
Click the upload button below and your file will be uploaded to your calendar. The upload may take a few moments depending on the size of your import file.
After uploading, your imported events will be displayed for your approval. If acceptable, you can then proceed with importing the events to your calendar.
Problems With Import
After uploading you may see warnings and problems identified with you import file. Warnings will not prevent you from importing your events but should be reviewed to understand how these will affect your imported events. Problems identified will prevent you from importing your events and must be corrected in the import file before you can proceed. Some typical warnings and problems are:
WARNING (able to proceed after review)
- Text fields are too long and will be shortened on import
- Invalid date or time, this event will not be imported
- Event missing category, category selected in drop down will be used
- New category found and will be added to calendar
PROBLEM (not able to proceed with import)
- Maximum categories exceeded for this calendar
- Required heading missing on first row of file
- Maximum number of events exceeded