User Tools

Site Tools


importing_events

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
  1. Download the CSV file you wish to import into Outlook and note where it is downloaded to.
  2. Open Outlook if it is not already opened, and select the Calendar view within Outlook.
  3. 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).
  4. Select the File tab at the top of the Outlook window.
  5. Select Open & Export.
  6. Select Import/Export. This will open a new wizard.
  7. Select Import from another program or file within the wizard and select Next.
  8. Select Comma Separated Values and select Next.
  9. 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
  1. Open Google Calendar.
  2. 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.
  3. At the main calendar page, select the downward arrow to the right of Other Calendars on the left side of the page.
  4. Select Import Calendar.
  5. In the pop-up, select Choose File and select the CSV file containing the events you wish to import.
  6. Select the calendar you wish to contain the imported events and select Import.
  7. Your selected calendar will now contain the event data from within the CSV file.
importing_events.txt · Last modified: 2018/09/14 15:01 by mcloughlin