You can import data from Excel into your Outlook calendar. This can make importing things like work schedules much easier.
 It will be a lot easier to import your list into Outlook if your spreadsheet is formatted with the proper headers. Enter the following headers into the first row:


Subject
Start Date
Start Time
End Date
End Time
Description
Location

, The "Subject" field is the name of the event as it appears on your calendar. You don't need to enter something for every field, but you will need at least a "Start Date" as well as the "Subject."


Make sure to enter the date into the standard MM/DD/YY or DD/MM/YY format so that it can be read properly by Outlook.
You can make an event that spans multiple days by using the "Start Date" and "End Date" fields.
 Once you're finished adding events to your list, you can save a copy of it in a format that can be read by Outlook.
 This is a common format that can be imported into a variety of different programs, including Outlook.
 Give the list a name and save it in CSV format. Click "Yes" when asked by Excel if you want to continue.
 Outlook comes with Office, and you'll generally have it installed if you have Excel installed. When Outlook is open, click the "Calendar" button in the lower-left corner to view your calendar.
 You'll see several options for handling Outlook data.
 This will open a new window for importing and exporting data into and out of Outlook.
 You'll be prompted to select the file you want to load from.
 You should usually be able to find it in your Documents folder if you didn't change the default location in Excel.
 It should be selected since you're in the Calendar view in Outlook.
 Your list will be processed and the events will be added to your Outlook calendar. You can find your events in the correct spaces, with times set according to your list. If you included descriptions, you'll see these after selecting an event.
Create a new blank spreadsheet in Excel.
Add the proper headers to your spreadsheet.
Enter each calendar entry into a new row.
Open the "Save As" menu.
Select "CSV (Comma delimited)" from the file type menu.
Save the file.
Open your Outlook calendar.
Click the "File" tab and select "Open & Export.",
Select "Import/Export.",
Select "Import from another program or file" and then "Comma Separated Values.",
Click "Browse" and find the CSV file you created in Excel.
Ensure "Calendar" is selected as the destination folder.
Click "Finish" to import the file.
{"src": "wikihow-all_validation", "title": "How to Create a Calendar in Microsoft Excel2"}