Microsoft Excel is one of the most user-friendly spreadsheets available today. Very easy to customise, Excel can be used to record almost anything. A lot of people use Excel to track finances or chores, while many others use it as a calendar. However, it is also easy to use the Microsoft calendar feature in Outlook. Once you have created your calendar in Excel, the data can be easily imported from Microsoft Outlook.
- Skill level:
Other People Are Reading
Customise your Excel. The first thing you will need to do when you are exporting contact or calendar information to Outlook is to customise your spreadsheet. Examine the calendar section in Outlook. You will want to customise the fields in Excel to match the information that Outlook has. For example, when you import your appointments, Outlook has information about the appointment name, subject, location, start time and end time. You would want to title the columns of your Excel spreadsheet to match that information.
Save your data after completing your spreadsheet. Select all of the columns and rows that contain the information you want to import. Include the column headings. To the left of the address bar, type in a name that refers to the selection and press Enter to save it. For example, use "addresses" or "meetings" to name the selection. Save your workbook as Excel 97-2003 compatible. After you have saved it, exit Excel.
Import your information. Open Microsoft Outlook. To import the information, open the "File" menu and select "Import and Export." A dialogue box will open. Select "Import from Another Program or File." Select "Next," then "Microsoft Excel 97-2003." Select "Next" to locate your file. Click on "Browse" and find the Excel worksheet that you saved. Select the spreadsheet and click "Next." This shows the folders that are available to import into Outlook. Highlight the Calendar option and select "Next." You will see a summary of what you have selected. It should read "Import [file name] into folder: calendar," with [file name] representing the name of the Excel file you made, such as "addresses" or "meetings."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for