ECON Knowledge Base

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== Importing Events from a CSV file into your Calendar Application ======

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:
    - In the navigation pane on the left side of the Outlook window, right click on the list of calendars and select **New Calendar**.
    - 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:
    - **Replace duplicates with items imported**: Existing data will be overwritten with the information in the file being imported.
    - **Allow duplicates to be created**: Existing data will not be overwritten, and duplicates will be added to the current Outlook folder.
    - **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.
    - Select the calendar you wish to use as the destination folder and select **Next**.
    - 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:
    - Click on the downward arrow to the right of **My Calendars** on the left side of the page.
    - **Select Create new calendar**.
    - 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.