How to Create a Calendar With Excel Data

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.

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.

Video of the Day




Report an Issue

screenshot of the current page

Screenshot loading...