Import Excel Calendrer in Outlook

 

First, please save your Excel as a .csv file. Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets.

• ln your workbook, click the worksheet with the calendar information you want to import.
• Click File > Save As.
• Choose where to save your file.
• In the Save as type box, choose CSV (Comma delimited) (*.csv), and click Save.

Excel tells you “The selected file type does not contain workbooks that contain multiple sheets.” This refers to a limitation of the CSV file; nothing will happen to your original workbook (the .xlsx file).

• Click OK.

Excel tells you “Some features in your workbook might be lost if you save it as CSV (Comma delimited).” This refers only to limitations of the CSV file and can be ignored.

•  Click Yes to have Excel save the current worksheet as a CSV file. The original workbook (the .xlsx file) closes.
•  Close the CSV file.

You're done with Excel. Now, you can start the import process in Outlook.

Next, please import your calendar to Outlook.

• At the top of your Outlook ribbon, choose File.
• Choose Open & Export > Import/Export.
• Choose Import from another program or file and then click Next.

• Choose Comma Separated Values and click Next.
• Browse to the .csv file you want to import.
• Under Options, choose whether to replace duplicates (existing calendar), create duplicate calendar, or not import duplicates.
• Click Next and choose the destination folder for your calendar, scroll up or down to find it.
• Make sure the check box next to Import "MyCalendar.csv" (assuming that's your file name) is selected.
• Don't click Finish yet, because you'll need to "map" some of the columns in your CSV file to the calendar fields in Outlook.
• Click the Map Custom Fields button. The Map Custom Fields dialog box appears. Mapping can help the your CSV file columns corresponding to Outlook calendar fields.

Hope it helps. If you have any confusion, please reply here, and l will provide further assistance for you, thanks.