How to Create a Calendar With Excel Data

Techwalla may earn compensation through affiliate links in this story.

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.


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


Video of the Day

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

Step 3

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


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

Step 5

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


Step 6

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

Step 7

Click "Finish" to complete the importing process.

Things You'll Need

  • Computer

  • Microsoft Excel software

  • Microsoft Outlook software


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.