How To Import a Calendar From Excel to Outlook

Shares & Saves

Many people accustomed to working with spreadsheets use Microsoft Excel for a host of tasks related to keeping track of their important information. Maintaining a schedule of appointments might be included among these tasks. When using Outlook for managing personal information, knowing how to import a calendar created in Excel becomes essential. Outlook offers far more robust scheduling tools and the ability to easily share appointments with other Outlook users.

  • Open Excel and select the data range containing the appointments you wish to move into Outlook by dragging your mouse over the cells that include your appointments.

  • Name the data range by clicking in the field just left of the formula window and entering the desired text.

  • Select "File" and "Save As" from the main menu. In the Save As dialogue box, select "Excel 97 - 2003 Workbook" in the "Save As Type" pull-down menu.

  • Open Outlook. Click the Calendar shortcut button. Select “File” then “Import and Export.”

  • Select “Import from another program or file” in the Import and Export Wizard dialogue box. Click “Next.”

  • Select “Microsoft Excel 97 – 2003” as the file type to import and click the “Next” button.

  • Click the “Browse” button to select the Excel file saved in step 3. Click “Next.”

  • Highlight the calendar where you want the data imported and click the “Next” button.

  • Check the box next to the listed action.

  • Match the fields defined in your Excel data with the available fields in Outlook’s calendar. For example, if you used "Where" to title the Excel column that includes data about where the appointment is, you will need to use the "Location" field in Outlook. Select the imported fields and use your mouse to drag the Excel field over the Outlook field. Fields with identical names will be matched (or “mapped”) automatically.

  • Click the “OK” button when you are finished mapping all fields and click the “Finish” button. Your appointment calendar will now be imported into Outlook.

Tips & Warnings

  • Avoid having to manually match your Excel calendar fields to Outlook by renaming the field names in the first row of your Excel calendar before saving the file for import into Outlook. Principle appointment field names used by Outlook are: Subject, Location, Start, End, and Duration.



  • Photo Credit Pixland/Pixland/Getty Images

You May Also Like

  • How to Link an Outlook Calendar to Excel

    Microsoft has built its programs while making sure you can share information from one application to another seamlessly. This applies to using...

  • How to Use Outlook

    The Best Way to Import Outlook Contacts Into an iPhone. ... How to Use Microsoft Outlook Calendar. If you haven’t used Microsoft’s...

  • How to Convert a Julian Date in Excel

    This tells Excel to convert the formula's output into regular calendar dates. ... The Julian calendar of Roman antiquity had leap years...

  • How to Convert Ics to Xls

    How to Import Excel Files to Microsoft Calendar. Microsoft Excel is one of the most user-friendly spreadsheets available today. Very easy to...

  • How Do I Export My Outlook Calendar?

    How to Export the Outlook Calendar to Excel. ... It is fairly simple to create an Outlook calendar file for importing into...

  • How to Import Email Addresses From Excel to Outlook

    Microsoft Outlook can take information from a Microsoft Excel spreadsheet containing a list of email addresses and transfer the data to the...

Read Article

Your Black Friday/Cyber Monday Survival Guide