How to Import Excel Files to Microsoft Calendar

Written by
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Import Excel Files to Microsoft Calendar
Import calendar data stored in an Excel spreadsheet into your Microsoft Outlook calendar. (number background image by kuhar from Fotolia.com)

Microsoft Excel is one of the most user-friendly spreadsheets available today. Very easy to customise, Excel can be used to record almost anything. A lot of people use Excel to track finances or chores, while many others use it as a calendar. However, it is also easy to use the Microsoft calendar feature in Outlook. Once you have created your calendar in Excel, the data can be easily imported from Microsoft Outlook.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Customise your Excel. The first thing you will need to do when you are exporting contact or calendar information to Outlook is to customise your spreadsheet. Examine the calendar section in Outlook. You will want to customise the fields in Excel to match the information that Outlook has. For example, when you import your appointments, Outlook has information about the appointment name, subject, location, start time and end time. You would want to title the columns of your Excel spreadsheet to match that information.

  2. 2

    Save your data after completing your spreadsheet. Select all of the columns and rows that contain the information you want to import. Include the column headings. To the left of the address bar, type in a name that refers to the selection and press Enter to save it. For example, use "addresses" or "meetings" to name the selection. Save your workbook as Excel 97-2003 compatible. After you have saved it, exit Excel.

  3. 3

    Import your information. Open Microsoft Outlook. To import the information, open the "File" menu and select "Import and Export." A dialogue box will open. Select "Import from Another Program or File." Select "Next," then "Microsoft Excel 97-2003." Select "Next" to locate your file. Click on "Browse" and find the Excel worksheet that you saved. Select the spreadsheet and click "Next." This shows the folders that are available to import into Outlook. Highlight the Calendar option and select "Next." You will see a summary of what you have selected. It should read "Import [file name] into folder: calendar," with [file name] representing the name of the Excel file you made, such as "addresses" or "meetings."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.