Import Excel appointments into Outlook calendar

Although not strictly an Excel lesson, we show below how to set up an Excel file so that you can create appointments into Outlook by importing it. So if, for example, you want to upload everyone in the offices birthday into a common calendar, you can follow these steps.

What must the Excel File look like

You can probably create it from scratch but a safer way is to DOWNLOAD some calendar entries from your outlook. The 2 benefits of this are that:

  • You will see which calendar is being used as you should recognise the entries, and
  • You will see what you will need to enter.

So in Outlook click on the FILE button and click the Open & Export and then the Import/Export button as shown below.

Import Excel appointments into Outlook calendar

On the next screen choose the Export to a file option

Import Excel appointments into Outlook calendar

Choose the Comma Separated optionImport Excel appointments into Outlook calendarSpecify which calendar you want to export from (remember this as when you import, if you want it to go into this calendar, you must choose this again)

Import Excel appointments into Outlook calendar

Specify where you want to save this file and its name by clicking on the Browse button.

Import Excel appointments into Outlook calendar

Choose Finish

Import Excel appointments into Outlook calendar

If you choose a calendar, it will ask the dates you want to use as shown below. Choose some dates that have appointments in them (remember we just want this as an example file but it is useful to have a few entries).

Import Excel appointments into Outlook calendar

When you click OK it will save the file as a CSV into the chosen folder.

When we open this CSV in Excel we would see this. The important part is the headings it has created. The examples below are useful to understand format required. So for example the column Reminder on/ off is a TRUE/ FALSE entry.

Import Excel appointments into Outlook calendar

Put your appointments into this Excel file

Now that you have a template, put your appointments/ birthdays/ whatever into the correct columns. Try and do it the same way as shown in the template. So rather make dates look the same as the dates shown in the template.

So below I have added an appointment by following these rules

Import Excel appointments into Outlook calendar

 

It is very important you then save this as a CSV, AND close the file down

 

Import Excel appointments into Outlook calendar

Upload the Excel CSV to Outlook

Now you just need to go back into Outlook and import it. In Outlook click on the File button, Open and Export and the Import/ Export button.

Import Excel appointments into Outlook calendar

Now choose the Import from another program or file

Import Excel appointments into Outlook calendar

Choose the Comma Separated Values

Import Excel appointments into Outlook calendar

Find the correct file with the Browse button. You can also choose how it handles duplicates.

Import Excel appointments into Outlook calendar

Specify which calendar it must be put into (people often have more than one calendar)

Import Excel appointments into Outlook calendar

Click FINISH on the final screen

Import Excel appointments into Outlook calendar

It will import and you will see it appear in your outlook.

Import Excel appointments into Outlook calendar