Question: how to import data into an excel calendar?
Answer: Open the file containing your data in Microsoft Excel. ... 
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. ... 
Open Outlook. ... 
In the "Import and Export Wizard" pop-up window, go to the "Choose an action to perform" section.