How to Create a Calendar With Excel Data

Written by catherine johnson
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel is a powerful spreadsheet program that effectively sorts, manages and filters a wide variety of information. Because of Excel's ease of use and broad range of tools, many people use it as a productivity tool by tracking events, projects and dates. If you want to view your Excel data in an actual calendar format, Microsoft makes it easy to convert your data and import it into Outlook, which will automatically format it into an easy-to-read calendar.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Computer
  • Microsoft Excel software
  • Microsoft Outlook software

Show MoreHide

Instructions

  1. 1

    Open the file containing your data in Microsoft Excel. Make sure that your file has a clear header row at the top of the spreadsheet. The header row contains the names of each field in your spreadsheet. These header fields are needed in order to create a calendar with the correct information.

  2. 2

    Go to "File" in the main menu of Excel and choose "Save as." Choose a location on your computer where you want to save your exported file. Go to the "Format" drop-down menu and select "Comma Separated Values (.csv)." Click "OK".

  3. 3

    Open Outlook. Go to "File" in the main menu and select "Import and Export."

  4. 4

    In the "Import and Export Wizard" pop-up window, go to the "Choose an action to perform" section. Choose "Import from another program or file" and click "Next."

  5. 5

    Select "Comma Separated Values (Windows)" in the "Select File Type" section. Click the "Next" button.

  6. 6

    Choose "Calendar" in the "Select destination folder" section and click "Next."

  7. 7

    Click "Finish" to complete the importing process.

Tips and warnings

  • Sometimes Microsoft Outlook may not understand the header fields in your Excel file and may enter your data into incorrect fields. To prevent this, reverse the process. Open Outlook and export one of your calendars into an Excel format. Open the exported calendar in Excel and see the default header fields that Outlook uses. If needed, you can change your header fields in your Excel file to match Outlook's default calendar fields.

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.