You can import data from Excel spreadsheet ranges, or Excel files, or CSV (Coma Seperated Values) text file into calendars created within Excel. To do this:
1) Open Microsoft Excel.
2) From the WinCalendar menu in Excel select Calendar Maker or Insert Calendar.
3) Select and setup the following option...
Setup is easy and only needs to be done once (unless import settings change)! On clicking Setup you will have the option of importing from file (CSV / XLS / XLSX / XLSM) or Excel Range.