Home | University of Exeter



Import to Outlook Calendar from an Excel spreadsheet HYPERLINK "javascript:" Newer versions  HYPERLINK "javascript:" Office 2010 HYPERLINK "javascript:" Office 2007If you have a lot of business or personal contact information that you keep in a spreadsheet, you can import it straight into Outlook 2013 or Outlook 2016 for Windows with just a little preparation. There are three major steps.Download the file and Save to your desktop the Excel workbook as a .csv file.Import your dates.Step 1: Save your Excel workbook as a .csv fileOutlook can import comma separated value (.csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a .csv file. Here’s how:In your workbook, click the worksheet with the information you want to import.Click File > Save As.Choose where to save your file (desktop is easier).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.Step 2: Import your dates to outlook calendarNote:?If you’re importing the .csv file into an account (or another Exchange ActiveSync account) in Outlook 2013, see Import contacts into an account.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.Tip:?If you are prompted to enter a password and you haven't set a password, click Cancel to move to the next window.Choose Comma Separated Values and click Next.Browse to the .csv file you want to import.Under Options, choose whether to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates.Click Next and choose the destination folder for your contacts. Calendar should be selected by default, but if it's not, scroll up or down until you find it. You can also choose a different folder, or create a new one.Click Next.Make sure the check box next to Import "Outlook payroll deadlines.csv" (assuming that's your file name) is selected.Click FinishCheck dates are now in your calendar. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download