ECON Knowledge Base

This is an old revision of the document!

With this tutorial, you will learn how to import comma separated value (CSV) files into your calendar application.

Outlook

Download the CSV file you wish to import into Outlook and note where it is downloaded to.
Open 'Outlook' if it is not already opened, and select the 'Calendar' view within Outlook.
'This step is optional:' If you wish to create a separate calendar for the events that will be imported, you can do so now:
1. In the navigation pane on the left side of the Outlook window, right click on the list of calendars and select 'New Calendar'.
2. Name the calendar and save it where you wish (the folder 'Calendar' is the default choice selected).
Select the 'File' tab at the top of the Outlook window.
Select 'Open & Export'.
Select 'Import/Export'. This will open a new wizard.
Select Import from another program or file' within the wizard and select 'Next'.
Select 'Comma Separated Values' and select 'Next'.
Navigate to the CSV file you wish to import and select it. Then, choose what you wish to do with duplicate items and select 'Next'. There are three options:
1. 'Replace duplicates with items imported': Existing data will be overwritten with the information in the file being imported.
2. 'Allow duplicates to be created': Existing data will not be overwritten, and duplicates will be added to the current Outlook folder.
3. 'Do not import duplicate items': Existing data will be kept, and the duplicate information in the file will not be copied to the current Outlook folder.
4. Select the calendar you wish to use as the destination folder and select 'Next'.
5. The wizard will now show the actions to be performed. Select 'Finish' and the events within the CSV file will be added to your chosen calendar.

Google Calendar

Open Google Calendar.
'This step is optional:' If you wish to create a separate calendar for the events that will be imported, you can do so now:
1. Click on the downward arrow to the right of 'My Calendars' on the left side of the page.
2. Select 'Create new calendar'.
3. Fill out the information and click 'Create Calendar'.
At the main calendar page, select the downward arrow to the right of 'Other Calendars' on the left side of the page.
Select 'Import Calendar'.
In the pop-up, select 'Choose File' and select the CSV file containing the events you wish to import.
Select the calendar you wish to contain the imported events and select 'Import'.
Your selected calendar will now contain the event data from within the CSV file.