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
- 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.
importing_events.txt · Last modified: 2018/09/14 15:01 by mcloughlin