DISCOVER
×

How to Create a Calendar With Excel Data

Updated March 23, 2017

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.

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.

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".

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

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."

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

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

Click "Finish" to complete the importing process.

Tip

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.

Things You'll Need

  • Computer
  • Microsoft Excel software
  • Microsoft Outlook software
bibliography-icon icon for annotation tool Cite this Article

About the Author

Catherine Johnson is a freelance writer and designer. Her writings on computer software, electronics, cooking, digital photography, home office productivity, organization, and online technologies have been published by Demand Studios, eHow, Bright Hub, and Associated Content. She has also produced award-winning graphic design, digital images, and websites since 2003.